How To Set Up Database Connections for Third Party JDBC Drivers Such as Microsoft SQL Server, Sybase, PostgreSQL, etc (Doc ID 423914.1)

Last updated on NOVEMBER 02, 2022

Applies to:

Goal

What are the best practices for Oracle Data Integrator (ODI) 12c, 11g and 10g in terms of setting up JDBC connections to third party database software such as:

IBM DB2UDB
IBM Informix
Kafka
Microsoft SQL Server
PostgreSQL
Sybase
Teradata
...

Are there any known compatibility issues?

In particular, when attempting to connect to Microsoft SQL Server (2000/2005) with Microsoft JDBC Driver using the following URL:

jdbc:microsoft:sqlserver://<HOST>:1433

    the following error messages may be displayed:

connection failed
java.lang.Exception: com.sunopsis.sql.e: com.microsoft.jdbc.sqlserver.SQLServerDriver
at com.sunopsis.graphical.b.gr.a(gr.java)

java.sql.SQLException [MS SQL Server 2000 JDBC Driver] Can't start cloned connection while in manual transaction mode.

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""): Data type 0x38 is unknown.

Connection failed
JDBC connection error
com.sunopsis.sql.c: com.microsoft.jdbc.sqlserver.SQLServerDriver

Please refer to <Document 424428.1> for frequently displayed error messages.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.