enterprise data integration: using informatica etl with couchbase: couchbase connect 2015
TRANSCRIPT
#INFA15
Enterprise Data Integration using Informatica ETL with Couchbase
#INFA15
Move Couchbase data to the center
#INFA15
• How important is the data ?
• Who cares about the data?
• What data is needed?
• Where is the data needed?
• When is it needed?
#INFA15
How does it work
#INFA15
• Self managed, upgraded automatically
• Available in minutes
• Automatically provisioned
The solution – Informatica Self-Service IntegrationSingle agent installed locally on every provisioned environment
Firewall
Secure Agent
Secure port 443
#INFA15
Cloud integration designer and wizard based self service integration interfaces
The solution – Informatica Self-Service IntegrationAdvanced Integration, Simplified for All
Wizard-based, self-service user interface
Advanced drag and drop integration
• Developers• Architects• App strong
users
• SaaS Admins• Business Analysts
Configure/Execute
Technical Users Line of Business App Users
#INFA15
Simple wizard to build any integration workflowStart with pre-built parameterized template to configureEnter parameter values such as filters conditions, custom fields etc.
The solution – Informatica Self-Service IntegrationWizards and Pre-built Integrations
#INFA15
The solution – Informatica Self-Service IntegrationContinues improvement - Establish knowledge sharing framework
Shared via global repositoryVIPs=Pre-built parameterized integration workflows App users configure VIPs using wizards to build custom integrationsVIPs can be distributed via Informatica Marketplace and embedded into 3rd-party apps via APIs
#INFA15
Enterprise-Wide Operational Visibility
Volume forecasts for
tasks
#INFA15
Best Practices Analysis
Targeted insights into
usage
#INFA15
Detailed Log Analysis
Error trending
#INFA15
Recommendation Engine
Product-usage based
recommendations
#INFA15
Demo
#INFA15
Why Informatica can bring Couchbase data to the center
#INFA15
Any integration
patternAny User Any App
A Platform I Can Trust
The leading integration as a service platform
#INFA15
Any integration pattern
DataMigration
Data Sync& Replication
Data Quality& Validation
Test DataManagement
APIs &Interactive
Data
CloudMDM
• Application & data integration management
• Self-service tools• Bulk, real time, and interactive• Cloud to Cloud, Cloud to
ground, and ground to ground integration
DataWarehousing& Analytics
Orchestration&
Automation
Making great data ready to use
Connected
Clean
Safe
#INFA15
Couchbase as an OData Provider
• Enables OData access to internal data sources such as Couchbase
• Makes it possible for OData consumers such as Salesforce Lightning Connect to access OData streams over the Web
• v2: https://[host].rt.informaticacloud.com/active-bpel/odata/v2/Parts/sampleparts
• v4: https://[host].rt.informaticacloud.com/active-bpel/odata/v4/Parts/sampleparts
• OData v4 is an OASIS Standard; we offer v2 and v4 support
17
SFDC Lightning Connect
Informatica Cloud
OData Endpoints
OData Request
OData response
XML/Atom and JSON
JDBC_ICSAP Table ReaderOData connectorComing:
NetSuiteWorkday
OData Consumers
#INFA15
Any Data - Connectivity to every DB and every App Sales & Service Big Data
Human Resources
Web Protocols & API
ERP & Financials
B2B
Marketing
Social
IT & Admin
Analytics
#INFA15
Citizen Integrator
LOB DevelopersApplication experts
Integration experts
• No integration or development background
• New – Rev & Data Wizards
• Application team in IT or LOB IT• App Sys admin, LOB Developer• Integration wizards, VIPs
• IT integration competency center• Highly skilled team Focus on
integration• Cloud designer
Get the leverage from your developmentAny User
1X
10X
100X
#INFA15
Any User – Real-Time Process Designer
#INFA15
Any User – Batch Data Integration Designer
21
#INFA15
Couchbase data accessible for all
Data Wizard
Build re-usable integration templates
• Developers• Architects• Partners
• App users• SaaS Admins• Business Analysts
Integration Developers Application Users
Global Repository
Cloud Mapping designer
Discover, Configure and Use
#INFA15
Informatica Cloud Success Across verticalsHealthcare
Pharma
Banking
Insurance
Telco
Utilities & Energy
Manu-facturing
Retail
Delivery &Transport
Hi-Tech
OEM
#INFA15
Informatica Cloud Success Across EcosystemsSFDC
AWS
NetSuite
Marketo
SAP
Oracle
Microsoft
D&B
Ultimate
Workday
#INFA1525
Informatica Cloud – Worldwide Success
#INFA15
InformaticaThe #1 Independent Leader in Cloud and Hybrid Integration
IPaaS MQIntegration Platform as a Service
Hybrid Integration WaveIntegration Platform as a Service
#INFA15
Bring Couchbase data to 3 eco-systems
#INFA15
Informatica Cloud for Salesforce Ecosystem
DataReplication
Data Sync& Integration
Data Quality& Validation
Test DataManagement
APIs &Interactive
Data
CloudCustomer
360
DataWarehousing& Analytics
Orchestration&
Automation
Salesforce Sales Cloud
Force.com
Salesforce Marketing Cloud
Salesforce Analytics Cloud
Salesforce Service Cloud
Salesforce Lightening Connect
#INFA15
Informatica Cloud for Amazon Ecosystem
S3RDS RedshiftEMR Kenesis
#INFA15
Informatica Cloud for Microsoft ecosystem
Blob Storage Table Storage SQL DB
#INFA15
Expanding into more ecosystems