Hello,
I want to load all the tables along with the data present within the database schema, 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.
Is this possible? Please help me.
Ex:
input {
jdbc {
jdbc_driver_library => "C:/Users/xxxx/Downloads/sqljdbc4-2.0.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_connection_string => "jdbc:sqlserver://localhost:1433;user=qqqq;password=vvvv@123;database=QWEQWE"
jdbc_user => "qqqq"
jdbc_password => "vvvv@123"
statement => "SELECT TOP 1000 * FROM SAMPLE"
jdbc_paging_enabled => "true"
jdbc_page_size => "50000"
}
}
I need all tables data without "statement" tag(query) and retrive all tables data.
Is this possible? Thanks in advance.