SDI supports various MSSQL JDBC drivers. Please reference the PAM (Supported Adapters section) for the most updated list of the supported drivers.
The chosen JDBC driver should be compatible with your MSSQL database version, and match the Java version of the DP Agent (jre8 by default). In general, the highest compatible JDBC driver version should be selected.
When you have determined a suitable JDBC driver version, place the *.jar file in the <DPAgent_root>/lib folder.
The following table attempts to provide an overview of compatibility for each each driver supported by SDI. As of DPAgent version 2.6.2:
| Driver Version | Database Versions |
|---|---|
4.2 (sqljdbc-4.2.jar) | MSSQL 2016, 2014, 2012, 2008 R2 |
| 6.0 (sqljdbc41.jar or sqljdbc42.jar) | MSSQL 2016, 2014, 2012, 2008 R2 |
| 6.2 (mssql-jdbc-6.2.2.jre8.jar or mssql-jdbc-6.2.2.jre7.jar) | MSSQL 2017, 2016, 2014, 2012, 2008 R2 |
| 6.4 (mssql-jdbc-6.4.0.jre8.jar) | MSSQL 2017, 2016, 2014, 2012, 2008 R2 |
| 7.2 (mssql-jdbc-7.2.2.jre8.jar) | MSSQL 2017, 2016, 2014, 2012, 2008 R2 |
| 8.4 (mssql-jdbc-8.4.1.jre8.jar) | MSSQL 2019, 2017, 2016, 2014, 2012 |
| 9.2 (mssql-jdbc-9.2.0.jre8.jar) | MSSQL 2019, 2017, 2016, 2014, 2012 |
Refer to Microsoft's documentation for an official matrix of JDBC driver to Database supportability.