Table of Contents

Search

  1. Preface
  2. Introduction to TDM Administration
  3. User and Role Administration
  4. Security Administration
  5. System Preferences
  6. TDM Server Administration
  7. Connections
  8. Pass Phrases
  9. Dictionaries
  10. User-Defined Datatypes

ODBC Connections

ODBC Connections

You can create an ODBC connection in the Test Data Manager to perform data discovery, data subset, and data masking operations.
The following table describes the database connection properties for an ODBC 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 ODBC.
Description
The description of the connection. The description cannot exceed 255 characters.
User Name
Required. The database user name.
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.
Code Page
The code page used to read from a source database or write to a target database or file.
Used for all operations.
Data Access Connection String
The connection string used to access data from the database. Enter <database name>.
Used for all operations.
Environment SQL
SQL commands to set the database environment when you connect to the database. The
PowerCenter Integration Service
runs the connection environment SQL each time it connects to the database.
Used for all operations.
Transaction SQL
SQL commands to set the database environment when you connect to the database. The
PowerCenter Integration Service
runs the transaction environment SQL at the beginning of each transaction.
Used for all operations.
Connection Retry Period
Number of seconds the Integration Service tries to reconnect to the database if the connection fails. If the Integration Service cannot connect to the database in the retry period, the integration object fails.
Used for all operations. Default is 0.
Pass Through Security Enabled
Enables pass-through security for the connection. When you enable pass-through security for a connection, the domain uses the client user name and password to log into the corresponding database, instead of the credentials defined in the connection object.
Used for data discovery operations. Default is disabled.
ODBC Provider
Required. The type of database to which ODBC connects. For pushdown optimization, specify the database type to enable the Integration Service to generate native database SQL. The options are:
  • Other.
  • Sybase.
  • MS SQL Server.
Used for all operations. Default is Sybase.
SQL Identifier Character To Use
Required. The type of character used to identify special characters and reserved SQL keywords, such as WHERE.
The Data Integration Service places the selected character around special characters and reserved SQL keywords. The Data Integration Service also uses this character for the Support Mixed-case Identifiers property.
Select the following characters based on the database in the connection.
  • Double quotes
    " "
  • Single quotes
    ' '
  • Back quotes
    ` `
  • Brackets
    [ ]
Used for data discovery operations.
If you use MongoDB or Cassandra connections with special characters in the names, you must select the double quotes.
You can use the following special characters for MongoDB sources:
/ + - ~ ? , | @ #
Support Mixed Case Identifiers
When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing SQL against these objects in the connection.
Use if the objects have mixed-case or lowercase names. By default, this option is not selected.
Used for data discovery operations.
Use the following driver version for MongoDB:
SimbdaMongoDBODBC Driver Version: 1.8.x.xxx