Informatica Data Analyzer

Data Analyzer is a PowerCenter web application that provides a framework to extract, filter, format, and analyze data stored in a data warehouse, operational data store, or other data storage models. The Reporting Service in the Informatica domain runs the Data Analyzer application. You can create a Reporting Service in the Administrator tool.

Design, develop, and deploy reports with Data Analyzer. Set up dashboards and alerts. Data Analyzer can access information from databases, web services, or XML documents. You can also set up reports to analyze real-time data from message streams.

Data Analyzer maintains a repository to store metadata to track information about data source schemas, reports, and report delivery.

Data Analyzer includes the following components:

•   Data Analyzer repository. The Data Analyzer repository stores metadata about objects and processes that it requires to handle user requests. The metadata includes information about schemas, user profiles, personalization, reports and report delivery, and other objects and processes. You can use the metadata in the repository to create reports based on schemas without accessing the data warehouse directly. Data Analyzer connects to the repository through Java Database Connectivity (JDBC) drivers.

•   Application server. Data Analyzer uses a third-party application server to manage processes. The application server provides services such as database access, server load balancing, and resource management.

•   Web server. Data Analyzer uses an HTTP server to fetch and transmit Data Analyzer pages to web browsers.

•   Data source. For analytic and operational schemas, Data Analyzer reads data from a relational database.

It connects to the database through JDBC drivers. For hierarchical schemas, Data Analyzer reads data from an XML document. The XML document may reside on a web server or be generated by a web service operation. Data Analyzer connects to the XML document or web service through an HTTP connection.