partena 2010.02.10
Post on 19-Oct-2014
461 views
DESCRIPTION
Informatica slidesTRANSCRIPT
22
© 2009 Informatica. Company Confidential. Forward-looking information is based upon multiple assumptions and uncertainties and does not necessarily represent the company’s outlook.
Presentation PartenaETL – Migration Project
10/2/2010
Luc Delanglez, RealDolmenDimitri Maesfranckx, Informatica
3
The Informatica Opportunity Key Customer Business Imperatives
Business Imperatives
Improve Decisions
ModernizeBusiness
Improve Efficiency & Reduce
Costs
Acquire & Retain
Customers
OutsourceNon-coreFunctions
GovernanceRisk
Compliance
MergersAcquisitions
& Divestitures
IncreasePartnerNetwork
Efficiency
Business Intelligence &
Regulatory Reporting
Legacy Retirement
Application ILM
Customer,Supplier,
Product Hubs
BPOSaas
B2B Integration
Application Consolidation
IT InitiativesRisk
Mitigation & Regulatory Reporting
Data Warehouse
DataMigration
Test DataManagement& Archiving
Master DataManagement
Data Synchronization
B2B DataExchange
DataConsolidation
IT Projects
ComplexEvent
Processing
4
The Informatica Opportunity Key Customer Business Imperatives
Business Imperatives
Improve Decisions
ModernizeBusiness
Improve Efficiency & Reduce
Costs
Acquire & Retain
Customers
OutsourceNon-coreFunctions
GovernanceRisk
Compliance
MergersAcquisitions
& Divestitures
IncreasePartnerNetwork
Efficiency
Business Intelligence &
Regulatory Reporting
Legacy Retirement
Application ILM
Customer,Supplier,
Product Hubs
BPOSaas
B2B Integration
Application Consolidation
IT InitiativesRisk
Mitigation & Regulatory Reporting
Data Warehouse
DataMigration
Test DataManagement& Archiving
Master DataManagement
Data Synchronization
B2B DataExchange
DataConsolidation
IT Projects
ComplexEvent
Processing
Reusable Development
Assets
ProcessTechnology
People
5
Application Partner Data
SWIFT NACHA HIPAA …
Cloud Computing Unstructured
The Informatica ApproachComprehensive, Unified, Open and Economical platform
Database
Data Warehouse
DataMigration
Test DataManagement& Archiving
Master DataManagement
Data Synchronization
B2B DataExchange
DataConsolidation
ComplexEvent
Processing
6
Application Database Partner Data
SWIFT NACHA HIPAA …
Cloud Computing Unstructured
The Informatica Platform
Improve Decisions
ModernizeBusiness
Improve Efficiency & Reduce
Costs
Acquire & Retain
Customers
OutsourceNon-coreFunctions
GovernanceRisk
Compliance
MergersAcquisitions
& Divestitures
IncreasePartnerNetwork
Efficiency
7
The Informatica PlatformComprehensive, Unified, Open, Economical
Comprehensive Any dataAnywhereAny timeAny roleAny use
UnifiedAll in one platform
OpenWorks with what you have, now and future
Economical Lower TCO + fast ROI
8
Why Informatica?
• Proven technology leadership
• A track record of Continuous Innovation
• The most neutral trusted partner
• Track record of customer success
“To date, we’ve seen a return on our investment from this program over 2,000 percent”.
“… complete, accurate and timely data is a fundamental requirement for optimal performance”
A singular focus on Data Integration
9
Why Informatica?Proven Technology Leadership
B2B Data Exchange
“Informatica supports the requirements of cross-organizational data exchange, so
users can apply familiar and trusted data integration tools and techniques to the relatively new and growing practice of
B2B data integration.”
Cloud Data Integration
“Informatica’s mission to integrate data from business to business… meets a
need of many companies…Others in this market (including IBM, Microsoft and
Oracle) have not yet pursued this progressive use of data integration”
Application ILM
Informatica was assessed as having the largest share, more than 33 percent, in
packaged applications for database archiving based on number of customers
for 2007 by Gartner, Inc. in a research report released October 13, 2008
Complex Events Processing
Major differentiator compared to other vendors is that it does not just wait for
events to come to it but it can go out and get them for itself. Thus it provides agents
that can gather events from front-office databases and applications as well as
receiving them directly from relevant feeds
Enterprise Data Integration Data Quality
10
11
The Informatica PlatformData Integration for Applications Core Services
Core
Data
In
teg
rati
on
Serv
ices
Reliability, Scalability, and Security Services
End to End Metadata and Data Traceability
Tools• Administration• Scheduler• Monitoring• Designer• Orchestration• Open API
Data Adapter• File• XML• RDBMS• JMS• Web Services
Real-time, Near Real-time, and Batch Data Processing Engine
Manipulation Services• Data Routing• Data Conversion• Data Transformation• Data Encryption• Data Masking
Transaction Services• DB transaction capture• Guaranteed Message Delivery• Transaction Control• Exactly Once Semantics
12
The Informatica PlatformData Quality Firewall
Core
Data
In
teg
rati
on
Serv
ices
Reliability, Scalability, and Security Services
End to End Metadata and Data Traceability
Tools• Administration• Scheduler• Monitoring• Designer• Orchestration• Open API
Data Adapter• File• XML• RDBMS• JMS• Web Services
Real-time, Near Real-time, and Batch Data Processing Engine
Manipulation Services• Data Routing• Data Conversion• Data Transformation• Data Encryption• Data Masking
Transaction Services• DB transaction capture• Guaranteed Message Delivery• Transaction Control• Exactly Once Semantics
Data Processing Services
Data
Qu
ality
Fir
ew
all
Passive Control• Data Profiling• Data Certification• Data Matching• Identity Resolution
Active Control• Data Standardization• Data Validation• Data De-duplication
• Data Enrichment• Data Matching• Identity Resolution
Tools• Matching Assistant• Bad Data Management• Quality Dashboard
13
The Informatica PlatformOffice Document Inclusion & Governance
Core
Data
In
teg
rati
on
Serv
ices
Reliability, Scalability, and Security Services
End to End Metadata and Data Traceability
Tools• Administration• Scheduler• Monitoring• Designer• Orchestration• Open API
Data Adapter• File• XML• RDBMS• JMS• Web Services
Real-time, Near Real-time, and Batch Data Processing Engine
Manipulation Services• Data Routing• Data Conversion• Data Transformation• Data Encryption• Data Masking
Transaction Services• DB transaction capture• Guaranteed Message Delivery• Transaction Control• Exactly Once Semantics
Data Processing Services
Data
Qu
ality
Fir
ew
all
Passive Control• Data Profiling• Data Certification• Data Matching• Identity Resolution
Active Control• Data Standardization• Data Validation• Data De-duplication
• Data Enrichment• Data Matching• Identity Resolution
Tools• Matching Assistant• Bad Data Management• Quality Dashboard
Bu
sin
ess
Ad
ap
ter
Office Inclusion• Word, Excel, PDF, etc.• eMail Processing
14
The Informatica PlatformOn-Premise and In-Cloud Data Integration
Core
Data
In
teg
rati
on
Serv
ices
Reliability, Scalability, and Security Services
End to End Metadata and Data Traceability
Tools• Administration• Scheduler• Monitoring• Designer• Orchestration• Open API
Data Adapter• File• XML• RDBMS• JMS• Web Services
Real-time, Near Real-time, and Batch Data Processing Engine
Manipulation Services• Data Routing• Data Conversion• Data Transformation• Data Encryption• Data Masking
Transaction Services• DB transaction capture• Guaranteed Message Delivery• Transaction Control• Exactly Once Semantics
Data Processing Services
Data
Qu
ality
Fir
ew
all
Passive Control• Data Profiling• Data Certification• Data Matching• Identity Resolution
Active Control• Data Standardization• Data Validation• Data De-duplication
• Data Enrichment• Data Matching• Identity Resolution
Tools• Matching Assistant• Bad Data Management• Quality Dashboard
Bu
sin
ess
Ad
ap
ter
Office Inclusion• Word, Excel, PDF, etc.• eMail Processing
Enterprise Applications• Saas• Applications• Mainframe• Other
15
The Informatica PlatformCross Enterprise Data Integration
Core
Data
In
teg
rati
on
Serv
ices
Reliability, Scalability, and Security Services
End to End Metadata and Data Traceability
Tools• Administration• Scheduler• Monitoring• Designer• Orchestration• Open API
Data Adapter• File• XML• RDBMS• JMS• Web Services
Real-time, Near Real-time, and Batch Data Processing Engine
Manipulation Services• Data Routing• Data Conversion• Data Transformation• Data Encryption• Data Masking
Transaction Services• DB transaction capture• Guaranteed Message Delivery• Transaction Control• Exactly Once Semantics
Data Processing Services
Data
Qu
ality
Fir
ew
all
Passive Control• Data Profiling• Data Certification• Data Matching• Identity Resolution
Active Control• Data Standardization• Data Validation• Data De-duplication
• Data Enrichment• Data Matching• Identity Resolution
Tools• Matching Assistant• Bad Data Management• Quality Dashboard
Bu
sin
ess
Ad
ap
ter
Office Inclusion• Word, Excel, PDF, etc.• eMail Processing
Extended Enterprise• Industry Format Support • Partner Management• Secured Connectivity
Enterprise Applications• Saas• Applications• Mainframe• Other
16
Comprehensive, Unified, Open, and Economical Platform for Operational Data Integration
Core
Data
In
teg
rati
on
Serv
ices
Reliability, Scalability, and Security Services
End to End Metadata and Data Traceability
Tools• Administration• Scheduler• Monitoring• Designer• Orchestration• Open API
Data Adapter• File• XML• RDBMS• JMS• Web Services
Real-time, Near Real-time, and Batch Data Processing Engine
Manipulation Services• Data Routing• Data Conversion• Data Transformation• Data Encryption• Data Masking
Transaction Services• DB transaction capture• Guaranteed Message Delivery• Transaction Control• Exactly Once Semantics
Data Processing Services
Data
Qu
ality
Fir
ew
all
Passive Control• Data Profiling• Data Certification• Data Matching• Identity Resolution
Active Control• Data Standardization• Data Validation• Data De-duplication
• Data Enrichment• Data Matching• Identity Resolution
Tools• Matching Assistant• Bad Data Management• Quality Dashboard
Bu
sin
ess
Ad
ap
ter
Office Inclusion• Word, Excel, PDF, etc.• eMail Processing
Extended Enterprise• Industry Format Support • Partner Management• Secured Connectivity
Enterprise Applications• Saas• Applications• Mainframe• Other
Op
en
AP
I
17
Data Quality Dimensions Framework
Completeness What data is missing or unusable?
Conformity What data is stored in a non-standard format?
Consistency What data values give conflicting information?
Accuracy What data is incorrect or out of date?
Duplicates What data records or attributes are repeated?
Integrity What data is missing or not referenced?
18
Integrated User ExperienceFaster rampup for increased productivity
19
Unified Shared Metadata Improve collaboration
Unified metadata user experience: Making the right metadata available to the right people at the right time in the right way
20
Single Runtime EngineProven reliability, scalability & lower administration cost
Unified Runtime Engine• Grid Scalability, Parallelism• High Availability• Security• Logging
Informatica Data Quality
Informatica PowerCenter
Informatica OnDemand
Informatica B2B Data Exchange
21
Open With AnythingInteroperate with existing and future systems
Cloud Computing (Saas)
B2B PartnersEnterprise
22
Informatica Platform
Any Latency
23
Any Latency
Benefits:
• Support for any latency
• Right-time information availability• Batch• Near real-time (CDC)• Real-time• Federation
• High-performance optimized environment to support real-time risk management
24
25
The Elements
Proven Methodology
ProvenTechnology
End-to-EndIntegration Services
VelocityMethodology
Informatica’sMarket LeadingIntegration & Data Quality
Tools
RealDolmen Professional Services acting as a true
Single-Source supplier
1
32
Reusable Development
Assets
ProcessTechnology
People
26
Methodology – Informatica Velocity
• Proven Methodology based on 100’s of engagements
• Best Practices for successful Migrations
• Purpose-built tools and assets for Data Migration
• Convert early, often and with real production data to• Uncover scope and magnitude of data quality issues• Establish benchmarks to estimate length & scope of project• Provide value to business users from onset
Manage
ArchitectAnalyze Operate
27
Process
Integration Competency
Center
According to Gartner*, ICCs:• Achieve 25% reuse of
integration components • Save 30% in integration
development time and costs• Save 20% in maintenance costs
*Source: Gartner, Cost Cutting Through the Use of an Integration Competency Center or SOA Center of Excellence
Data Warehouse
DataConsolidation
DataSynchronization
Data Migration
Composite Apps
ICC = Economical Lower TCO
Methodology – Informatica Velocity