Salesforce external objects to on-premise Oracle, SQL Server #DF14

Salesforce external objects to on-premise Oracle, SQL Server #DF14

October 14, 2014 0 Comments

After consecutive sellouts at DF12 and DF13 for real-time SQL access to the Salesforce platform, I’m back at DF14 to take data connectivity in the opposite direction.  No, not stale noSQL access; rather the new beta external objects support that accesses non-Salesforce data via OData (JSON over REST) which is a new data connectivity standard I call "JDBC for the web" and I am a contributor to the community.  This is the hottest topic in data at the show for Platform Developers, IT Architects and SFDC Admins.

Examples of External Data you can access as native Salesforce objects via DataDirect Cloud OData support include:

  • On-premise ERP systems such as those built on Oracle (EBS), SQL Server (Sage), IBM DB2 (JDEdwards), or OpenEdge (QAD, Infor, Epicor)
  • Data Warehouse histories from systems such as Amazon Redshift, Cloudera, or HortonWorks
  • Marketing Data such as Marketo, Hubsopt, Eloqua, or Google Adwords
  • Related non-SFDC CRMs such as Microsoft Dynamics or Sugar CRM

Make Oracle look like Salesforce? #verycool__x

When presenting SQL access, I like to say that we make Salesforce look like Oracle or SQL Server.  For example, when you connect via Oracle Database Gateway or SQL Server Linked Server, Salesforce objects are federated over ODBC as being native to those RDBMS systems.

Now after having just presented this topic of SQL access to at Oracle OpenWorld ’14 two weeks ago, I’m now saying we can make Oracle data look like via native objects using DataDirect Cloud OData production.

This type of data federation is VERY exciting from hosted aPaaS platforms; and the concept of external data objects has been generally available from Progress Rollbase for almost a year now.

From the #devzone, Cloud Data Federation more popular than Wave Analytics?

There was a session hosted by Financial Force introducing the feature of external objects that included a live demo federating google spreadsheet data, but the crowd wanted Oracle and SQL Server on-premise which is where we come in.

Join me at my Dreamforce ’14 in the Cloud Expo, Partner Theater North at 10AM on Thursday

Here’s a preview of how we do OData:

And here are some screenshots showing the new external data object features.


Federate data in real-time as native Salesforce objects to on-premise ERP systems such as Epicor, SAP, Sage, Infor, QAD, Epicor, JDEdwards, Oracle, etc.


That's live ERP data access securely on-premise by the Salesforce Platform!


Platform intelligence: Outbound External Data Objects vs Inbound BI Connectivity

Abstract: Getting data in and out of Salesforce is possible, but the process is spreadsheet oriented.  You want to enrich your Salesforce view with external data – from your data warehouse, your marketing platform, and other business systems.  You also want to analyze and report on that data using your favorite BI tool such as Tableau or Qlikview.  Join Sumit to learn how to leverage Salesforce’s External Data Objects to access data from external systems, and provide all of your data to BI tools to build beautiful visualizations and real-time dashboards.

Learn more about DataDirect Cloud today

Learn more by visiting DataDirect Cloud.

Sumit Sakar

Sumit Sarkar

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.

Comments are disabled in preview mode.
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
2020 Progress Data Connectivity Report
2020 Progress Data Connectivity Report
Read More
Getting Ahead of the Hybrid Data Curve
Read More
570x321__Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Read More