Home Services Partners Company
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 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:

  • 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 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.

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. https://twitter.com/SAsInSumit/status/521708493594562561 https://twitter.com/SAsInSumit/status/521714450466762752 https://twitter.com/SAsInSumit/status/521729243248488449

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.

sfdc-integration2

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.

sfdc-integration1

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 about DataDirect Cloud today

Learn more by visiting DataDirect Cloud.

Sumit Sakar

Sumit Sarkar

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. 

Comments
Comments are disabled in preview mode.