Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Session Properties Reference
  17. Workflow Properties Reference

Native Connect Strings

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
Teradata1
ODBC_data_source_name
or
ODBC_data_source_name
@
db_name
or
ODBC_data_source_name
@
db_user_name
TeradataODBC
TeradataODBC@mydatabase
TeradataODBC@jsmith