Required JDBC Driver JAR Files

[#1]

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.

• Oracle
• Oracle 11g
• Oracle 12c
• SQL Server
• Microsoft
• jTDS Project
• Sybase
• AS400/DB2
• MySQL
• Teradata
• IBM Informix
• PostgreSQL

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

Oracle

Oracle 11g

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  

Oracle 12c

Requirements	Details
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

SQL Server

Microsoft

Requirements	Details
Download	https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?vie...
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

jTDS Project

Requirements	Details
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

Sybase

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

AS400/DB2

Requirements	Details
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

MySQL

Requirements	Details
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(*);

Teradata

Requirements	Details
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

IBM Informix

Requirements	Details
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>

PostgreSQL

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