Docstoc

DB2_SQLServer-Enterprise_Data_Integration

Document Sample
DB2_SQLServer-Enterprise_Data_Integration Powered By Docstoc
					    Enterprise Data Integration



      Arjan Hijstek - presales

      Thursday, May 18, 2006




1
Agenda

• Informatica Enterprise Data Integration/Migration
• Informatica Data Integration Platform
• Informatica PowerExchange
• Data Integration with SAP R/3 – SAP BW
• Data Integration: ready to grow
• demo




                                                      2
Data Migration : A Common Requirement
     Application
   Implementation       From legacy into new application


 Application Upgrade    From previous to new version

 Application Instance
   Consolidation        From multiple instances to fewer instances


   M&A Integration      From acquired systems


  Legacy Retirement     From legacy into new systems


     Outsourcing        From company to outsourcer

                         Data Migration Required
                                                                3
       The Informatica Difference
       Our Customers Are Leaders in Every Industry
Energy and Utilities

  Financial Services
      and Insurance

  Government and
    Public Sector

     Healthcare and
      Life Sciences

     Manufacturing


 Retail and Services


Telecommunications


Transportation and
      Distribution


                                                4
5
    Informatica Data Integration Platform




6
 Data Integration Platform

Real-time Data Sources                                      GRID
 SAP/R3 WebMethods JMS
TIBCO IBM MQseries MSMQ
                                                          PowerCenter
                                     PowerCenter


                    PowerConnect /
                    PowerExchange                         PowerCenter
     Enterprise
  Software Sources                      Informatica®
    Mainframe AS/400                    PowerCenter       PowerCenter
PeopleSoft Siebel SAP/R3                 (32bit/64bit)
      SAP/BW SAS

 Open and Relational                                     other
   Data Sources                             CDC for Oracle/DB2/SQLserver
 Oracle DB2 SQLserver                         CDC for IMS/IDMS/VSAM
Sybase Informix Teradata                              Profiling
                                                    WebServices
Flat Files XML Web Logs                                 HTTP

                                                                    7
Data Quality
Customer Requirements




2006 CIO Survey, CIO Magazine, January 2006




                                              8
 Informatica Data Integration Platform

                             Develop & Manage
        Develop and collaborate with common repository and shared metadata
                Data Profiling           Data Cleanse and
PowerExchange      Option         Match Option                  PowerCenter
  Access    Discover           Cleanse                      Integrate   Deliver
    Any system        Search and       Validate,             Transform        Provide right
    in Batch or       profile any      correct and           and reconcile    data, at the
    real-time         data from        standardize           all data types   right time, in
                      any source       all data types                         the right
                                                                              format
             Data Explorer           Data Quality
                           Audit, Monitor, Report
  Ensure data consistency, perform impact analysis and continuously monitor quality




                                                                                      9
Informatica Architecture
Informatica                    Meta Data
                               Repository
Client Tools

                                 Repository Server
   Repository
    Manager

                                             TCP/IP                           RealTime
                    TCP/IP




                                                                              (MQseries/Tibco/MSMQ/
                                                                              JMS/WebMethods)
    Designer
                                                                             • MainFrame/AS400-data
                                                                              (DB2 / IDMS etc.)
                                                                             • ComplexFlatFiles
                                 Informatica Server                          • ERP-data
                                                                              (SAP/Siebel/PeopleSoft)
                                Native Database Connectivity
   Workflow
Manager & Monitor
                                                                              VSAM

                             TeraData    SQLserver                DB2
                                                                        FF      other

                                    Oracle            .........
                                                                                           10
     Data Integration with SAP R/3 and SAP BW




11
SAP – what’s where?




                  SAP R/3
      SAP                        SAP R/3
                 application
   front-end                     database
                    layer
   (SAP-gui)




                SAP BW
               application     SAP BW
                  layer        database




                                            12
   Informatica components:
   PowerConnect for SAP R/3

IN:                                              OUT:
- bulk: DMI                                      - bulk: ABAP / BAPI
- inserts/deletes/updates: BAPI                  - realtime transactions: iDocs
- realtime transactions: iDocs                   - JMS/WebServices/XML
- JMS/WebServices/XML
                                    SAP R/3
                                   application
                                      layer




                                  SAP R/3
                                  database




                                                                      13
Flexible ETL capabilities


                             SAP &
                            non SAP




                                      14
   Informatica components:
   PowerConnect for SAP BW

IN:                                          OUT:
- load into ODS/PSA-tables                   - via OHS
  (under control of SAP BW)                  - via underlying SAP-tables
- WebServices/XML/HTTP

                                SAP R/3
                               application
                                  layer




                              SAP R/3
                              database




                                                                 15
Typical SAP project types

SAP Project Type                     Informatica Component

Transactional Integration (SAP and   IDOC, BAPI, ABAP
non-SAP applications)

Legacy Data Migration                IDOC, DMI, BAPI

External DW/Application load         ABAP, PowerCenter Connect for BW, BCI

BW Integration (Source and Target)   BCI, PowerCenter Connect for BW, Open Hub Service

SAP XI                               Web Services, XML, HTTP




                                                                                16
                              Operational                        Info                SAP Business
                                 Data                           Cubes           Information Warehouse
            SAP Extractor       Store
                R/3
             Production                                                                Reporting
                                                    Data
                Data                                                                   for Excel
                                                   Manager
R/3 OLTP     Extraction
                               Staging                                  OLAP         BAPI
                       BAPI                        Metadata             Proc.
                               Engine
                                                   Manager
                                                                                       Reporting
                                                                                       & Analysis

                               Metadata            Metadata
                              Integration          Repository



                                        Data
                                        Mart
                                     Procurement                                 Multiple
                                                       MDB
                                                                                Customized
 Non-R/3                                                                        Data Marts
  OLTP                                      Data
 Source      Production                     Mart
Databases   Data Extractor           Supply-Chain      MDB

                                                                                              17
   SAP Alliance Overview
Strategic Relationship   • Informatica has been a SAP partner since 1998 with certified connectors
                           for SAP R/3 and BW
                         • Master Relationship Agreement (MRA) with SAP AG signed in 2005 for
                           global cooperation for services projects related to data migration
                         • Migration efforts focused on accelerating the time-to-value of data
                           migration initiatives for SAP customers


SAP Certifications       •     BAPI          SAP Certified
                         •     ALE/IDOC      SAP Certified
                         •     DMI           SAP Certified
                         •     BW            SAP Certified
                         •     ESA           Powered By NetWeaver


Joint Customers          •   BMW                    •   Eli Lilly
                         •   DaimlerChrysler        •   Roche
                         •   Hewlett-Packard        •   World Bank
                         •   Motorola               •   U.S. Navy
                         •   Sony                   •   Burger King
                         •   Abbott Laboratories    •   CreditSuisse
                         •   Bayer                  •   Putnam Investments


                                                                                                 18

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:13
posted:6/25/2012
language:English
pages:18