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 OData.org 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:
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 Salesforce.com at Oracle OpenWorld ’14 two weeks ago, I’m now saying we can make Oracle data look like Salesforce.com 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.
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.
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 Salesforce.com data to BI tools to build beautiful visualizations and real-time dashboards.
Learn more by visiting DataDirect Cloud.
Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others.
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.