Hi Guys,
do you know any ETL tool where is possible to have a connector to ElasticSearch and get all data that i need?
I was trying talend studio (big data) and oracle data integrator, but without results.
if with this tools i cannot find a way to extract the data, Do you think that is better extract data and write it to a file and after use the ETL tool to load data from file?
I have data in elasticsearch and i want to create dashboards in powerBI with some data saved on ElasticSearch. So, my intention is create a ETL process that load data from ES, treat the data and insert the new data on Data Warehouse (im using MySQL).
My problem, is that i didnt find any connector for elasticsearch, on Talend Big Data Studion (free edition) neither on ODI oracle.
Do i need to export the data to files and after use the ETL tool or do you know some other way to do that?
Thank you, i didn't try yet.
PowerBI you can create more "professional" dashboards and create reports for customers. I use kibana but just inside team.
Yes. logstash would work perfectly for this use case - you can read the data from elasticsearch, apply any transformations needed and then load to mysql directly or output to a file and load from that.
An alternative approach, if you don't want to use Logstash, you can use Pentaho with a few lines of simple custom python code that you could customize to do what you want.
The CData Elasticsearch Drivers (https://www.cdata.com/drivers/elasticsearch/) should be able to plug-in to just about any ETL tool and help you accomplish what you are trying to do. The driver interfaces are supported by every modern data movement application.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.