Table of Contents

Search

  1. Preface
  2. Understanding Domains
  3. Managing Your Account
  4. Using Informatica Administrator
  5. Using the Domain View
  6. Domain Management
  7. Nodes
  8. High Availability
  9. Connections
  10. Connection Properties
  11. Schedules
  12. Domain Object Export and Import
  13. License Management
  14. Monitoring
  15. Log Management
  16. Domain Reports
  17. Node Diagnostics
  18. Understanding Globalization
  19. Managing Distribution Packages
  20. Appendix A: Code Pages
  21. Appendix B: Custom Roles
  22. Appendix C: Informatica Platform Connectivity
  23. Appendix D: Configure the Web Browser

Administrator Guide

Administrator Guide

ODBC Connectivity

ODBC Connectivity

Open Database Connectivity (ODBC) provides a common way to communicate with different database systems.
To use ODBC connectivity, you must install the following components on the machine hosting the Informatica service or client tool:
  • Database client software.
    Install the client software for the database system. This installs the client libraries needed to connect to the database.
    Some ODBC drivers contain wire protocols and do not require the database client software.
  • ODBC drivers.
    The DataDirect closed 32-bit or 64-bit ODBC drivers are installed when you install the Informatica services. The DataDirect closed 32-bit ODBC drivers are installed when you install the Informatica clients. The database server can also include an ODBC driver.
After you install the necessary components you must configure an ODBC data source for each database that you want to connect to. A data source contains information that you need to locate and access the database, such as database name, user name, and database password. On Windows, you use the ODBC Data Source Administrator to create a data source name. On UNIX, you add data source entries to the odbc.ini file found in the system $ODBCHOME directory.
When you create an ODBC data source, you must also specify the driver that the ODBC driver manager sends database calls to.
The following table shows the recommended ODBC drivers to use with each database:
Database
ODBC Driver
Requires Database Client Software
Informix
DataDirect Informix Wire Protocol
No
Microsoft Access
Microsoft Access driver
No
Microsoft Excel
Microsoft Excel driver
No
Microsoft SQL Server
DataDirect SQL Server Wire Protocol
No
Netezza
Netezza SQL
Yes
Teradata
Teradata ODBC driver
Yes
SAP HANA
SAP HANA ODBC driver
Yes

0 COMMENTS

We’d like to hear from you!