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.