Connecting to Databases from UNIX Overview
To use native connectivity, you must install and configure the database client software for the database that you want to access. To ensure compatibility between the application service and the database, install a client software that is compatible with the database version and use the appropriate database client libraries. To increase performance, use native connectivity.
The Informatica installation includes DataDirect ODBC drivers. If you have existing ODBC data sources created with an earlier version of the drivers, you must create new ODBC data sources using the new drivers. Configure ODBC connections using the DataDirect ODBC drivers provided by Informatica or third party ODBC drivers that are Level 2 compliant or higher.
Use the following guidelines when you connect to databases from Linux or UNIX:
- •Use native drivers to connect to IBM DB2, Oracle, or Sybase ASE databases.
- •You can use ODBC to connect to other sources and targets.