Infa - Powercenter

[Meeting] Informatica PowerCenter [Date]

Agenda • Enterprise Data Integration • Informatica PowerCenter • Real world examples

http://www.interface-development.com

Page 2

Enterprise Data Integration

Enterprise Data Integration is not just the definition of a system landscape… … it‘s about capture data from any system and move it to any system … it’s about applying data and business rules … it’s about cleanse, transform, aggregate and segregate data as needed … it’s about providing data on demand with batch, real-time, bulk or incremental data loading … it’s where ETL (extract, transform and load) tools are mainly used … it’s where companies are looking for a single data integration platform … it’s about dealing with different kinds of data integration projects … http://www.interface-development.com

Page 3

Enterprise Data Integration

Data Integration Projects 1

2

3

4

5

Data Migration

Data Synchronization

Data Warehousing

Data Hubs

Business Activity Monitoring

Data Hubs Business Activity Data Migration Data Synchronization Data Warehousing Monitoring

http://www.interface-development.com

• • • • • • •

ERP Consolidation Business Intelligence Master Data Management Legacy Conversion Business Process Improvement Application Integration Data Marts Reference Data Hubs New Application Implementation Real-time Reporting Business to Business Data Transfer Data Marts Consolidation Single View of Customer, Employee, etc. System Consolidation Operational Data Stores

Page 4

Agenda • Enterprise Data Integration • Informatica PowerCenter • Real world examples

http://www.interface-development.com

Page 5

Informatica PowerCenter

Informatica Company • • • • • •

Founded: 1993 Headquarters: Redwood City, California Employees: 800+ Customers: 2100+ Revenue: $219.7 million in 2004 Products: – PowerCenter (Enterprise Data Integration) – PowerExchange (Enterprise Data Integration) – SuperGlue (Metadata Management) – PowerAnalyzer (Business Intelligence)

http://www.interface-development.com

Page 6

Informatica PowerCenter

Architecture Informatica Client

Sources and Targets

Informatica Server TCP/IP

Native/ODBC

TCP/IP

Repository Server / Agent

Native/ODL

Informatica Repository

http://www.interface-development.com

Page 7

Informatica PowerCenter

Key Features/Benefits • Industry # 1 Enterprise Data Integration Solution • Data Integration Service Architecture

– Data movement (batch, real-time) – Build-in data profiling and quality

• Accelerate Deployment with End-to-End Productivity Tools

– Robust, rich transformation objects – Visual debugger and error handling – Automated configuration management (check-in/check-out)

• High-performance Engine

– Always on, real-time engine – Multi-target processing – Optimized partitioning = performance tuning

• Extensible Platform

– SDK for client, server and repository API’s

• Connectivity… http://www.interface-development.com

Page 8

Informatica PowerCenter

Connectivity Packaged Applications

Relation and Flat Files

Standards and Messaging

Hierarchical and Multi-dimensional

• SAP

• Oracle

• IBM MQSeries

• VSAM Mainframe

• PeopleSoft

• DB2

• TIBCO Rendezvous

• IMS Mainframe

• Oracle

• SQL Server

• webMethods

• IDMS Mainframe

• Teradata

• Web Services (WDSL, SOAP, UDDI)

• Hyperion Essbase

Applications • Siebel • SAS

• Sybase • Informix • Flat Files • Web Logs

• ODBC • JMS • XML

• Complex Flat Files • DataCom • C-ISAM • TurboImage • ADABAS

http://www.interface-development.com

Page 9

Informatica PowerCenter

Tools: step-by-step introduction Repository Manager Designer Workflow Manager

Workflow Monitor

http://www.interface-development.com

Page 10

Agenda • Enterprise Data Integration • Informatica PowerCenter • Real world examples

http://www.interface-development.com

Page 11

Real world examples

Example : [interface name] Systems

System 1

System 1

Informatica

Informatica Designer

Informatica Workflow Manager

System 2

System 2

Applications

Extraction and Validation

Mapping and Consolidation

Transformation

Load

Actions

http://www.interface-development.com

Page 12

Real world examples

Any Questions?

http://www.interface-development.com

Page 13

Thank you.