Looking for a Reporting Solution for Elasticsearch + PostgreSQL Integration

Elastic Stack Elasticsearch
1

I need a reporting solution that works with both Elasticsearch and PostgreSQL. My keys are stored in Elasticsearch, while the main data resides in PostgreSQL.

I do not want to handle the integration or data conversion within my application, as doing so would be too costly for us. Therefore, I’m looking for a third-party tool that can:

  • Connect to both Elasticsearch and PostgreSQL
  • Join data from these two sources using the specified keys
  • Generate reports based on the combined data
2

Welcome!

@swallez gave a talk recently (but in french) about Apache Arrow which might help doing such a thing... Not sure how deep you can go though.

1 Like
3

Thank you for mentioning the talk about Apache Arrow! It sounds like a very useful approach, and I’ll definitely look into it further. I appreciate the insight!