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.zip has four sheets:
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.
What can we do to improve this information (2000 or fewer characters)