PowerCenter
- PowerCenter 10.5
- All Products
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.
You can parameterize the connect string attribute for Oracle connections.
|
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:
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.
|