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. Upgrade Checklist

Upgrading from Version 10.2 (10.4.0)

Upgrading from Version 10.2 (10.4.0)

Verify the ODBCINST Environment Variable on UNIX

Verify the ODBCINST Environment Variable on UNIX

If the Metadata Manager repository is a Microsoft SQL Server database and the Metadata Manager Service runs on UNIX, verify that the ODBCINST environment variable is set on the machine that runs the PowerCenter Integration Service.
The PowerCenter Integration Service runs the workflows that extract metadata from the IME-based files and load it into the Metadata Manager warehouse. The PowerCenter Integration Service uses ODBC to connect to the Microsoft SQL Server database. On UNIX, the ODBCINST environment variable must be set to the location of the odbcinst.ini file. Otherwise, the PowerCenter Integration Service cannot access the ODBC driver.
On the machine that runs the PowerCenter Integration Service, verify that the ODBCINST environment variable is set to the following value:
ODBCINST=<INFA_HOME>/ODBC7.1/odbcinst.ini
If the environment variable is not set, set the environment variable, and then restart the domain.

0 COMMENTS

We’d like to hear from you!