Search

Administrator Guide

Administrator Guide

10.5.6
- 10.5.7
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Sybase Connections

Sybase Connections

You can create a Sybase connection in Test Data Manager to perform data subset and data masking operations.

The following table describes the database connection properties for a Sybase database:

Property	Description
Name	Required. Name of the connection. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters, start with a number, contain spaces, or contain the following special characters: ~ ` ! $ % ^ & * ( ) - + = { [ } ] \| \ : ; " ' < , > . ? /
Connection Type	Required. The connection type. Select Sybase.
Description	The description of the connection. The description cannot exceed 255 characters.
Use Kerberos Authentication	Enables Kerberos Authentication. You cannot enter a user name and password if you select this check box.
User Name	Required. The database user name.
User 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 using the pmpasswd CRYPT_DATA option. Used for data subset and data masking operations. Default is disabled.
Password	Required. The password for the database user name.
Owner	The owner of the connection. Default is the user who creates the connection. You can change the owner of the connection.
Metadata Connection String	Required. The JDBC connection URL used to access metadata from the database. Enter jdbc:informatica:sybase://<hostname>:5000;DatabaseName=<databasename>.
JDBC Login Password	Required if Use Parameter in Password is selected. The password for the JDBC user. Used for import from source and data discovery operations.
Code Page	Code page the Integration Service uses to read from a source database or write to a target database or file.
Data Access Connection String	The connection string used to access data from the database. Enter <database name>.
Environment SQL	SQL commands to set the database environment when you connect to the database. The Integration Service runs the connection environment SQL each time it connects to the database. To run workflows with table or column names that are case sensitive, or contain special characters, or reserved keywords, you must set the value to `SET QUOTED_IDENTIFIER ON`.
Transaction SQL	SQL commands to set the database environment when you connect to the database. The Integration Service runs the transaction environment SQL at the beginning of each transaction.
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 operation fails. Default is 0.
Database Name	Required. 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. Used for all operations.
Server Name	Required. Database server name.
Packet Size	Packet size for the transmission of data. Use to optimize the native drivers. Default is 0.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.