# Persisting async history data in NoSQL DB

**URL:** <https://forum.flowable.org/t/persisting-async-history-data-in-nosql-db/1246>\
**Category:** Flowable Engine\
**Created:** [November 22, 2017, 9:54am UTC](https://forum.flowable.org/t/persisting-async-history-data-in-nosql-db/1246 "2017-11-22T09:54:44Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![mtmanju](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/mtmanju/32/388_2.png) [@mtmanju](https://forum.flowable.org/u/mtmanju)\
**Post date:** [November 22, 2017, 9:54am UTC](https://forum.flowable.org/t/persisting-async-history-data-in-nosql-db/1246/1 "2017-11-22T09:54:44Z")

</div>

Hi Flowable team,

We are using flowable spring boot version 6.2.0 need to separate the Runtime data (goes into MySQL DB) and History data (goes into Cassandra/MongoDB)

I have enabled these configurations:

> flowable.database-schema-update=true  
> flowable.async-executor-activate=true  
> flowable.history-level=full  
> flowable.db-history-used=false  
> flowable.db-identity-used=true

After this configurations i have deployed my application only the runtime tables got created in mysql db, but i need to add a new datasource for other NoSQL DB to store history data.

How can this be done ?

Thanks,  
Manjunath

---

<div class="post-metadata">

**Author:** ![joram](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joram/32/26_2.png) [@joram](https://forum.flowable.org/u/joram)\
**Post date:** [November 25, 2017, 12:14pm UTC](https://forum.flowable.org/t/persisting-async-history-data-in-nosql-db/1246/2 "2017-11-25T12:14:47Z")

</div>

Have a look at the async history example: [https://github.com/flowable/flowable-examples/tree/master/async-history](https://github.com/flowable/flowable-examples/tree/master/async-history) or this example: [https://github.com/flowable/flowable-examples/tree/master/demo/demo-introducing-machine-learning/demo-process](https://github.com/flowable/flowable-examples/tree/master/demo/demo-introducing-machine-learning/demo-process). You can use the async history to have a queue in between and them send it to Cassandra/MongoDB. Note that this can’t be configured through properties yet, so you’ll need a Spring bean configuration if the process engine config and processEngine.

---

<div class="post-metadata">

**Author:** ![mtmanju](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/mtmanju/32/388_2.png) [@mtmanju](https://forum.flowable.org/u/mtmanju)\
**Post date:** [November 27, 2017, 4:35am UTC](https://forum.flowable.org/t/persisting-async-history-data-in-nosql-db/1246/3 "2017-11-27T04:35:37Z")

</div>

Thanks @joram.

So, I need to publish all the async history to Rabbit MQ and from there i need to have a listener which listens to that message and then persist the data to the tables i have created manually right ? And also, I have to create the tables manually by myself right?

Thanks,  
Manjunath

---

<div class="post-metadata">

**Author:** ![joram](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joram/32/26_2.png) [@joram](https://forum.flowable.org/u/joram)\
**Post date:** [December 13, 2017, 9:12am UTC](https://forum.flowable.org/t/persisting-async-history-data-in-nosql-db/1246/4 "2017-12-13T09:12:21Z")

</div>

@mtmanju : sorry missed your response.  
Yes - indeed: you’ll need to create the tables yourself, and in the listener you can do whatever you want with the json that comes in.  
Also, doesn’t need to be RabbitMQ, can be any message queue or protocol :-).

---

<div class="post-metadata">

**Author:** ![mtmanju](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/mtmanju/32/388_2.png) [@mtmanju](https://forum.flowable.org/u/mtmanju)\
**Post date:** [December 13, 2017, 11:10am UTC](https://forum.flowable.org/t/persisting-async-history-data-in-nosql-db/1246/5 "2017-12-13T11:10:26Z")

</div>

Thanks @joram 🙂

---

<div class="post-metadata">

**Author:** ![tiru.sadul](https://avatars.discourse-cdn.com/v4/letter/t/e56c9b/32.png) [@tiru.sadul](https://forum.flowable.org/u/tiru.sadul)\
**Post date:** [September 6, 2018, 12:06pm UTC](https://forum.flowable.org/t/persisting-async-history-data-in-nosql-db/1246/6 "2018-09-06T12:06:34Z")

</div>

Hi @mtmanju

can please tell how did you done the same problem, Actually i am new in the flowable  
i need to persist the flowable history data into mongo db