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:
If the environment variable is not set, set the environment variable, and then restart the domain.