nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Integrating SAP-Hana support to Activity.

prathameshj

Hi All,
I have implemented Activiti BPM in my project which works fine for Oracle. But now I need to develop the same for "SAP Hana" database.
As far as Activiti 5.18 version's documentation suggests Activiti does not support SAP-Hana.
So my questions are,

1) Is there any mechanism by which we can use SAP Hana with Activiti ???
It seems that we need to modify internals of Activiti or even need to develop few additional patches to have it Hana supported.

Please let me know If anybody here is interested in this topic.

Find more posts tagged with

Comments

jbarrez

No, Activiti does not support SAP-HANA.

Things needed to do so are:
- create/delete scripts like the ones in https://github.com/Activiti/Activiti/tree/master/modules/activiti-engine/src/main/resources/org/activiti/db/create
- changes to DbSqlSessionFactory for db specific queries

We would certainly welcome pull requests in this area 😉

prathameshj

Thanks jbarrez,
I have already modified corresponding changes to sql scripts, deployed a database on Hana and its working fine. Even we are able to connect to the SAP Hana through Activiti. But as you said I still need to write query generation part.
However I see lot of xml elements and java layers are involved in it. So any kind of technical inputs regarding query generation will be highly appreciated.

I would love to contribute back to the community.

jbarrez

Normally, you don't need a lot of Java changes. Only the queries that might be different from the default SQL need to be added (for example Task.xml contains all the task related queries. Generally, they are applicable to all databases, but very occasionally (eg for postgres) we add a custom query in that same XML to support that particulary database)

nitesh009

Can you please tell how we can connect through Hana. I have written SQL scripts and added DB mapping too. Anything else I need to do.