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,

  1. Login to the edge node
  2. cd $IW_HOME/bin ; source env.sh


  3. 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   


                                                         
  4. 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