Create single dashboard from two different datasource (Elasticsearch and postgres) is possible in kibana

Elastic Stack Kibana
1

I want to perform analytics on some data in kibana. data will be fetched from two database (postgres and elasticsearch). Analytics will be applied on combined data of these two datasource data. is it possible in kibana?

can Kibana create dashboard on applying joins between two indecis?

2

It is not possible not connect directly to Postgres from Kibana. You would need to import that data into ES first.

3

okay it means firstly we need to import data into elasticsearch in one indices and then need to apply joins with the existing indices of elasticsearch. And then we can create dashboard on updated indices?

4

Elasticsearch doesn't support joins, so if you have documents in Elasticsearch and Postgress that represent the same entity you'll probably want to denormalize that data and put it all in a single index.

5

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