DataDirect Driver Upgrade
On Windows 64-bit and Linux 64-bit operating systems, the following Microsoft SQL Server and Oracle DataDirect drivers have been upgraded in this release:
- •Oracle JDBC: 5.1.4.000318
- •SQLServer JDBC: 5.1.4.000154
- •Oracle ODBC: 07.16.0281 (B0319, U0212)
- •SQLServer ODBC: 07.16.0284
After you upgrade, perform the following tasks:
- Restore the DSN entries
On Linux 64-bit operating systems, before the upgrade, if the odbc.ini file was present in the following directory, the Secure Agent does not retain the file after the upgrade:
<Informatica Secure Agent installation directory>/main
The Secure Agent backs up the <Informatica Secure Agent installation directory>/main directory content in the <Informatica Secure Agent installation directory>/main2 directory.
You must Manually copy the content of the previous odbc.ini file from the main2 directory and add it to the odbc.ini file in the main directory.
Set the value of the ODBCINI variable to <Informatica Secure Agent installation directory>/main/odbc.ini.
Restart the Secure Agent.
On Windows 64-bit operating systems, if you use the ODBC drivers that are packaged with the Secure Agent in a generic ODBC connection, you must delete the corresponding previous Data Source Name (DSN) entries and create new DSN entries with the following registries:
DataDirect CLOSED 7.1 Oracle Wire Protocol for Informatica
DataDirect CLOSED 7.1 SQL Server Wire Protocol for Informatica
- Verify the third-party ODBC or JDBC driver libraries
The Secure Agent backs up the content of the <Informatica Secure Agent installation directory>/main directory in the <Informatica Secure Agent installation directory>/main2 directory after the upgrade.
You must manually copy the ODBC or JDBC driver library files from the main2 directory to the following directory:
<Informatica Secure Agent installation directory>/main
If you use drivers that are not packaged with the Secure Agent, verify that the drivers are compatible with libDWicu27.so. For example, replace the DB2 and Informix drivers DWdb226.so and DWifcl26.so with the later versions DWdb227.so and DWifcl27.so respectively.