OData External Data Integration Strategies for SaaS

OData External Data Integration
Strategies For SaaS
Roderick Peace
Director of Product
Management
Oracle
Mike Pizzo
Principal Software
Architect
Microsoft
Sumit Sarkar
Chief Data Evangelist
Progress

© 2015 Progress Software Corporation. All rights reserved.2
Audio Bridge Options & Question Submission

OData External Data Integration
Strategies For SaaS
Roderick Peace
Director of Product
Management
Oracle
Mike Pizzo
Principal Software
Architect
Microsoft
Sumit Sarkar
Progress
@SAsInSumit

Agenda
 Overview of the OData OASIS standard (Mike)
 Why SaaS vendors are driving OData adoption (Sumit)
 Behind the Scenes: Oracle Service Cloud OData Accelerators (Roderick)

OData Overview

OData Overview
 Why OData?
 What is OData?
• Underlying Principles
• What does it support?
 Where is OData Being Used?
 OData Standardization

Observed Trends
 Data Silos -> Open Data
• Impacts government, science and enterprise
 On Premises -> Cloud
• APIs need to support both on-premises and cloud
 Web Sites -> Web APIs
• Device/Language/Runtime proliferation
 Operational APIs -> Resource-oriented APIs
• RESTful programming patterns
 Lack of interoperability…

What is OData?
…a uniform, consumer-oriented way to describe resources
Intuitive, conceptual model of entities and relationships
…uniform operations build on REST principles
Addressability, GET, POST, PUT, PATCH, DELETE, custom actions
…uniform URL conventions
Navigation, filtering, sorting, paging, custom functions, etc.
…a uniform way of representing structured data
Simple JSON format with annotation mechanism
…uniform data and metadata annotations
Define common semantics across schemas, operations
…an Open Standard
Approved as an OASIS Standard February, 2014

Defined Conventions
 Common Requests
• Metadata Description
• Resource retrieval, Query, Insert, Update, Delete, Custom Functions/Actions
• Batch Requests, Delta Requests
 URL Conventions
• Relationship Navigation
 Query Conventions
• Filter, Sort, Top/Skip, Expand, Projection, Aggregation
 JSON Format Conventions
• Payload description, count, type information, ids
• Navigation, edit, media links
• Custom payload annotations
• Deltas

OData Usage Scenarios
 OData is useful for exposing all types of data
• Enterprise, Government, Consumer, Healthcare, Custom Data
 Why do people use OData?
• Simple data consumption
– Provides access to data from any platform/device without requiring client drivers/libraries
– Consumer-oriented conceptual data model
• Interoperability
– Leverages ecosystem of existing tools, apps, libraries
• Rich, Mature Specification
– Encapsulates best practices for building robust REST services

Broad Adoption

OData Standardization
 Ratified as an OASIS standard February, 2014
• OData 4.0 Protocol, URL Conventions, Schema Definition Language
• JSON Format
 OASIS Standard Submitted to ISO
• Ballot closes end of January
 Ongoing Work
• JSON Schema metadata format
• Aggregation, Temporal Extensions
• OData 4.01
– Simplified Patterns
– Unstructured document stores

Why SaaS vendors are driving
OData adoption

Overview of SaaS adoption for OData (producers)

Overview of external data strategies (ODBC vs OData consumers)
 Text goes here

Overview of external data strategies (ODBC vs OData consumers)
 Text goes here
Standards Based Connectivity :
Elevates value of data as
producer
Elevates value of application
as consumer

Rise of citizen developers/integrators
A citizen developer is a user who creates new business
applications for consumption by others using development and
runtime environments sanctioned by corporate IT
- Gartner Glossary
To support citizen developers, integrators and line of business professionals
SaaS vendors need a standard!

Types of data sources being accessed over OData from these SaaS apps
 Marketing Applications
 Customer Engagement
 ERP / core systems
 Data Warehouses
 Big Data

Salesforce Connect Demo / Screenshots

Oracle Service Cloud OData
Accelerators

Why Service Cloud: Engage customers in their channel of choice
Email Support
Complete Email Response
Management
Live Chat
Industry Leading Chat &
Proactive Chat
Mobile Self-Service
Global Device Support
Knowledge
Single Knowledgebase Across All
Channels
Social Self-Service
Leverage the Power of
Customer Knowledge
Contact Center

Q: What are OSvC
Accelerators?
A: Open sourced “reference
integrations” to major
platforms like Siebel or
Salesforce.

Q: Why Build OSvC
Accelerators (OData)?
A: ERP systems reflect core
business differentiators and
are typically customized.

Why do SaaS products need an external data design pattern?
Select production core database metrics for Oracle Service Cloud

What are Oracle Service Cloud and Reference Integration Accelerators?
Product and Warrantee Reports

What are Oracle Service Cloud and Reference Integration Accelerators?
Report Add-in Displays Live data
for selected contact

Edit external data without leaving the unified desktop

Edit external data without leaving the unified desktop
Edit External data

Empower Agents and Admins to optimize their workspace with out calling IT
Virtual tables created by
the Report Add-in

Oracle Service Cloud : Accelerators require custom development for each platform
Cont Center 2Contact Center 1
Add-ins talk to SOA
Add-in and Agent Desktop
Communicate with the Cloud
Oracle Cloud
Siebel Workflow Updates
ConsumerConsumer
New SRs from CP
SR Details Pulled into CP Widgets
OSvC
Brand Website
Branded OSvC Web Self Service Portal (CP)
Live ChatStandard Incident / Profile Widgets
Siebel Integration Service Status BarChat and CTI media bars
OSvC Agent Desktop
Fusion HCMBack Office
Customer Site
ERP SOA
Fusion Sales

Why choose OData : Open Source tools for languages in our infrastructure
PHP Web portal
Extensible PHP / Code Igniter based
web portal for customer interactions
MySQL Database
Highly optimized MySQL database
servers on the SAAS backend
iOS / Android Mobile Apps
Multiplatform Mobile Accelerators based on
MAF for both Agents and Consumers
CentOS Backend
Multi-tenant / Multi-version datacenters
Window Client
Extensible Windows based Agent Desktop
with native workspace, workflow,
and report designers
Data
Centers
Web
Portal
Web
Client
Desktop
client
MobileDatabase
Java Based Browser Client
Extensible Java based Agent Portal

Oracle Service Cloud : OData and OData Reports Add-in Accelerator
Cont Center 2Contact Center 1
Add-ins talk to Progress via OData
Oracle Cloud
Siebel Workflow Updates
ConsumerConsumer
New SRs from CP
SR Details Pulled into CP Widgets
Progress
OSvC
Progress to Siebel
Brand Website
Branded OSvC Web Self Service Portal (CP)
Siebel SR List Widget
Live Chat
Knowledge Base
Standard Incident / Profile Widgets
OSvC + Siebel Contact SearchSiebel Contact Details
Siebel Integration Service Status Bar
Siebel SR Reports and Tools
OSvC Multichannel Contact Center WorkSpace
Siebel SR / RO Reports and Tools
Chat and CTI media bars
OSvC Agent Desktop
SFDC
OData to External Data
TripPin OData Service
Fusion SalesBack Office
Siebel Instance
Customer Site
ERP
Progress to Back Office
Sales Rep
SFDC Web UI
OSvC Incidents

Leveraging OData to extend Oracle Service Cloud

Leveraging OData to Extend Oracle Service Cloud
Editable SFDC Contact Detail

Thank You
Roderick Peace
Director of Product
Management
Oracle
Mike Pizzo
Principal Software
Architect
Microsoft
Sumit Sarkar
Progress
@SAsInSumit

OData External Data Integration Strategies for SaaS

Recommended

More Related Content

What's hot (20)

Viewers also liked (20)

Similar to OData External Data Integration Strategies for SaaS (20)

Recently uploaded (20)

OData External Data Integration Strategies for SaaS