topic Re: Integrating SAP-Hana support to Activity. in Alfresco Archive

Integrating SAP-Hana support to Activity.

prathameshj — Mon, 14 Mar 2016 10:24:14 GMT

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

Re: Integrating SAP-Hana support to Activity.

jbarrez — Tue, 15 Mar 2016 10:31:07 GMT

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 😉

Re: Integrating SAP-Hana support to Activity.

prathameshj — Tue, 15 Mar 2016 12:16:58 GMT

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.

Re: Integrating SAP-Hana support to Activity.

jbarrez — Fri, 18 Mar 2016 13:17:57 GMT

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)

Re: Integrating SAP-Hana support to Activity.

nitesh009 — Thu, 16 Nov 2017 05:54:59 GMT

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.