Operational Insights

Back Next

Adding a PowerCenter repository

If the domain is a PowerCenter domain, configure a connection to each PowerCenter repository database within the domain. Supply the JDBC connection string used to connect to the PowerCenter repository database. You can optionally provide parameters required to connect to a secure database.

Click

Add PowerCenter Repository

Enter the following required properties:

Property	Description
Database Type	PowerCenter repository database type.
Service Name	Name of the PowerCenter Repository Service that manages the PowerCenter repository database.
Username	User name for the PowerCenter repository database.
Password	Password for the PowerCenter repository database.
JDBC Connection String	JDBC connection string used to connect to the PowerCenter repository database. You can optionally specify a named instance JDBC URL to connect to a SQL Server database. Format the string as follows: jdbc:informatica:sqlserver://<database host name>\<named instance name>;databaseName=<database name> You can also specify a Windows authentication connection string to connect to a SQL Server database using Windows authentication. Format the string as follows: jdbc:informatica:sqlserver://<databse host name>:<database port>;DatabaseName=<database name>;SnapshotSerializable=true;AuthenticationMethod=ntlmjava;Domain=<SQL Server domain name> Note that the connection uses the NTLM authentication scheme.

Enter the following optional properties:

Property	Description
Secure JDBC Parameters	Secure database parameters if the PowerCenter repository database is secured with the SSL protocol.
Schema Name	Schema name in the PowerCenter repository database that contains monitoring data. To find this value in the Administrator tool, select the Services and Nodes view, and then select the PowerCenter Repository Service instance in the Domain Navigator.
Table Name	Table in the PowerCenter repository database that contains monitoring data. To find this value in the Administrator tool, select the Services and Nodes view, and then select the PowerCenter Repository Service instance in the Domain Navigator.