Problem Description
The old SQL JDBC drivers were not supporting windows based authentication. In order to use AD windows authentication in Infoworks SQL source, we were using JTDS driver. But now the latest Microsoft SQL JDBC driver supports Windows AD-based authentication.
Solution
Please follow the below steps to configure a SQL server source with Windows AD based authentication,
- Login to the edge node
cd $IW_HOME/bin ; source env.sh
- Download latest mssql driver from below link & put it under $IW_HOME/lib/shared/ and move the older sqljdbc41.jar to a temporary location
https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc/7.4.1.jre8
- Set the Connection string format similar to below in the SQL server source configuration setup
jdbc:sqlserver://secret.foo.local;integratedSecurity=true;authenticationScheme=NTLM;domain=XX;databaseName=mydb
Applicable IWX versions
Datafoundry 2.9.x, 3.x