Salesforce External Object Reports: Oracle, SQL Server and More

Salesforce External Object Reports: Oracle, SQL Server and More

October 13, 2016 0 Comments

After attending Dreamforce, the two things we are most excited about are Hybrid Data Pipeline and Salesforce External Objects. Here is why they matter.

We had an amazing time at Dreamforce 2016! We met lots of new faces and made quite a few new friends. If you met us at the event, you know how excited we are for both our new lightweight connector, “Hybrid Data Pipeline,” as well as support for Salesforce External Objects, which is pending release later next year. For more information about Hybrid Data Pipeline as well as your chance to preview it, read our blog post.

Convenience of Salesforce Reporting, Powered by Real-Time Access to On-Premises Data

Why are we so excited for Salesforce External Objects? Salesforce shops, including ourselves, have been impatiently waiting for reporting to support external objects. Progress DataDirect has tens of thousands of users accessing back office data with the DataDirect Cloud OData service for external objects, and all of us are excited about this new development being released in winter 2017.

What This Means

Salesforce users can now run reports that access external data from cloud and on-premises sources, including warehouses, marts, lakes and more. With Salesforce Connect External Objects, you get real-time connectivity that is self-service for Salesforce Report developers. The most popular reporting databases we’re already getting requests for include:

  • Oracle [Exadata]
  • Microsoft SQL Server
  • Greenplum
  • Amazon Redshift
  • IBM DB2
  • Hadoop Hive (including Cloudera, Hortonworks, IBM BigInsights or MapR)

This new reporting feature is available in both Lightning Experience and Salesforce Classic.

Oracle and SQL Server

Who Does What?

Salesforce: External Object Reports is a feature of Salesforce Connect. Salesforce Connect is an offering from Salesforce that provides seamless integration of data across boundaries.

Progress: External objects require an OData adapter for reporting databases, and this is provided by DataDirect Cloud. Progress DataDirect is the undisputed leader in data connectivity for reporting (eight of the top nine leaders in Gartner’s Magic Quadrant for BI run on our connectivity), and we’re excited to expand our growing footprint in the cloud with the Salesforce Platform.

Real-time Oracle integration with Salesforce Connect and DataDirect Cloud

Get Started with Your Winter 2017 Org

Discover the BIGGEST Salesforce Object Ever Seen at Dreamforce

BIGGEST Salesforce Object Ever Seen at DreamforceIn Suit's blog post, he further discuses his Dreamforce session on the best practices and lessons learned in accessing external data sets in Hadoop or Spark using Salesforce Connect. This enables you to leave your big data behind the firewall and but still provide users on-demand access to big data insights using External Objects via Salesforce Connect. The slides from his session are located in Slideshare.

Highlights from Dreamforce 2016

Dreamforce 2016

Get Started with OData and External Object Reports

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 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
ProgressNEXT: Premier Event for Modern Application Development
Read More
Creating Quick, Codeless Connectivity with Autonomous REST Connector
Read More
Getting Started with Kinvey
Read More