Infa - Powercenter

  • Uploaded by: api-26304852
  • 0
  • 0
  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Infa - Powercenter as PDF for free.

More details

  • Words: 543
  • Pages: 14
[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.

Related Documents

Infa - Powercenter
November 2019 13
Infa Femeni
November 2019 14
Infa Masculi
November 2019 14
Infa Pc Partitioning Ds
October 2019 10