When you configure the connection parameters, you configure a connection that points to the same source database that you imported metadata from. You can choose the same connection that you used to import metadata from the source database. However, the connection must have native connectivity to the source database. Data Quality only connect to source databases through native connectivity.

Most of the connection parameters are populated based on the connection name that you choose. In addition, you must specify a source connection string and possibly change the user name and password.

To use the Data Vault as the source database, configure the same connection properties that the retirement job used for the Data Vault target connection.

The connection includes the following parameters:

Connection Name

Name of the connection to the source database. Choose the connection that you used to import metadata from the source database.

Database Type

Database connection type that determines how you connect to the source database. The connection type depends on the database and the database version that contains the source data. Data Quality supports native connectivity only.

By default, the value is populated based on the connection that you choose.

For Data Vault sources, use the

Data Vault Service

connection to connect to the Data Vault. If your applications were retired into the Default Administrator Schema on Data Vault Service, check the

Use Administrator's default schema(dbo)

option.

Database Host

Name of the machine that hosts the source database. By default, the value is populated based on the connection that you choose.

Database Port

Port number used by the source database. By default, the value is populated based on the connection that you choose.

Database Name/SID

Unique identifier or system identifier for the source database server.

The following table describes the database name for each source database:

Source Database	Description	Connect String Syntax
IBM DB2	Name of the remote database configured from the IBM DB2 Connect client.	dbname
Microsoft SQL Server	Name of the host of the Microsoft SQL Server database.	servername@dbname
Oracle	Full service name or SID for Oracle databases. TNS name that is configured from the ILM application server to the database server. The name is defined in the application server TNSNAMES.ORA file.	dbname.world
Data Vault	The ODBC data source name created on the machine hosting Informatica Data Quality.	dsn

By default, the value is populated based on the connection that you choose.

Source Connection String

Connect string that determines how the database native client connects to the database. Data Quality uses the connect string to create a connection object to the source database.

For Oracle, use the TNS name. For IBM DB2, use the database alias. For Microsoft SQL Server, use the remote hostname and database name in the format

<hostname>@<database name>

. For Data Vault, use the ODBC data source name.

User Name

User name that connects to the source database. The user name is the owner of the schema that you want to profile. The user must own the tables that you want to profile and must have privileges to select table catalogs.

For Oracle and IBM DB2, the user name is the same as the schema name.

Password

Password for the database user name.