Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Configuring Metadata Manager
  4. Application Resources
  5. Business Glossary Resources
  6. Business Intelligence Resources
  7. Custom Resources
  8. Data Integration Resources
  9. Data Modeling Resources
  10. Database Management Resources
  11. Universal Resources
  12. Managing Resources
  13. Loading and Monitoring Resources
  14. Managing Permissions
  15. Resource Migration
  16. Repository Migration
  17. Appendix A: Metadata Manager Login
  18. Appendix B: Metadata Manager Properties Files
  19. Appendix C: Resource Configuration Files
  20. Appendix D: Glossary

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

Configure Environment Variables on UNIX

Configure Environment Variables on UNIX

When you load a Microsoft SQL Server resource, the PowerCenter Integration Service uses ODBC to connect to the Microsoft SQL Server database. You must set the ODBCINST environment variable to enable the PowerCenter Integration Service to access the ODBC driver.
On the machine that runs the PowerCenter Integration Service, set the ODBCINST environment variable to the location of the odbcinst.ini file. For example:
ODBCINST=<INFA_HOME>/ODBC7.1/odbcinst.ini
Restart the domain after you set the environment variable.

0 COMMENTS

We’d like to hear from you!