Scribd
Upload
108 views1 page

Informatica Data Integration Solutions

Informatica is a leader in enterprise data integration solutions that provides applications for data migration, synchronization, warehousing, hubs, marts, master data management, business intelligence reporting, and activity monitoring. Its PowerCenter components include integration and repository services that manage metadata and conduct ETL logic, as well as client applications like Designer for mapping development, Workflow Manager for workflows, and Workflow Monitor for oversight.

Uploaded by

srikanth42
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
108 views1 page

Informatica Data Integration Solutions

Informatica is a leader in enterprise data integration solutions that provides applications for data migration, synchronization, warehousing, hubs, marts, master data management, business intelligence reporting, and activity monitoring. Its PowerCenter components include integration and repository services that manage metadata and conduct ETL logic, as well as client applications like Designer for mapping development, Workflow Manager for workflows, and Workflow Monitor for oversight.

Uploaded by

srikanth42
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Informatica

Informatica, founded in 1993 is a ldeader in providing enterprise data integration solutions. It


provides applications for the following Data Integration areas:

 Data Migration - ERP and legacy systems consolidation, new application implementation
 Data Synchronization - business-to-business data transfer
 Data Warehousing
 Data Hubs, Data Marts
 Master Data Management (MDM)
 Business Intelligence Reporting
 Business Activity Monitoring (BAM)

Informatica PowerCenter components


Services

 The following services form the Informatica PowerCenter processing engine:

 Integration Service - conducts and implements the ETL logic


 Repository Service - manages connectivity to the metadata repositories, where mapping
and workflow definitions are saved
 Repository Service Process - retrieves, inserts and updates repository metadata. It is a
multi-threaded process.
 Repository - a database which contains the ETL metadata

Client Applications

Informatica client applications are desktop tools used to create transformations, manage
metadata, execute ETL processes and monitor them.

 Designer - a developer tool used for the development of ETL mappings.


 Workflow Manager - create and start workflows (sequences of mappings)
 Workflow Monitor - monitors workflows
 Repository Manager - tool used to manage source/targets connections, folders, objects,
users, etc.
 Administrator console - a web-based tool used to perform domain and repository service
tasks (configure services, nodes, perform backups, etc.)

You might also like