Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

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

Feedback

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

​​​​​​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 KB496097_Report_SQL_PC_DA_MM_4_queries.zipKB496097_Report_SQL_PC_DA_MM_4_queries.zip 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
Reference
​E-10705
Applies To
Product: PowerCenter; Metadata Manager
Problem Type:
User Type:
Project Phase:
Product Version: Informatica 9.6.1; Informatica 10.0; Informatica 10.1.1
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:3/3/2017 12:26 AMID:496097
People who viewed this also viewed

Feedback

Did this KB document help you?



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