Table of Contents

Search

  1. Preface
  2. Analyst Service
  3. Content Management Service
  4. Data Integration Service
  5. Data Integration Service Architecture
  6. Data Integration Service Management
  7. Data Integration Service Grid
  8. Data Integration Service Applications
  9. Metadata Manager Service
  10. Model Repository Service
  11. PowerCenter Integration Service
  12. PowerCenter Integration Service Architecture
  13. High Availability for the PowerCenter Integration Service
  14. PowerCenter Repository Service
  15. PowerCenter Repository Management
  16. PowerExchange Listener Service
  17. PowerExchange Logger Service
  18. SAP BW Service
  19. Search Service
  20. System Services
  21. Test Data Manager Service
  22. Web Services Hub
  23. Application Service Upgrade
  24. Application Service Databases
  25. Connecting to Databases from Windows
  26. Connecting to Databases from UNIX
  27. Updating the DynamicSections Parameter of a DB2 Database
  28. Reporting Service (Deprecated)
  29. Reporting and Dashboards Service (Deprecated)

Reporting Service Overview

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
.