PowerCenter - Data Analyzer

Card Puncher Data Processing


PowerCenter Data Analyzer is a data access tool and provides a framework to perform business analytics on corporate data.

With Data Analyzer, you can :

  • extract,
  • filter,
  • format,
  • and analyze corporate information

from data stored in :

  • a data warehouse,
  • operational data store,
  • or other data storage models.

Data Analyzer uses a web browser interface to view and analyze business information at any level.

Data Analyzer extracts, filters, and presents information in easy-to-understand reports. You can use Data Analyzer to design, develop, and deploy reports and set up dashboards and alerts to provide the latest information to users at the time and in the manner most useful to them.

Data Analyzer has a repository that stores metadata to track information about enterprise metrics, reports, and report delivery. Once an administrator installs Data Analyzer, users can connect to it from any computer that has a web browser and access to the Data Analyzer host.

Data Analyzer can access information from databases, web services, or XML documents. You can set up reports to analyze information from multiple data sources. You can also set up reports to analyze real-time data from message streams.

If you have a PowerCenter data warehouse, Data Analyzer can read and import information regarding the PowerCenter data warehouse directly from the PowerCenter repository.

Data Analyzer provides a PowerCenter Integration utility that notifies Data Analyzer when a PowerCenter session completes.

You can set up reports in Data Analyzer to run when a PowerCenter session completes.

Data Analyzer reports display enterprise data from relational or XML sources as metrics and attributes. Dashboards provide access to enterprise data.

Data Analyzer Components

In Data Analyzer, you can read data from a data source, create reports, and view the results on a web browser. Data Analyzer contains the following components:

  • Data Analyzer repository. The Data Analyzer repository stores the 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. The Data Analyzer repository is separate from the PowerCenter repository.
  • Application server. Data Analyzer uses a third-party Java Web - Application (Server|Container) to manage processes. The Java application server provides services such as database access and server load balancing to Data Analyzer. The Java application server also provides an environment that uses Java technology to manage application, network, and system resources.
  • 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.

Powercenter Data Analyzer Architecture

Discover More
Powercenter Component
PowerCenter - Architecture/Components

Architecture for 8.x version of Informatica PowerCenter. PowerCenter provides an environment that allows you to load data into a centralized location, such as a data warehouse or operational data store...
Edlivery Oracle Bi
PowerCenter - Installation and Configuration (8.1.1 for Windows 32Bit)

This article talk the installation of the data integration tool PowerCenter from Informatica. The files for the software Informatica PowerCenter and PowerConnect Adapters 8.1.1 SP5 are available...
Edlivery Oracle Bi
PowerCenter - Installation and Configuration (8.6.1 for Windows 32Bit)

This article talk the installation of PowerCenter from Informatica on: Windows 32 bit Oracle Database Oracle Business Intelligence Application version installation The oracle database...
Powercenter 901 Installation License And Directory
PowerCenter - Installation and Configuration (9.0.1 for OEL Linux 64Bit)

Text format: ... Installation Type: Install (and not upgrade) Pre-requisites: Next License and Directory. (Transfer the license file from the client zip file) Pre-Installation Summary: Install...
Powercenter Metadata Manager Architect
PowerCenter - Metadata Manager

PowerCenter Metadata Manager is a metadata management tool that you can use to browse and analyze metadata from disparate metadata repositories. Metadata Manager helps you understand and manage how information...
Card Puncher Data Processing
PowerCenter - Repository Reports

PowerCenter Repository Reports are a set of prepackaged reports and dashboards to help you analyze and manage PowerCenter metadata. Use PowerCenter Repository Reports to browse and analyze PowerCenter...
Card Puncher Data Processing
Reporting and Data Access Tools

A data access tool query the data in the datawarehouse, of others places where are stored data (file, xml, ...) Reporting is the action of listing detail, summary data or computed information. ...

Share this page:
Follow us:
Task Runner