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

Relational Database Connections

Relational Database Connections

Use a relational connection object for each source, target, lookup, and stored procedure database that you want to access.
The following table describes the properties that you configure for a relational database connection:
Property
Description
Name
Name you want to use for this connection. The connection name cannot contain spaces or other special characters, except for the underscore.
Type
Type of database.
Use Kerberos Authentication
Indicates that the database to connect to runs on a network that uses Kerberos authentication. If this option is selected, you cannot set the user name and password in the connection object. The connection uses the credentials of the user account that runs the session that connects to the database. The user account must have a user principal on the Kerberos network where the database runs.
Informatica supports Kerberos authentication for native relational connections to the following databases: Oracle, DB2, SQL Server, and Sybase.
User Name
Database user name with the appropriate read and write database permissions to access the database.
For Oracle connections that process BLOB, CLOB, or NCLOB data, the user must have permission to access and create temporary tablespaces.
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.
If you use Oracle OS Authentication, IBM DB2 client authentication, or databases such as ISG Navigator that do not allow user names, enter PmNullUser. For Teradata connections, this overrides the default database user name in the ODBC entry.
Not available if the
Use Kerberos Authentication
option is selected.
Use Parameter in Password
Indicates that 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.
Not available if the
Use Kerberos Authentication
option is selected.
Connect String
Connect string used to communicate with the database. For syntax, see Native Connect Strings.
Required for all databases except Microsoft SQL Server and Sybase ASE.
Provider Type
The connection provider that you want to use to connect to the Microsoft SQL Server database.
You can select the following provider types:
  • ODBC
  • Oledb(Deprecated)
Default is ODBC.
Use DSN
Enables the PowerCenter Integration Service to use the Data Source Name for the connection.
If you select the Use DSN option, the PowerCenter Integration Service retrieves the database and server names from the DSN.
If you do not select the Use DSN option, you must provide the database and server names.
Code Page
Code page the Integration Service uses to read from a source database or write to a target database or file.
Connection Environment SQL
Runs an SQL command with each database connection. Default is disabled.
Transaction Environment SQL
Runs an SQL command before the initiation of each transaction. Default is disabled.
Enable Parallel Mode
Enables parallel processing when loading data into a table in bulk mode. Default is enabled.
Database Name
Name of the database. For Teradata connections, this overrides the default database name in the ODBC entry. Also, if you do not enter a database name for a Teradata or Sybase ASE connection, the Integration Service uses the default database name in the ODBC entry. If you do not enter a database name, connection-related messages do not show a database name when the default database is used.
Data Source Name
Name of the Teradata ODBC data source.
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.
Connection Retry Period
Number of seconds the Integration Service attempts to reconnect to the database if the connection fails. If the Integration Service cannot connect to the database in the retry period, the session fails. Default value is 0.
Impersonate User
The name of the impersonate user to connect to Oracle. The user name specified in the Oracle connection must have the impersonate user privileges.
Applicable only for Oracle connections.