Knowledge Article

Required JDBC Driver JAR Files

Author

The following table contains required information about the supported driver JAR files for the related databases:

NOTE: This list is not comprehensive. If you use a database that is not listed, contact SailPoint support for assistance.

NOTE: Any .jar file uploaded for the JDBC Source must be compatible with JDK8.

Oracle

The Oracle 11g is not applicable because it in end-of-life as declared here https://support.oracle.com/knowledge/Oracle%20Cloud/2068368_1.html

Download	Oracle Database 12c Release 1 JDBC Driver Downloads
Class Name	oracle.jdbc.driver.OracleDriver
Driver File Name	Choose the needed version of the ojdbc.jar per your Oracle environment.
Database URL Format	jdbc:oracle:thin:@<hostname>:<port>:<SID> If this is a OID (Oracle Internet Directory) instance use this string instead jdbc:oracle:thin:@ldap://<host>:<port>/<SID>,cn=xyz,dc=abc,dc=com. Standard port for a regular Oracle instance is 1521, for OID it is generally 389.
Test Query	select 1 from dual

Download	https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15
Class Name	com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver File Name	Microsoft SQL Server jar file
Database URL Format	jdbc:sqlserver://<hostname>:<port>;DatabaseName=<dbname>
Test Query	select 1

Download	http://jtds.sourceforge.net/
Class Name	net.sourceforge.jtds.jdbc.Driver
Driver File Name	jtds-1.3.1.jar
Database URL Format	jdbc:jtds:sqlserver://<hostname>:<port>;databaseName=<dbname>;useNTLMv2=true;domain=<domainname>;
Test Query	select 1

Download	https://help.sap.com/docs/SAP_SQL_Anywhere/98ad9ec940e2465695685d98e308dff5/3bd588c76c5f10149824867aa281fadd.html?version=17.0
Class Name	com.sybase.jdbc4.jdbc.SybDataSource
Driver File Name	jconn4.jar
Database URL Format	jdbc:sybase:Tds:<hostname>:<port>
Test Query	select getdate()

Download	http://jt400.sourceforge.net/
Class Name	com.ibm.as400.access.AS400JDBCDriver
Driver File Name	jt400.jar
Database URL Format	jdbc:as400://<hostname>/
Test Query	SELECT 1 FROM SYSIBM.SYSDUMMY1

Download	https://dev.mysql.com/downloads/connector/j/
Class Name	com.mysql.cj.jdbc.Driver
Driver File Name	mysql-connector-java-5.1.39-bin.jar
Database URL Format	jdbc:mysql://<hostname>/<dbname>
Test Query	select count(*);

Download	Teradata JDBC Driver \| Teradata Downloads
Class Name	com.teradata.jdbc.TeraDriver
Driver File Name	terajdbc4.jar
Database URL Format	JDBC Type 3: jdbc:teradata://gwhost:port/DatabaseServerName JDBC Type 4: jdbc:teradata://DatabaseServerName
Test Query	SELECT CURRENT_DATE

Download	https://mvnrepository.com/artifact/com.ibm.informix/jdbc
Class Name	com.informix.jdbc.IfxDriver
Driver File Name	ifxjdbc.jar
Database URL Format	jdbc:informix://<hostname>/<dbname>

Download	https://jdbc.postgresql.org/download/
Class Name	org.postgresql.Driver
Database URL Format	jdbc:postgresql://<hostname>/<dbname>