Name you want to use for this connection. The connection name cannot contain spaces or other special characters, except for the underscore.

Type of database.

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.

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.

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 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 used to communicate with the database. For syntax, see Native Connect Strings.

Required for all databases except Microsoft SQL Server and Sybase ASE.

You can select the following provider types:

ODBC
Oledb(Deprecated)

Default is ODBC.

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 the Integration Service uses to read from a source database or write to a target database or file.

Runs an SQL command with each database connection. Default is disabled.

Runs an SQL command before the initiation of each transaction. Default is disabled.

Enables parallel processing when loading data into a table in bulk mode. Default is enabled.

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.

Name of the Teradata ODBC data source.

Database server name. Use to configure workflows.

Use to optimize the native drivers for Sybase ASE and Microsoft SQL Server.

The name of the domain. Used for Microsoft SQL Server on Windows.

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.

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.

Applicable only for Oracle connections.