Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(4 Ratings)
facebook Twitter
Print Bookmark Alert me when this article is updated


HOW TO: Generate the Reporting and Dashboards Service or Data Analyzer reports shipped with earlier versions of Informatica with a reporting tool

​​​​​​Effective in version 10.1.1, Informatica no longer supports the Reporting and Dashboards Service, the Reporting Service, or Data Analyzer.


The attached sheet has details on the queries needed to create the required reports for PowerCenter (PC) and Metadata Manager (MM). 

Note: Metadata Manager SQL queries are not available on Sybase because it is not a supported database.


The attached zip file has four sheets:


  • KB496097_Report_SQL_PC_DA_MM_OracleDB - For Oracle Database
  • KB496097_Report_SQL_PC_DA_MM_SQLServerDB - For SQL Server Database
  • KB496097_Report_SQL_PC_DA_MM_SybaseDB - For Sybase Database
  • KB496097_Report_SQL_PC_DA_MM_DB2DB - For IBM DB2 Database 

You can extract the appropriate sheet based on the database type of the reporting database in your environment.


You could use a third-party reporting tool along with these recommended SQL queries to create equivalent reports.

For instance, for PowerCenter, to create the Deployment Details reports in the Configuration Management folder, enter the query listed in the SQL Query string Column as listed in the first row on the PC_DA_Queries sheet of the attached file.

For instance, for MM, to create an Attributes and Metrics reports in the Business Intelligence folder, enter the query listed in the SQL Query string Column as listed in the first row on the MM_Queries sheet of the attached file.

More Information
Applies To
Product: PowerCenter; Metadata Manager
Problem Type:
User Type: Administrator
Project Phase:
Product Version: Informatica 9.6.1; Informatica 10.0; Informatica 10.1.1
Operating System:
Other Software:
Last Modified Date:3/3/2017 12:26 AMID:496097
People who viewed this also viewed


Did this KB document help you?

What can we do to improve this information (2000 or fewer characters)