enterprise data integration: using informatica etl with couchbase: couchbase connect 2015

31
#INFA15 Enterprise Data Integration using Informatica ETL with Couchbase

Upload: couchbase

Post on 12-Aug-2015

256 views

Category:

Technology


5 download

TRANSCRIPT

Page 1: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Enterprise Data Integration using Informatica ETL with Couchbase

Page 2: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Move Couchbase data to the center

Page 3: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

• How important is the data ?

• Who cares about the data?

• What data is needed?

• Where is the data needed?

• When is it needed?

Page 4: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

How does it work

Page 5: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#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

Page 6: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#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

Page 7: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#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

Page 8: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#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

Page 9: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Enterprise-Wide Operational Visibility

Volume forecasts for

tasks

Page 10: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Best Practices Analysis

Targeted insights into

usage

Page 11: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Detailed Log Analysis

Error trending

Page 12: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Recommendation Engine

Product-usage based

recommendations

Page 13: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Demo

Page 14: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Why Informatica can bring Couchbase data to the center

Page 15: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Any integration

patternAny User Any App

A Platform I Can Trust

The leading integration as a service platform

Page 16: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#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

Page 17: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#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

Page 18: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#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

Page 19: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#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

Page 20: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Any User – Real-Time Process Designer

Page 21: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Any User – Batch Data Integration Designer

21

Page 22: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#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

Page 23: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Informatica Cloud Success Across verticalsHealthcare

Pharma

Banking

Insurance

Telco

Utilities & Energy

Manu-facturing

Retail

Delivery &Transport

Hi-Tech

OEM

Page 24: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Informatica Cloud Success Across EcosystemsSFDC

AWS

NetSuite

Marketo

SAP

Oracle

Microsoft

D&B

Ultimate

Workday

Page 25: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA1525

Informatica Cloud – Worldwide Success

Page 26: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

InformaticaThe #1 Independent Leader in Cloud and Hybrid Integration

IPaaS MQIntegration Platform as a Service

Hybrid Integration WaveIntegration Platform as a Service

Page 27: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Bring Couchbase data to 3 eco-systems

Page 28: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#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

Page 29: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Informatica Cloud for Amazon Ecosystem

S3RDS RedshiftEMR Kenesis

Page 30: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Informatica Cloud for Microsoft ecosystem

Blob Storage Table Storage SQL DB

Page 31: Enterprise Data Integration: Using Informatica ETL with Couchbase: Couchbase Connect 2015

#INFA15

Expanding into more ecosystems