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.

[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/acti...
- 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.

[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.

[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)