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.
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.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You have the right to request deletion of your Personal Information at any time.
You can also ask us not to pass your Personal Information to third parties here: Do Not Sell My Info
Copyright © 2020 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, 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.