Hi all,
I am trying to insert the data into the Elasticsearch from SQL Server. When I run the logstash, I am getting this error.
Not eligible for data streams because config contains one or more settings that are not compatible with data streams: {"index"=>"cs_users"} . I am using 8.8.1 .
Configuration >
input {
jdbc {
jdbc_driver_library => "D:\Softwares\Elasticsearch\sqljdbc4-3.0.jar\sqljdbc4-3.0.jar"
jdbc_connection_string => "jdbc:sqlserver://SqlServerMac;databaseName=TestDb;"
jdbc_user => "user"
jdbc_password => "pwd"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
statement => "SELECT * FROM t001_process"
}
}
output {
elasticsearch {
hosts => "localhost:9200"
index => "cs_users"
user => "elastic"
password => "password"
}
stdout { codec => rubydebug }
}
I need the help to solve this issue.
Thank you
Balamurugan.S