Reporting Service Overview
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 Manage 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 Data Analyzer 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:
http://<HostName>:<PortNumber>/ReportingService_353
Deprecated Behavior
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.
PowerCenter Repository Reports
When you choose the PowerCenter repository as a data source, you can run the PowerCenter Repository Reports from Data Analyzer.
PowerCenter Repository Reports are prepackaged dashboards and reports that allow you to analyze the following types of PowerCenter repository metadata:
- •Source and target metadata. Includes shortcuts, descriptions, and corresponding database names and field-level attributes.
- •Transformation metadata in mappings and mapplets. Includes port-level details for each transformation.
- •Mapping and mapplet metadata. Includes the targets, transformations, and dependencies for each mapping.
- •Workflow and worklet metadata. Includes schedules, instances, events, and variables.
- •Session metadata. Includes session execution details and metadata extensions defined for each session.
- •Change management metadata. Includes versions of sources, targets, labels, and label properties.
- •Operational metadata. Includes run-time statistics.
Metadata Manager Repository Reports
When you choose the Metadata Manager warehouse as a data source, you can run the Metadata Manager Repository Reports from Data Analyzer.
Metadata Manager is the PowerCenter metadata management and analysis tool.
You can create a single Reporting Service for a Metadata Manager warehouse.
Data Profiling Reports
When you choose the Data Profiling warehouse as a data source, you can run the Data Profiling reports from Data Analyzer.
Use the Data Profiling dashboard to access the Data Profiling reports. Data Analyzer provides the following types of reports:
- •Composite reports. Display a set of sub-reports and the associated metadata. The sub-reports can be multiple report types in Data Analyzer.
- •Metadata reports. Display basic metadata about a data profile. The Metadata reports provide the source-level and column-level functions in a data profile, and historic statistics on previous runs of the same data profile.
- •Summary reports. Display data profile results for source-level and column-level functions in a data profile.
Other Reporting Sources
When you choose other warehouses as data sources, you can run other reports from Data Analyzer. Create the reports in Data Analyzer and save them in the Data Analyzer repository.
Data Analyzer Repository
When you run reports for any data source, Data Analyzer uses the metadata in the Data Analyzer repository to determine the location from which to retrieve the data for the report and how to present the report.
Use the database management system client to create the Data Analyzer repository database. When you create the Reporting Service, specify the database details and select the application service or data warehouse for which you want to run the reports. When you enable the Reporting Service, PowerCenter imports the metadata for schemas, metrics and attributes, queries, reports, user profiles, and other objects to the repository tables.
Note: If you create a Reporting Service for another reporting source, you need to create or import the metadata for the data source manually.