How to connect Hubspot, Marketo and Eloqua to Tableau

How to connect Hubspot, Marketo and Eloqua to Tableau

April 22, 2015 0 Comments

Sumit Sarkar helps marketers navigate the often confusing world of  data preparation  when using marketing SaaS applications as a data source.

For the last couple years, I have been working with Tableau developers, marketing data scientists, consultants and ISVs, showing them how to integrate SaaS data using Progress® Easyl™. In doing so, I've seen a lot of interest in marketing data sources like Hubspot, Marketo and Eloqua. This isn't all that surprising given the glut of articles and surveys describing the rise of data and technology driven marketing organizations.  These marketing clouds work very well given the volumes of data I've seen across activity and lead objects, but that usability comes at a cost – access to the data.

What does Self-Service Data Prep do for marketing?

During my POCs, I've overheard a lot of business questions being asked, and marketers have a lot of them. Questions like:

  • What happened with our landing pages last month?
  • How do we measure leads for campaigns such as webinars, customer support, videos, etc?
  • How many e-mails were sent, opened, delivered per campaign?

Even though it seems like these would have simple answers, the data you would find those answers in is often spread across multiple SaaS applications and very hard to access. This is where Progress Easyl comes in, making data available to Tableau either in real-time or as a scheduled native Tableau Data Extract (TDE) file. It all happens within our cloud platform without any additional software or staging database requirement.

And it's pretty cool that Dustin Smith, Product Marketing Manager from Tableau endorsed our technology for marketing folks during a joint webinar last year.

How does Easyl uniquely pull SaaS marketing data? (Data Nerd to Tableau Geek translation)

As a data nerd, I like getting down into the weeds and looking at APIs and raw data whereas Tableau geeks (and other normal people) prefer to visualize their data.  Easyl does the ugly work of preparing data and below are examples of awesome things you may or may not really care about:

What this data nerd thinks is cool about Easyl: What Tableau users really care about:
“Behind the Hubspot scenes, pulling contacts out of the Hubspot API can be tricky in customized instances with hundreds of long field names since the API has a maximum of 8200 bytes. Easyl eliminates the pains of pulling contacts out of Hubspot by transparently pulling individual batches of fields within the API request length for final and complete presentation to Tableau.” I can actually see all of my Hubspot data in Tableau!
“Pulling LEAD records from Marketo can easily get into the millions of records and fail to return from the API by design based on cloud infrastructure governors. We introduced pseudo-columns (oldestUpdatedAt and latestUpdatedAt) to pull those into batches and automate that in Easyl to make it seamless to the user.” I can create visualizations against large data sets in Marketo which are refreshed daily.
“Eloqua REST API 2.0 (Oracle Marketing Cloud) introduced support for activity types, and this was not available against connectors originally built with REST 1.0. Since Easyl is a cloud service, these changes can be transparently updated behind the scenes to always give you the best view of Eloqua.” I can create really cool visualizations across Eloqua activity types to analyze campaign success.

In summary, our goal is to transparently present the latest data available from marketing application APIs. That way, Tableau users can focus on making awesome visualizations rather than worry about all the nerd talk above that we handle with a team of engineers who don’t sleep well.

Since I’m a techie, I’ll tell you what data is not available through APIs as of today—even if marketing preferred I didn't:

  • Oracle does not expose the Eloqua Insight Data Model, but it is possible to get a lot of the same data through standard APIs exposed by Eloqua.
  • Hubspot does not currently expose Call To Actions from Hubspot APIs.

We do work closely with all the Marketing SaaS vendors, and share this feedback so you can get all the data you want.

The Easyl Experience

1. Pick what data you want.

The biggest complaint we hear is about SaaS data models is that they are hard to understand and make it difficult to see what the data actually looks like. Our solution is Easyl Data Blender which lets you visualize the data alongside quality statistics. This is usually the first time shops have seen Hubspot, Marketo, or Eloqua data outside of those applications:

screenshot  of Easyl accessing Hubspot data

Viewing Hubspot data with Easyl Data Blender

2. Choose how you want it delivered.

Once you have prepared the data you want and decided how often to refresh it, you have two options:

  1. Generate a Tableau Data Extract (TDE) file to be delivered directly to your desktop or published to Tableau Online.
  2. Connect live using the Progress Easyl ODBC client which works with tools beyond Tableau such as Qlikview, Sportfire, Microstrategy, or SAP Lumira.

Tableau screenshot showing Easyl connectivity

Tableau can utilize Easyl data through ODBC

Get Started with Data Preparation for Marketing SaaS

There’s no way to get around it, working with data like this can be a challenge to the uninitiated, so it’s important to know you're not alone! We want you to leverage our collective experience, so drop us a line  or leave me a comment below. We’re here to help! Then, once you’re eager to jump in, register to get started with Progress Easyl for SaaS Marketing data.

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
Comments are disabled in preview mode.
Topics
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
autonomousrest
Creating Quick, Codeless Connectivity with Autonomous REST Connector
Read More
 
kinvey-console-thumbnail
Getting Started with Kinvey
Read More
 
openedge-12-overview-datasheet
OpenEdge 12.0 - Powering Tomorrow's Evolution
Read More