Push a Single View from MDP

Integrate Marketing Cloud Intelligence Data Pipelines with Tableau by pushing a single view. During the process, you create a Tableau view, a Tableau feed, run the data source, and then visualize your data in Tableau Online.

Note Tableau views are limited to 5 million rows in a single execution.

1. Go to Export.
2. Select Tableau Data Connection.
3. Create a Tableau view.
4. On the Create New View page, enter these details:
   1. Name the report.
   2. For Export Format, the default is Tableau, and it’s recommended to leave as is.
   3. Select the number of days after which reports are deleted. For example, if you enter 30, after 30 days all reports are deleted from MDP. By default, the number of days is 180, which is also the maximum number of days you can save history.
   4. Select the time period from which you want to retrieve data.
   5. Select the measurements that you want to include in the report.
   6. Select the dimensions that you want to include in the report.
   7. To add a filter, click Add Filters.
   8. Save and run your report.
5. Create a Tableau feed:
   1. Click Create New Tableau Feed.
   2. Enter the data source name.
   3. In the Views List, select the Tableau view that you created.
   4. To send the view to Tableau Server or Tableau Online, select Send to Tableau Server/Online. If you select this option, enter the delivery setup information and click Next.
   5. If you aren’t sending to Tableau Server or Online, click Create & Run.
6. Define the delivery setup:
   1. If you want to use a private access token instead of a username and password, enable Private Access Token, and enter the token name and secret. A token is especially useful for customers who use SSO, Active Directory, or LDAP authentication. For more information see Personal Access Tokens.

      

   2. If you don’t want to use a token, enter your Tableau username and password.
   3. Enter your server URL and site name. The server URL includes everything from https to tableau.com, for example, https://10ax.online.tableau.com. The site name is after site/, for example, datoramademo.

      

      

      Note If the URL doesn’t include a site name or if there’s a #, it’s the default site, so enter Default.

      After entering the server and site information, the Tableau Project and Data Source fields are generated.

   4. To create a new data source in Tableau, select Publish a New Data Source.
   5. From the Frequency dropdown, select how often you want the data to be published.
   6. Save your work. The data feed is created and appears as a new tile on the Tableau Data Connection page.

      

7. Run the data source:
   1. On the Tableau Data Connection page, select the tile.
   2. Click Options, and then select Run Now. After the source runs successfully, a Success status appears. If the job fails, a Failed status appears.
   3. To view all jobs, go to Execution History.
8. Visualize your data in Tableau Online: