Configure the PowerCenter Repository collector, which collects and uploads runtime workflow and session metrics from PowerCenter repositories within the domain. You must select PowerCenter in the list of products used by the domain on the Domain Connection panel to configure the collector.
You must configure the connection to each PowerCenter repository database in the domain.
The default collection frequency is every 1 hour. You can create a custom schedule if needed to better suit your requirements.
The collector is disabled by default. Select the Enabled checkbox to enable the collector.
Collecting historical data
You can configure the collector to populate Operational Insights with up to 60 days of historical data.
Historical data is collected for the previous 30 days by default. However you can specify any number of days between 1 and 60.
Data collection begins at the time the domain is added to Operational Insights. Roughly 24 hours worth of data is collected every hour, meaning that approximately 30 hours are required to populate Operational Insights with data for the prior month.
Historical data collection is enabled by default. Clear the Collect Historical Data checkbox to disable historical data collection.
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.
1Click Add PowerCenter Repository.
2Enter 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:
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.
3Enter 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.
4Select the Enable Repository checkbox to enable the collector to collect data from the repository.
5Click Test Connection to verify the connection configuration.
6Click Save to save the connection details.
7Repeat this process for each PowerCenter repository in the domain.
Configure the Collector Schedule
You can configure a custom schedule for the collector. The schedule you create overrides the default collector schedule.
Enter the following properties:
Property
Description
Repeats
The interval at which to repeat collection.
Repeats Frequency
The frequency at which to perform collection.
The frequency is based on the repetition value you select. For example, to collect data every two hours, select Hourly as the repetition, and then set the frequency value to 2.
Starts on
The date and time the custom schedule takes effect.