Integrating with Tableau

[Anonymous]

We have selected Tableau for our reporting needs. I am curious if anyone is using Tableau internally and if so, how are you moving the Marketo data over to Tableau. We want to have raw data, not data that has passed through a 3rd party app (like SFDC). Our goal is to be able to slice and dice within Tableau.

Any suggestions are appreciated!

[Diederik_Marte4]

I now use a method for all data we need to export.

1. I have set up a static list in Marketo
2. I have a batch campaign that removes everyone from that list everyday at 9pm.
3. I have a batch campaign that adds new people to the list everyday at 10pm.
4. We have a script in our data ware house with ReST API to get all leads from the static list and with that selecting the fields we need (http://developers.marketo.com/documentation/rest/get-multiple-leads-by-list-id/). This script runs daily at 11pm.

The batch campaign has a smartlist that is based on ANY. And every filter is "Data Value Changed in past 30 hours". This for every field we export. And there is a "lead was created in past 30 hours). This allows the ReST API script to only exstract the new records and updated records. Obviously we did a one-time export to get started.

This method works pretty well for us, as the reporting is high-level and a daily update is sufficient.

[Anonymous]

We use Tableau internally here.  We are currently investigating a couple of products to help us navigate the Marketo API and its limitations.  We are investigating Informatica and Jitterbit.

An integration with Tableau would be wonderful.  I wonder why Marketo chose Microsoft Power BI to build an integration? 

Getting data out of Marketo has been a continual source of frustration where I am.  Its a shame that we are going to have to spend extra money to get our data out, but I will be happy if one of these tools works.  It is so frustrating that I have to export to excel and then manually add to Tableau.  

 

[Anonymous]

We continue to manually export out of Marketo and into Tableau.

Thanks,
Sierra

[Anonymous]

I'm investigating the RSSBUS ODBC drivers for Marketo in conjuction with PowerPivot. In theory this can be connected to Tableau using the OData data source. I'll report back when I'm further in the eval.

[Diederik_Marte4]

Hi, We're developing a custom environment right now.

[Anonymous]

@Sierra S and @Diederik - did any of you make a decision on which tools to use to connect Marketo data and Tableau? 

[Anonymous]

@Murtza Power BI is not an alternative for me as we've committed to using Tableau for visualization. Can you confirm that the large-volume data extraction has been assigned to a release? I don't need to know which release it is, but that would at least give us an idea of roughly when we can expect it.

[Anonymous]

@Brendon, I agree this is not a great experience.

It is on the roadmap to have an API that would allow for large-volume data extraction, which would then enable a Tableau connector. But there is no definite timeline. 

In the mean time, a solution similar to Tableau is Microsoft Power BI. We recently released an integration with Power BI:
http://support.powerbi.com/knowledgebase/articles/462795-marketo

[Jonathan_Ng2]

We're giving PowerBI a shot, but we can't get the integration to work.  We've increased our API count, but the import still fails.  We can get to the point where the data attempts to load, but it then fails shortly thereafter.  Do you have any tips, or ideas why it could be failing?

[Anonymous]

@Murtza - is a Tableau connector in the roadmap anywhere? Reporting that should take me 30 mins takes a day because of the lack of direct integration between the two.

[Anonymous]

Manual exporting is not an option for data ware house. I'm now investigating two tools, mentioned in this post:
https://community.marketo.com/MarketoDiscussionDetail?id=90650000000PwHQAA0. But there most definitly should be a direct connection possible. ODBC or support XML in ReST. And in ReST don't limit the filter on 1000.

[Anonymous]

Currently, we do not have a direct integration with Tableau. You would have to manually export from Marketo, then upload to Tableau. 

[Anonymous]

Do you have any indirect integration with Tableau via informatica cloud or the like?

[Josh_Hill13]

Are you not able to use the API integration or a connector into Marketo?