MS SQL to Elastisearch

Hi guys, i need to create visualizations for ms sql Data , and i found out that it is possible to duplicate data into elasticsearch , Questions : How does elasticsearch manages relations between tables ? And what are things that it offers better than just exploring using other tools ?

Hi @Haitam_Dadsi,

I am not sure I understand the connection between MSSQL and Elasticsearch regarding visualizations.... same goes for you statement "things that it offers better than just exploring using other tools". Can you detail?

Regarding relationships, you basically have nested documents and parent-child relationships (or join datatype as it called in newer ES versions). But, what I highly recommend reading is this section of the guide which, even if it's for older ES versions, it still applies to newer versions as well.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.