ODBC Connectivity
Open Database Connectivity (ODBC) provides a common way to communicate with different database systems.
The Data Integration Service use ODBC drivers to connect to databases.
To use ODBC connectivity, you must install the following components on the machine hosting the Informatica service or client tool:
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 |