Update the DataDirect Oracle ODBC and SQL Server ODBC driver files. If an existing connection is using the DataDirect SQL Server Legacy ODBC driver, you must use the DataDirect 8.0 New SQL Server Wire Protocol.
DataDirect Oracle ODBC Driver
The DataDirect Oracle Wire Protocol is upgraded from version 7.1 to 8.0. On Windows, the DataDirect Oracle ODBC driver is upgraded from
DWora27.dll
to
DWora28.dll
. On Linux, the driver is upgraded from
DWora27.so
to
DWora28.so
. Existing ODBC connections that use the Oracle ODBC driver
DWora27.so
fail.
After the upgrade, perform the following tasks:
On Linux, if you want to use an existing ODBC connection to connect to an Oracle database, you must update the
odbc.ini
file to point to the ODBC driver path that contains the
DWora28.so
file.
On Windows, if you want to use an existing ODBC connection to connect to an Oracle database, you must create a new data source using the DataDirect 8.0 Oracle Wire Protocol driver.
DataDirect SQL Server Legacy ODBC Driver
Informatica dropped support for the DataDirect SQL Server Legacy ODBC Driver file
DWmsss27.x
because DataDirect no longer supports this driver. After you upgrade, existing ODBC connections that use the DataDirect SQL Server Legacy ODBC Driver file
DWmsss27.x
fail. You must use the DataDirect 8.0 New SQL Server Wire Protocol packaged with the Informatica installer, or any ODBC driver from a third-party vendor.
DataDirect SQL Server ODBC driver
The DataDirect SQL Server ODBC driver is upgraded from
DWsqls27.so
to
DWsqls28.so
on Linux. On Windows, the DataDirect SQL Server ODBC driver is upgraded from
DWsqls27.dll
to
DWsqls28.dll
. Existing connections that use the DataDirect SQL Server ODBC driver
DWsqls27.so
on Linux or
DWsqls27.dll
on Windows fail.
After the upgrade, perform the following tasks on Linux:
To use an existing Microsoft SQL Server connection with the Use DSN property enabled in the connection, you must update the
odbc.ini
file to point to the ODBC driver path that contains the
DWsqls28.so
file.
To use an existing ODBC connection that used the
DWsqls27.so
driver, you must update the
odbc.ini
file to point to the ODBC driver path that contains the
DWsqls28.so
file.
After the upgrade, perform the following tasks on Windows:
To use an existing Microsoft SQL Server connection with the Use DSN property enabled in the connection, you must create a new data source for the Microsoft SQL Server database using the DataDirect 8.0 New SQL Server Wire Protocol driver.
To use an existing ODBC connection that used the DataDirect 7.1 New SQL Server Wire Protocol driver, you must create a new data source for the Microsoft SQL Server database using the DataDirect 8.0 New SQL Server Wire Protocol driver.