Load sql server data into elasticsearch without query


#1

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.


(Christian Dahlqvist) #2

This seems to be a duplicate of this issue. Please do not open multiple threads for the same question/issue.


#3

sorry, this happened by mistake,


(system) #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.