Table of Contents

Search

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

Upgrading from Version 10.4.0 and Later (10.5.4)

Upgrading from Version 10.4.0 and Later (10.5.4)

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!