Table of Contents

Search

  1. Preface
  2. Upgrade Overview
  3. Before You Upgrade the Domain on Linux
  4. Before You Upgrade the Domain on UNIX
  5. Before You Upgrade the Domain on Windows
  6. Prepare for the Upgrade
  7. Upgrade the Domain
  8. Upgrade the Domain with Changes to Node Configuration
  9. Before You Upgrade the Application Services
  10. Application Service Upgrade
  11. Informatica Client Upgrade
  12. After You Upgrade
  13. Appendix A: Upgrade Checklist
  14. Appendix B: Managing Distribution Packages

Upgrading from Version 10.2 (10.5.4)

Upgrading from Version 10.2 (10.5.4)

Update the DataDirect Drivers

Update the DataDirect Drivers

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.

0 COMMENTS

We’d like to hear from you!