We are in the process of migrating our MSSQL database to an elasticsearch platform, and have run into the (apparently common) problem of many parents to one child relationship, when trying to access information from multiple tables. It seems Kibi is capable of allowing these type of relationships to exist, however has only been optimized for ES 4.2. Has anyone found a way to use Kibi , as opposed to Kibana on the newest ES?
PS. changing the DB is not an option, as this is a proof of concept only.
No it isn't. I'm assuming you want to join multiple document types in a visualization, so I'd suggest using the Logstash config to create a document which combines related fields from other documents. You can do so using this plugin: https://www.elastic.co/guide/en/logstash/current/plugins-filters-elasticsearch.html#plugins-filters-elasticsearch-fields