Table views synched from a graph DB

[Riccardo Fanciulli]

Hello,

we have just created a new CRM service based on ArangoDB (graph).

In our system, based on microservices (most work with a relational DB), we have a need to create a data warehouse (intended as a collection of tables (relational) on which our reports-building engine and other tools can get their data). Getting the data separately from each service via API is not an option.

Now, the question: 

Has any of you had this same type of need, namely, filling views in a relational DB from an arangoDB graph and keeping them in synch? I could see a service doing it, triggered via Kafka etc.

What was your approach?

Thank you to anyone willing to help