I'm currently in a POC stage in a project and have to collect data from a MS SQL Server.
I am using jdbc-input-plugin to connect to the database.
jdbc_driver_library => "C:\jdbc\jdbc_driver\sqljdbc_6.0\enu\sqljdbc42.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_connection_string => "jdbc:sqlserver://localhost:1433;Data Source=;Initial Catalog=;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"
jdbc_user => ""
schedule => "* * * * *"
statement => "SELECT * FROM dbo.tblActivityLog"
codec => 'rubydebug'
jdbc-user is a required field in the jdbc plugin, but seems to stop me from using integrated security. I have tried different versions, including an empty jdbc-user, the windows user (with and without the password), and other users that should have access.
I get "Login failed for user for all attempts.
Is there a workaround for using Integrated security, or maybe another software I can use for forwarding to logstash (similar to winlogbeat for eventlogs)?
Let me know if more information is needed.
Edit: I see there is a github issue for this from february github issue
The Issue does not look like a priority for the devs, since the other issues have priorityflags.