Installation for PowerCenter and Data Quality

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

Back Next

Domain Configuration Repository

After you configure domain security, you can configure domain repository details.

On the

Domain Configuration Repository

page, enter the database and user account information for the domain configuration repository.

The domain configuration repository stores metadata for domain operations and user authentication. The database must be accessible to all gateway nodes in the domain.

The following table describes the properties that you specify for the database and user account:

Property	Description
Database type	Database for the repository. Select one of the following databases: Oracle IBM DB2 Microsoft SQL Server PostgreSQL Sybase ASE
Database user ID	User account for the repository database.
User password	Password for the database user account.

If you select IBM DB2, specify the tablespace for the repository tables:

Property	Description
Tablespace	Name of the tablespace in which to create the tables. Specify a tablespace that meets the pageSize requirement of 32768 bytes. In a single partition database, if this option is not selected, the installer creates the tables in the default tablespace. In a multipartition database, select this option and specify the name of the non-partitioned tablespace that resides in the catalog partition of the database.

Property

Description

Tablespace

Name of the tablespace in which to create the tables. Specify a tablespace that meets the pageSize requirement of 32768 bytes.

In a single partition database, if this option is not selected, the installer creates the tables in the default tablespace.

In a multipartition database, select this option and specify the name of the non-partitioned tablespace that resides in the catalog partition of the database.

If you select Microsoft SQL Server or PostgreSQL, specify the schema for the repository tables and database connection:

Property	Description
Schema name	Name of the schema that will contain the repository tables. If not selected, the installer creates the tables in the default schema.
Trusted connection	Indicates whether to connect to Microsoft SQL Server through a trusted connection. Trusted authentication uses the security credentials of the current user to make the connection to Microsoft SQL Server. If not selected, the installer uses Microsoft SQL Server authentication.

If you enabled secure communication for the domain, you can create the domain configuration repository in a database secured with the SSL protocol. Select the checkbox if you want to secure a database and skip to step 3. .

You cannot configure a secure connection to a Sybase database.

Enter the database connection information.

If you do not create a secure domain configuration repository, you can specify the connection properties for the JDBC URL or provide the JDBC connection string.

To enter the connection information using the JDBC URL, select

JDBC URL

and specify the database connection properties.

The following table describes the JDBC URL properties that you specify:

Property	Description
Database address	Host name and port number for the database in the format host_name:port .
Database service name	Service or database name: Oracle: Enter the service name. Microsoft SQL Server: Enter the database name. IBM DB2: Enter the service name. Sybase ASE: Enter the database name. PostgreSQL: Enter the database name.
JDBC parameters	Optional parameters to include in the database connection string. Use the parameters to optimize database operations for the database. Verify that the parameter string is valid. The installer does not validate the parameter string before it adds the string to the JDBC URL. If not selected, the installer creates the JDBC URL string without additional parameters.

To connect using a custom JDBC connection string, select

Custom JDBC connection string

and type the connection string.

If you choose to secure a database, enter the connection information using a custom JDBC connection string.

If you create the repository on a secure database, you must provide the truststore information for the database. You must also provide a JDBC connection string that includes the security parameters for the database.

The following table describes the properties you must set for a secure database:

Property	Description
Database truststore file	Path and file name of the truststore file for the secure database.
Database truststore password	Password for the truststore file.
Custom JDBC Connection String	JDBC connection string to connect to the secure database, including the host name and port number and the security parameters for the database.

For information about the security parameters you must include in the JDBC connection for a secure database, see Connection String to a Secure Database.

Click

Test Connection

to verify that you can connect to the database, and then click

to continue.

Click

The

Domain Security - Encryption Key

section appears.

Create a Domain

Download Guide

Watch

Comments