際際滷

際際滷Share a Scribd company logo
Access your data out of Salesforce
as if it was in using oData
Esteve Graells
Software Architect
esteve.graells@gmail.com
(forcegraells.com) @forcegraells
Who is who is this story?
Business You Guidance Salesforce
Challenge
Its vital to our business to
access a set of data ,in
another system.
You need to do it this week,
and with no code, and you
cant copy the data.
I know you cant do it.
Hope
Harry, do not panic.
I remember a group of
outlaws did something
amazing, some years ago,
in a weird place.
back in 2007
2007
Jordi Graells was Born
Microsoft SQL Server Team
initiates Project Astoria
Harry Potter and the Order of the
Phoenix was the years top movie
Microsoft Astoria Project
Translation for humans:
SQL for the
Web
https://blogs.msdn.microsoft.com/odatateam/2007/07/18/welcome/
The goal of the Astoria
project is to enable
applications to expose
data as a data service
that can be consumed by
web clients.
Demo
Venerable Microsoft
Northwind Database
DIY : my Postman Collection is shared here - https://www.getpostman.com/collections/993c37d4aa583270bbf8
Interested on learning oData: http://docs.oasis-open.org/odata/odata/v4.0/odata-v4.0-part2-url-conventions.html
Demo (connectors)
My Contacts and
Tasks on gMail
Database on
Amazon WS
What if my source cant be offered natively as an oData service?
Salesforce Lightning Connect
2014
oData 4.0 standardized by OASIS.
SAP, Microsoft, Salesforce and other Big Players
are using it extensively
Salesforce introduces Lightning Connect
Interstellar was the years top movie,
space travelling at light speed
What is Salesforce Connect? (formerly Lightning Connect)
 External Data Sources
 External Objects
 Link External objects with
Standard/Custom objects
 Reporting, List Views, Tabs, etc.
Youre done :no code, and pretty
fast to set up
Demo Real Scenario
oData via
Salesforce Connect
Whatever
dont care & dont mind
HR Database
in AWS
Training
App
oData
Connector
Demo Real Scenario
Internal Lookup
External object to Custom/Standard
External Lookup
Custom/Standard object to an External
Teachers
Custom Object
Attendees
Custom Object
employees
External Object
courses
External Object
Attendees links to 2 external
objects employee and course
Courses links to Teachers
 Needs an oData Source (abstraction)
 Point & Click
 Features depends on oData connectors
capabilities (some limitations apply)
 Data Access oriented, no business
process oriented
 Opex
 Reusable (somehow)
 Limits (100 external objects/org, 10,000
OData queries/hour  High Volume option
- higher on request, 8MB response size)
 API Services developing + infrastructure
 Development (devops, managers, meetings, arghh!!!)
 Develop crazy, out of this world biz
requirements possible
 Business Data Services oriented,
completely versatile
 Opex and Capex
 Reusable (somehow)
 Software Project Limits (the ones you
already know and easy to increment)
oData versus API Services
Different approaches with distinct results
 Source data cant be copied (regulations) or is not convenient (Huge
volumes)
 A platform object is required (Reporting, Listing, relationships, etc.)
 Need fast implementation (no time for API Development), No code and
minimize software maintenance
 Access Heterogeneous source data (remember my google contacts  needs
capable connector )
 Accessing to systems already offering oData Endpoints (i.e. SAP)
 New approaches like using External Objects for Big Data accessing an
OnPremise Hadoop from Salesforce (/SumitSarkar10/salesforce-external-objects-for-big-data)
Common Use Cases for Salesforce Connect
From Wizard to Jedi Master
Forget about Connectors and create your Own
Integrate with anything - well, anything that we can get to
from Salesforce by using HTTP callouts
(good coding required)
Apex
Connector
Framework
Q & A
Esteve Graells
Software Architect
esteve.graells@gmail.com
(forcegraells.com) @forcegraells
Thank You
Remember to tell us what you think in the event survey
www.LondonsCalling.net/survey/
Esteve Graells
Software Architect
esteve.graells@gmail.com
@forcegraells - (forcegraells.com)
DATA
Ad

Recommended

Data base assignment help
Data base assignment help
Nome Sobrenome
ML Meetup #27 - Data Infrasctructure and Data Access in Nubank
ML Meetup #27 - Data Infrasctructure and Data Access in Nubank
Luis Moneda
Data mining tools for excel and sql server
Data mining tools for excel and sql server
Sayed Ahmed
Textkernel Talks - Neo4j usage in Textkernel
Textkernel Talks - Neo4j usage in Textkernel
Textkernel
Data analytics at a petabyte scale final
Data analytics at a petabyte scale final
Ori Reshef
Graph Databases for SQL Server Professionals
Graph Databases for SQL Server Professionals
St辿phane Fr辿chette
DEV-1129 How Watson, Bluemix, Cloudant, and XPages Can Work Together In A Rea...
DEV-1129 How Watson, Bluemix, Cloudant, and XPages Can Work Together In A Rea...
Frank van der Linden
Data Lineage with Apache Airflow using Marquez
Data Lineage with Apache Airflow using Marquez
Willy Lulciuc
DeepeshRehi
DeepeshRehi
deepesh rehi
Feature Store as a Data Foundation for Machine Learning
Feature Store as a Data Foundation for Machine Learning
Provectus
State of Play. Data Science on Hadoop in 2015 by SEAN OWEN at Big Data Spain ...
State of Play. Data Science on Hadoop in 2015 by SEAN OWEN at Big Data Spain ...
Big Data Spain
Ashish_Maheshwari_Data_Analyst
Ashish_Maheshwari_Data_Analyst
Ashish Maheshwari
Microsoft Flow advanced: tips, pitfalls, problems and warnings to be known be...
Microsoft Flow advanced: tips, pitfalls, problems and warnings to be known be...
BIWUG
Data virtualization
Data virtualization
Hamed Hatami
Running Data Platforms Like Products
Running Data Platforms Like Products
VMware Tanzu
Key Skills Required for Data Engineering
Key Skills Required for Data Engineering
Fibonalabs
Big Data, Hadoop, NoSQL and more ...
Big Data, Hadoop, NoSQL and more ...
Varad Meru
SphereEx pitch deck
SphereEx pitch deck
Tech in Asia
QuerySurge 際際滷 Deck for Big Data Testing Webinar
QuerySurge 際際滷 Deck for Big Data Testing Webinar
RTTS
Sudhir hadoop and Data warehousing resume
Sudhir hadoop and Data warehousing resume
Sudhir Saxena
Ncku csie talk about Spark
Ncku csie talk about Spark
Giivee The
Data lake On Premise VS Cloud
Data lake On Premise VS Cloud
Idan Tohami
The New Frontier: Optimizing Big Data Exploration
The New Frontier: Optimizing Big Data Exploration
Inside Analysis
Normalizing x pages web development
Normalizing x pages web development
Shean McManus
Innovation in the Enterprise Rent-A-Car Data Warehouse
Innovation in the Enterprise Rent-A-Car Data Warehouse
DataWorks Summit
Yeswanth-Resume
Yeswanth-Resume
Yeswanth Kumar
Big Data Meetup #7
Big Data Meetup #7
Paul Lo
Modern Data Management for Federal Modernization
Modern Data Management for Federal Modernization
Denodo
FL Studio Crack Full Version [Latest 2025]
FL Studio Crack Full Version [Latest 2025]
Jackson lithms
The Love of a Father 06 15 2025.pptx
The Love of a Father 06 15 2025.pptx
FamilyWorshipCenterD

More Related Content

Similar to What is Salesforce Connect by Harry Potter (20)

DeepeshRehi
DeepeshRehi
deepesh rehi
Feature Store as a Data Foundation for Machine Learning
Feature Store as a Data Foundation for Machine Learning
Provectus
State of Play. Data Science on Hadoop in 2015 by SEAN OWEN at Big Data Spain ...
State of Play. Data Science on Hadoop in 2015 by SEAN OWEN at Big Data Spain ...
Big Data Spain
Ashish_Maheshwari_Data_Analyst
Ashish_Maheshwari_Data_Analyst
Ashish Maheshwari
Microsoft Flow advanced: tips, pitfalls, problems and warnings to be known be...
Microsoft Flow advanced: tips, pitfalls, problems and warnings to be known be...
BIWUG
Data virtualization
Data virtualization
Hamed Hatami
Running Data Platforms Like Products
Running Data Platforms Like Products
VMware Tanzu
Key Skills Required for Data Engineering
Key Skills Required for Data Engineering
Fibonalabs
Big Data, Hadoop, NoSQL and more ...
Big Data, Hadoop, NoSQL and more ...
Varad Meru
SphereEx pitch deck
SphereEx pitch deck
Tech in Asia
QuerySurge 際際滷 Deck for Big Data Testing Webinar
QuerySurge 際際滷 Deck for Big Data Testing Webinar
RTTS
Sudhir hadoop and Data warehousing resume
Sudhir hadoop and Data warehousing resume
Sudhir Saxena
Ncku csie talk about Spark
Ncku csie talk about Spark
Giivee The
Data lake On Premise VS Cloud
Data lake On Premise VS Cloud
Idan Tohami
The New Frontier: Optimizing Big Data Exploration
The New Frontier: Optimizing Big Data Exploration
Inside Analysis
Normalizing x pages web development
Normalizing x pages web development
Shean McManus
Innovation in the Enterprise Rent-A-Car Data Warehouse
Innovation in the Enterprise Rent-A-Car Data Warehouse
DataWorks Summit
Yeswanth-Resume
Yeswanth-Resume
Yeswanth Kumar
Big Data Meetup #7
Big Data Meetup #7
Paul Lo
Modern Data Management for Federal Modernization
Modern Data Management for Federal Modernization
Denodo
Feature Store as a Data Foundation for Machine Learning
Feature Store as a Data Foundation for Machine Learning
Provectus
State of Play. Data Science on Hadoop in 2015 by SEAN OWEN at Big Data Spain ...
State of Play. Data Science on Hadoop in 2015 by SEAN OWEN at Big Data Spain ...
Big Data Spain
Ashish_Maheshwari_Data_Analyst
Ashish_Maheshwari_Data_Analyst
Ashish Maheshwari
Microsoft Flow advanced: tips, pitfalls, problems and warnings to be known be...
Microsoft Flow advanced: tips, pitfalls, problems and warnings to be known be...
BIWUG
Data virtualization
Data virtualization
Hamed Hatami
Running Data Platforms Like Products
Running Data Platforms Like Products
VMware Tanzu
Key Skills Required for Data Engineering
Key Skills Required for Data Engineering
Fibonalabs
Big Data, Hadoop, NoSQL and more ...
Big Data, Hadoop, NoSQL and more ...
Varad Meru
SphereEx pitch deck
SphereEx pitch deck
Tech in Asia
QuerySurge 際際滷 Deck for Big Data Testing Webinar
QuerySurge 際際滷 Deck for Big Data Testing Webinar
RTTS
Sudhir hadoop and Data warehousing resume
Sudhir hadoop and Data warehousing resume
Sudhir Saxena
Ncku csie talk about Spark
Ncku csie talk about Spark
Giivee The
Data lake On Premise VS Cloud
Data lake On Premise VS Cloud
Idan Tohami
The New Frontier: Optimizing Big Data Exploration
The New Frontier: Optimizing Big Data Exploration
Inside Analysis
Normalizing x pages web development
Normalizing x pages web development
Shean McManus
Innovation in the Enterprise Rent-A-Car Data Warehouse
Innovation in the Enterprise Rent-A-Car Data Warehouse
DataWorks Summit
Big Data Meetup #7
Big Data Meetup #7
Paul Lo
Modern Data Management for Federal Modernization
Modern Data Management for Federal Modernization
Denodo

Recently uploaded (19)

FL Studio Crack Full Version [Latest 2025]
FL Studio Crack Full Version [Latest 2025]
Jackson lithms
The Love of a Father 06 15 2025.pptx
The Love of a Father 06 15 2025.pptx
FamilyWorshipCenterD
Analysis of Tausog Language English.pptx
Analysis of Tausog Language English.pptx
MervieJadeBabao
Japan's Media and Telecom Markets: Evolution, Global Competition, and NTT Law...
Japan's Media and Telecom Markets: Evolution, Global Competition, and NTT Law...
Toshiya Jitsuzumi
Google Algorithm Updates A Complete Guide for Digital Marketing Students.pdf
Google Algorithm Updates A Complete Guide for Digital Marketing Students.pdf
Nithinks37
AC_Manufacturer_Strategy_Commercial_Government.pptx
AC_Manufacturer_Strategy_Commercial_Government.pptx
ajajsain
Briefing on the upcoming UNFSS +4 Stocktake
Briefing on the upcoming UNFSS +4 Stocktake
Francois Stepman
Joint Family And Nuclear Family to .. pdf.
Joint Family And Nuclear Family to .. pdf.
shrujapanchal813
ENGLISh.pptxtausug.pptxtausug.pptxtausug.pptx
ENGLISh.pptxtausug.pptxtausug.pptxtausug.pptx
MervieJadeBabao
ENGLISh.pptxENGLISh.pptxENGLISh.pptxENGLISh.pptx
ENGLISh.pptxENGLISh.pptxENGLISh.pptxENGLISh.pptx
MervieJadeBabao
2025-06-22 Abraham 04 (shared slides).pptx
2025-06-22 Abraham 04 (shared slides).pptx
Dale Wells
What say you - ethical issues in research
What say you - ethical issues in research
ssuser8aff01
PEN TO PODIUM powerpoint presentation.pptx
PEN TO PODIUM powerpoint presentation.pptx
Vanessa accad
Josaya - Abstract for the research of the youth development.pdf
Josaya - Abstract for the research of the youth development.pdf
Josaya Injesi
Bob Stewart Acts 18 06 18 2025.pptx
Bob Stewart Acts 18 06 18 2025.pptx
FamilyWorshipCenterD
Heating_Effect_of_Solar_Corona_Presentation.pptx
Heating_Effect_of_Solar_Corona_Presentation.pptx
Hanumamshukla
Bob Stewart Acts 17 Study 06 11 2025.pptx
Bob Stewart Acts 17 Study 06 11 2025.pptx
FamilyWorshipCenterD
Types of Information Sources (Primary, Secondary, and Tertiary Sources)
Types of Information Sources (Primary, Secondary, and Tertiary Sources)
jenicahmendoza1
Personal letter personal letter personal letter.pptx
Personal letter personal letter personal letter.pptx
GedeJuliana2
FL Studio Crack Full Version [Latest 2025]
FL Studio Crack Full Version [Latest 2025]
Jackson lithms
The Love of a Father 06 15 2025.pptx
The Love of a Father 06 15 2025.pptx
FamilyWorshipCenterD
Analysis of Tausog Language English.pptx
Analysis of Tausog Language English.pptx
MervieJadeBabao
Japan's Media and Telecom Markets: Evolution, Global Competition, and NTT Law...
Japan's Media and Telecom Markets: Evolution, Global Competition, and NTT Law...
Toshiya Jitsuzumi
Google Algorithm Updates A Complete Guide for Digital Marketing Students.pdf
Google Algorithm Updates A Complete Guide for Digital Marketing Students.pdf
Nithinks37
AC_Manufacturer_Strategy_Commercial_Government.pptx
AC_Manufacturer_Strategy_Commercial_Government.pptx
ajajsain
Briefing on the upcoming UNFSS +4 Stocktake
Briefing on the upcoming UNFSS +4 Stocktake
Francois Stepman
Joint Family And Nuclear Family to .. pdf.
Joint Family And Nuclear Family to .. pdf.
shrujapanchal813
ENGLISh.pptxtausug.pptxtausug.pptxtausug.pptx
ENGLISh.pptxtausug.pptxtausug.pptxtausug.pptx
MervieJadeBabao
ENGLISh.pptxENGLISh.pptxENGLISh.pptxENGLISh.pptx
ENGLISh.pptxENGLISh.pptxENGLISh.pptxENGLISh.pptx
MervieJadeBabao
2025-06-22 Abraham 04 (shared slides).pptx
2025-06-22 Abraham 04 (shared slides).pptx
Dale Wells
What say you - ethical issues in research
What say you - ethical issues in research
ssuser8aff01
PEN TO PODIUM powerpoint presentation.pptx
PEN TO PODIUM powerpoint presentation.pptx
Vanessa accad
Josaya - Abstract for the research of the youth development.pdf
Josaya - Abstract for the research of the youth development.pdf
Josaya Injesi
Bob Stewart Acts 18 06 18 2025.pptx
Bob Stewart Acts 18 06 18 2025.pptx
FamilyWorshipCenterD
Heating_Effect_of_Solar_Corona_Presentation.pptx
Heating_Effect_of_Solar_Corona_Presentation.pptx
Hanumamshukla
Bob Stewart Acts 17 Study 06 11 2025.pptx
Bob Stewart Acts 17 Study 06 11 2025.pptx
FamilyWorshipCenterD
Types of Information Sources (Primary, Secondary, and Tertiary Sources)
Types of Information Sources (Primary, Secondary, and Tertiary Sources)
jenicahmendoza1
Personal letter personal letter personal letter.pptx
Personal letter personal letter personal letter.pptx
GedeJuliana2
Ad

What is Salesforce Connect by Harry Potter

  • 1. Access your data out of Salesforce as if it was in using oData Esteve Graells Software Architect esteve.graells@gmail.com (forcegraells.com) @forcegraells
  • 2. Who is who is this story? Business You Guidance Salesforce
  • 3. Challenge Its vital to our business to access a set of data ,in another system. You need to do it this week, and with no code, and you cant copy the data. I know you cant do it.
  • 4. Hope Harry, do not panic. I remember a group of outlaws did something amazing, some years ago, in a weird place.
  • 5. back in 2007 2007 Jordi Graells was Born Microsoft SQL Server Team initiates Project Astoria Harry Potter and the Order of the Phoenix was the years top movie
  • 6. Microsoft Astoria Project Translation for humans: SQL for the Web https://blogs.msdn.microsoft.com/odatateam/2007/07/18/welcome/ The goal of the Astoria project is to enable applications to expose data as a data service that can be consumed by web clients.
  • 7. Demo Venerable Microsoft Northwind Database DIY : my Postman Collection is shared here - https://www.getpostman.com/collections/993c37d4aa583270bbf8 Interested on learning oData: http://docs.oasis-open.org/odata/odata/v4.0/odata-v4.0-part2-url-conventions.html
  • 8. Demo (connectors) My Contacts and Tasks on gMail Database on Amazon WS What if my source cant be offered natively as an oData service?
  • 9. Salesforce Lightning Connect 2014 oData 4.0 standardized by OASIS. SAP, Microsoft, Salesforce and other Big Players are using it extensively Salesforce introduces Lightning Connect Interstellar was the years top movie, space travelling at light speed
  • 10. What is Salesforce Connect? (formerly Lightning Connect) External Data Sources External Objects Link External objects with Standard/Custom objects Reporting, List Views, Tabs, etc. Youre done :no code, and pretty fast to set up
  • 11. Demo Real Scenario oData via Salesforce Connect Whatever dont care & dont mind HR Database in AWS Training App oData Connector
  • 12. Demo Real Scenario Internal Lookup External object to Custom/Standard External Lookup Custom/Standard object to an External Teachers Custom Object Attendees Custom Object employees External Object courses External Object Attendees links to 2 external objects employee and course Courses links to Teachers
  • 13. Needs an oData Source (abstraction) Point & Click Features depends on oData connectors capabilities (some limitations apply) Data Access oriented, no business process oriented Opex Reusable (somehow) Limits (100 external objects/org, 10,000 OData queries/hour High Volume option - higher on request, 8MB response size) API Services developing + infrastructure Development (devops, managers, meetings, arghh!!!) Develop crazy, out of this world biz requirements possible Business Data Services oriented, completely versatile Opex and Capex Reusable (somehow) Software Project Limits (the ones you already know and easy to increment) oData versus API Services Different approaches with distinct results
  • 14. Source data cant be copied (regulations) or is not convenient (Huge volumes) A platform object is required (Reporting, Listing, relationships, etc.) Need fast implementation (no time for API Development), No code and minimize software maintenance Access Heterogeneous source data (remember my google contacts needs capable connector ) Accessing to systems already offering oData Endpoints (i.e. SAP) New approaches like using External Objects for Big Data accessing an OnPremise Hadoop from Salesforce (/SumitSarkar10/salesforce-external-objects-for-big-data) Common Use Cases for Salesforce Connect
  • 15. From Wizard to Jedi Master Forget about Connectors and create your Own Integrate with anything - well, anything that we can get to from Salesforce by using HTTP callouts (good coding required) Apex Connector Framework
  • 16. Q & A Esteve Graells Software Architect esteve.graells@gmail.com (forcegraells.com) @forcegraells
  • 17. Thank You Remember to tell us what you think in the event survey www.LondonsCalling.net/survey/ Esteve Graells Software Architect esteve.graells@gmail.com @forcegraells - (forcegraells.com) DATA