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

PowerChannel Relational Database Connections

PowerChannel Relational Database Connections

Use a relational connection object for each database that you want to access through PowerChannel. If you have configured a relational database connection, and you want to create a PowerChannel connection, you can copy the connection.
The following table describes the properties that you configure for a PowerChannel relational database connection:
Property
Description
Name
Connection name used by the Workflow Manager. Connection name cannot contain spaces or other special characters, except for the underscore.
Type
Type of database.
User Name
Database user name with the appropriate read and write database permissions to access the database. If you use Oracle OS Authentication, IBM DB2 client authentication, or databases such as ISG Navigator that do not allow user names, enter PmNullUser.
To define the user name in the parameter file, enter session parameter $Param
Name
as the user name, and define the value in the session or workflow parameter file. The Integration Service interprets user names that start with $Param as session parameters.
Use Parameter in Password
Indicates the password for the database user name is a session parameter, $Param
Name
. Define the password in the workflow or session parameter file, and encrypt it by using the
pmpasswd
CRYPT_DATA option. Default is disabled.
Password
Password for the database user name. For Oracle OS Authentication, IBM DB2 client authentication, or databases such as ISG Navigator that do not allow passwords, enter PmNullPassword. For Teradata connections, this overrides the database password in the ODBC entry.
Passwords must be in 7-bit ASCII.
Connect String
Connect string used to communicate with the database. For syntax, see Native Connect Strings.
Required for all databases except Microsoft SQL Server.
Code Page
Code page the Integration Service uses to read from a source database or write to a target database or file.
Database Name
Name of the database. If you do not enter a database name, connection-related messages do not show a database name when the default database is used.
Environment SQL
Runs an SQL command with each database connection. Default is disabled.
Rollback Segment
Name of the rollback segment.
Server Name
Database server name. Use to configure workflows.
Packet Size
Use to optimize the native drivers for Sybase ASE and Microsoft SQL Server.
Domain Name
The name of the domain. Used for Microsoft SQL Server on Windows.
Use Trusted Connection
If selected, the Integration Service uses Windows authentication to access the Microsoft SQL Server database. The user name that starts the Integration Service must be a valid Windows user with access to the Microsoft SQL Server database.
Remote PowerChannel Host Name
Host name or IP address for the remote PowerChannel Server that can access the database data.
Remote PowerChannel Port Number
Port number for the remote PowerChannel Server. Make sure the PORT attribute of the ACTIVE_LISTENERS property in the
PowerChannel
.properties file uses a value that other applications on the PowerChannel Server do not use.
Use Local PowerChannel
Select to use compression or encryption while extracting or loading data. When you select this option, you need to specify the local PowerChannel Server address and port number. The Integration Service uses the local PowerChannel Server as a client to connect to the remote PowerChannel Server and access the remote database.
Local PowerChannel Host Name
Host name or IP address for the local PowerChannel Server. Enter this option when you select the Use Local PowerChannel option.
Local PowerChannel Port Number
Port number for the local PowerChannel Server. Specify this option when you select the Use Local PowerChannel option. Make sure the PORT attribute of the ACTIVE_LISTENERS property in the
PowerChannel
.properties file uses a value that other applications on the PowerChannel Server do not use.
Encryption Level
Encryption level for the data transfer. Encryption levels range from 0 to 3. 0 indicates no encryption and 3 is the highest encryption level. Default is 0.
Use this option only if you have selected the Use Local PowerChannel option.
Compression Level
Compression level for the data transfer. Compression levels range from 0 to 9. 0 indicates no compression and 9 is the highest compression level. Default is 2.
Use this option only if you have selected the Use Local PowerChannel option.
Certificate Account
Certificate account to authenticate the local PowerChannel Server to the remote PowerChannel Server. Use this option only if you have selected the Use Local PowerChannel option.
If you use the sample PowerChannel repository that the installation program set up, and you want to use the default certificate account in the repository, you can enter “default” as the certificate account.