The Reporting Service is an application service that runs the Data Analyzer application in an Informatica domain. Create and enable a Reporting Service on the
tab of the Administrator tool.
When you create a Reporting Service, choose the data source to report against:
PowerCenter repository. Choose the associated PowerCenter Repository Service and specify the PowerCenter repository details to run PowerCenter Repository Reports.
Metadata Manager warehouse. Choose the associated Metadata Manager Service and specify the Metadata Manager warehouse details to run Metadata Manager Reports.
Other reporting sources. Choose the Other Reporting Sources option and specify the data warehouse details to run custom reports.
Data Analyzer stores metadata for schemas, metrics and attributes, queries, reports, user profiles, and other objects in the Data Analyzer repository. When you create a Reporting Service, specify the Data Analyzer repository details. The Reporting Service configures the Data Analyzer repository with the metadata corresponding to the selected data source.
You can create multiple Reporting Services on the same node. Specify a data source for each Reporting Service. To use multiple data sources with a single Reporting Service, create additional data sources in Data Analyzer. After you create the data sources, follow the instructions in the
Schema Designer Guide
to import table definitions and create metrics and attributes for the reports.
When you enable the Reporting Service, the Administrator tool starts Data Analyzer. Click the URL in the Properties view to access Data Analyzer.
The name of the Reporting Service is the name of the Data Analyzer instance and the context path for the Data Analyzer URL. The Data Analyzer context path can include only alphanumeric characters, hyphens (-), and underscores (_). If the name of the Reporting Service includes any other character, PowerCenter replaces the invalid characters with an underscore and the Unicode value of the character. For example, if the name of the Reporting Service is ReportingService#3, the context path of the Data Analyzer URL is the Reporting Service name with the # character replaced with _35. For example:
Effective in version 10.1, Informatica deprecated the Reporting Service. Informatica will drop support for the Reporting Service in a future release.
If you upgrade to version 10.1, you can continue to use the Reporting Service. Informatica recommends that you begin using a third-party reporting tool before Informatica drops support. You can use the recommended SQL queries for building all the reports shipped with earlier versions of PowerCenter.
If you install version 10.1, you cannot create a Reporting Service. You must use a third-party reporting tool to run PowerCenter and Metadata Manager reports.
For information about the PowerCenter Reports, see the
Informatica PowerCenter Using PowerCenter Reports Guide
. For information about the PowerCenter repository views, see the
Informatica PowerCenter Repository Guide
. For information about the Metadata Manager repository views, see the
Informatica Metadata Manager View Reference