Hello,
I want to load all the tables along with the data present within the database schema(i.e, QWEQWE), without using query.
With query we can load data from sql server from multiple tables into elasticsearch as shown in below example.
But i need to load all the tables from sql server by mentioning the database schema, username and password.
Logstash only supports moving data by querying over JDBC. I am not aware of any solution that replicates all tables in a database, and even if such a solution existed, you probably would want to restructure your data into a document-centric model before you move the data as Elasticsearch is not a relational system and does not support joins.
I am not aware off any tool that does this, so the easiest way may be for you to write a script/program using one of the available language clients. Before you do so, do consider how you want to be able to search the data and whether replicating the structure in your relational database will allow you to achieve this.
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.