Workflow Basics Guide

Back Next

Native Connect Strings

When you configure a connection object, you must provide connection information. Use native connect string syntax for the following connection types:

Relational database connections.
Use to connect to all databases except Microsoft SQL Server and Sybase ASE.

External loader connection.
Use to connect to all databases.

PowerChannel relational database connections.
Use to connect with all databases except Microsoft SQL Server and Sybase ASE.

PeopleSoft application connections.
Use to connect to the underlying database of the PeopleSoft system for DB2, Oracle, and Informix databases.

The following table lists the native connect string syntax for each supported database when you create or update connections:

Database	Connect String Syntax	Example
IBM DB2	`dbname`	mydatabase
Microsoft SQL Server	`servername`@`dbname` If you want to use SSL encryption, use the following connect string syntax: `servername`@`dbname`;Encrypt=Yes	sqlserver@mydatabase The following example includes SSL encryption: sqlserver@mydatabase;Encrypt=Yes
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@jsmith