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.
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
Requirements | Details |
---|---|
Download |
|
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 |
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 |
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 |
Requirements | Details |
---|---|
Download |
|
Class Name | com.sybase.jdbc4.jdbc.SybDataSource |
Driver File Name |
jconn4.jar |
Database URL Format | jdbc:sybase:Tds:<hostname>:<port> |
Test Query | select getdate() |
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 |
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(*); |
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 |
Is anyone using the jTDS driver with a SQL Server 2016 database?
This article(open the last section about 'Why Change drivers') raises some concerns with Hibernate and jTDS with BitBucket Server:
Does anyone know where to get ifxjdbc.jar - support had installed but I can not find anywhere.
I think it should be a part of IBM's Informix installation.
Please check https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.jdbc_pg.doc/ids_jdbc_013.htm
After the JDBC driver for MS SQL has been replaced and updated for IIQ 8.1, how may I verify through the IdentityIQ application it is using the updated JDBC driver? This information is not listed on the debug/about.jsf page. Is there a simple rule that can be created to output the driver version or other method to use for confirming successful updating?
Hi all, does anyone know what might be the issue for the below error?
[ ConnectorException ] [ Error details ] The server encountered an unexpected error while contacting target system. Please check the logs. Failure trying to get a pooled connection to [jdbc:mysql://xxxx:xxxx] com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Currently we are trying to connect to a mysql database on AWS RDS. we are using the default JDBC driver com.mysql.cj.jdbc.Driver.
Please let me know if anyone is aware about this.
Thanks
Hi and for postgresql is it https://jdbc.postgresql.org/
postgresql-42.7.1.jar
class org.postgresql.Driver ??
Does anyone know where to find these files in the cloud tenant and/or on the VA's related to IDN? Use case is ensuring the exact same file is copied/deployed from SBX to PRD.