What all are the integration points for plugging custom DB with flowable?

Flowable Engine
1

Currently Flowable has support for few databases. But we want to use a custom datasource with our SpringBoot 2 flowable 6.4.0 project.

We have done following custom changes
0)Adding the custom datasource maven dependency.
1)JDBC datasource properties in application.properties.
2)Prepared custom SQL’s referencing https://github.com/flowable/flowable-engine/tree/flowable-6.4.0/distro/sql
3) Setting datbaseType to custom type.

Yet this does not suffice. Where else custom implementation will be required?

2

Have you looked at the examples of integrations with MongoDB and CockroachDB?


http://www.jorambarrez.be/blog/2016/11/02/running-flowable-on-cockroachdb/

Cheers
Paul.

1 Like
4

Yes.

The example with CockroachDB worked with simple configurations as it was over Postgres and Postgres is supported by flowable by default.

MongoDB example is a full fledged example for integrating a NoSql database.

In my case , I want to plug in a DB which already has a SQL JDBC interface available. Will I still require all integration points as in MongoDB?

5

No, in that case the default engine should suffice and configuring the datasource is all what’s needed. Which database are you using? Is it compatible with any of the supported JDCB databases of Flowable?

6

I am trying to use Apache Hbase over Apache Phoenix.