Native Connectivity
To establish native connectivity between an application service and a database, you must install the database client software on the machine where the service runs.
The Data Integration Service uses native drivers to communicate with source and target databases.
The PowerCenter Integration Service and PowerCenter Repository Service use native drivers to communicate with source and target databases and repository databases.
The following table describes the syntax for the native connection string for each supported database system:
Database | Connect String Syntax | Example |
|---|
IBM DB2 | dbname | mydatabase |
Microsoft SQL Server | servername@dbname | sqlserver@mydatabase |
Oracle | dbname.world (same as TNSNAMES entry) | oracle.world |
Sybase ASE | servername@dbname | sambrown@mydatabase |
Teradata | ODBC_data_source_name or ODBC_data_source_name@db_name or ODBC_data_source_name@db_user_name | TeradataODBC TeradataODBC@mydatabase TeradataODBC@sambrown |