# Create single dashboard from two different datasource (Elasticsearch and postgres) is possible in kibana
**URL:** https://discuss.elastic.co/t/create-single-dashboard-from-two-different-datasource-elasticsearch-and-postgres-is-possible-in-kibana/212172
**Category:** Kibana
**Created:** [December 17, 2019, 1:48pm UTC](https://discuss.elastic.co/t/create-single-dashboard-from-two-different-datasource-elasticsearch-and-postgres-is-possible-in-kibana/212172 "2019-12-17T13:48:21Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Amit\_Chauhan](https://discuss.elastic.co/u/Amit_Chauhan)
#### Post date: [December 17, 2019, 1:48pm UTC](https://discuss.elastic.co/t/create-single-dashboard-from-two-different-datasource-elasticsearch-and-postgres-is-possible-in-kibana/212172/1 "2019-12-17T13:48:21Z")
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?
---
### Author:  [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [December 17, 2019, 10:59pm UTC](https://discuss.elastic.co/t/create-single-dashboard-from-two-different-datasource-elasticsearch-and-postgres-is-possible-in-kibana/212172/2 "2019-12-17T22:59:47Z")
It is not possible not connect directly to Postgres from Kibana. You would need to import that data into ES first.
---
### Author:  [@Amit\_Chauhan](https://discuss.elastic.co/u/Amit_Chauhan)
#### Post date: [December 19, 2019, 11:32am UTC](https://discuss.elastic.co/t/create-single-dashboard-from-two-different-datasource-elasticsearch-and-postgres-is-possible-in-kibana/212172/3 "2019-12-19T11:32:58Z")
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?
---
### Author:  [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [December 19, 2019, 11:04pm UTC](https://discuss.elastic.co/t/create-single-dashboard-from-two-different-datasource-elasticsearch-and-postgres-is-possible-in-kibana/212172/4 "2019-12-19T23:04:24Z")
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.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 16, 2020, 11:04pm UTC](https://discuss.elastic.co/t/create-single-dashboard-from-two-different-datasource-elasticsearch-and-postgres-is-possible-in-kibana/212172/5 "2020-01-16T23:04:38Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.