Salesforce Data Cloud

The Salesforce Data Cloud connector was released with Tableau Desktop 2023.2. This connector seamlessly connects Tableau to Data Cloud, and is available for Tableau Desktop, Tableau Cloud, Tableau Server and Tableau Prep. Compared to the older CDP connector, the Salesforce Data Cloud connector is easier to connect with, shows object labels instead of API names and is powered by accelerated queries.

Note: Data Cloud was previously called Customer Data Platform (CDP). The Customer Data Platform connector was deprecated in October 2023, was made unavailable for new connections in Tableau Desktop 2024.2 and has been removed entirely from Tableau Desktop 2024.3 and later. Existing assets that use the CDP connector must be recreated using the Salesforce Data Cloud connector.

If you're using Tableau Desktop 2023.1 or earlier, see Tableau Desktop (version 2023.1 and earlier).

Tableau Desktop (version 2023.2 and later)

Complete the following steps to connect to the Salesforce Data Cloud.

  1. Select the Data menu, then New Data Source. (If you just launched Tableau Desktop, ignore this step.)
  2. In the Connect pane, under the To a Server section, select Salesforce Data Cloud.
  3. Log in and allow access when prompted.
  4. Select the Data space. Data spaces represent a logical segregation of the data in Data Cloud. Data spaces didn't exist before the Salesforce June '23 release.
  5. If using Tableau Desktop 2024.1 or later, use Object to filter by the type of Data Cloud object, or select All Objects.

Tableau Desktop (version 2023.1 and earlier)

Warning: The Customer Data Platform (CDP) was deprecated in October 2023, was made unavailable for new connections in Tableau Desktop 2024.2 and has been removed entirely from Tableau Desktop 2024.3 and later. If you are using assets that use the CDP connector, Tableau strongly recommends you upgrade and use the Salesforce Data Cloud connector instead.

Step 1: Install the Salesforce Data Cloud.taco file

Note: This step applies to versions 2021.1–2021.3. Starting in version 2021.4, the Salesforce_CDP.taco file is automatically installed.

  1. Remove or rename any Salesforce_CDP.taco files that have been previously installed to avoid conflicts. The Tableau Desktop.taco files are installed in the following locations:

    • MacOS: /Applications/Tableau Desktop <VERSION>.app/Contents/Resources/connectors/Salesforce_CDP.taco
    • Windows: C:\Program Files\Tableau\Tableau 2022.3\bin\connectors
  2. Download the latest Salesforce Data Cloud connector (Salesforce_CDP.taco file) from the Tableau Exchange Connectors site: Customer Data Platform Connector.

  3. Move the.taco file to the Tableau connector directory:

    • Windows: C:\Users[Windows User]\Documents\My Tableau Repository\Connectors

    • macOS: /Users/[user]/Documents/My Tableau Repository/Connectors

Step 2: Install the Salesforce Data Cloud JDBC driver

Note: Tableau version 2023.1 for Desktop is only compatible with JDBC driver version 18 and above.

  1. Download the latest JDBC driver (Salesforce-CDP-jdbc-[version].jar file) from the Salesforce CDP GitHub site: Salesforce-CDP-jdbc.

  2. Move the downloaded Salesforce-CDP-jdbc-[version].jar file to the following location:

    • Windows: C:\Program Files\Tableau\Drivers

    • macOS: /Users/[user]/Library/Tableau/Drivers

    Note: Unhide the folders to view them.

Step 3: Enable a High Assurance Session

You can enable a High Assurance session to ensure that your connected app is secure. This session policy requires users to verify their identity with multi-factor authentication when they log in to the connected app.

    1. Log in to Salesforce as a CDP Admin.
    2. In the Salesforce Data Cloud, search for App Manager.
    3. In the Setup's Quick Find, search for Salesforce CDP Tableau Connection in the list.
    4. Select Manage.

    IMPORTANT: Make sure you’re clicking the dropdown for Salesforce CDP Tableau Connection only!

     

    1. Select Edit Policies.

    1. Under Session Policies, tick the High assurance session-required box.

    1. Select Save. High assurance config is now enabled.

Step 4: Connect to the Salesforce Data Cloud in Tableau Desktop

  1. Launch Tableau Desktop (2021.1 and later).

  2. Go to Connect,To a Server and select Salesforce CDP.

  3. In the Salesforce CDP dialogue, confirm that OAuth is selected in the Authentication section and https://login.salesforce.com is selected in the OAuth instance URL section.

  4. Select Sign In to open a pane in a web browser.

  5. Sign in to Salesforce with your username and password.

  6. Select Allow.

  7. Close the browser pane.

Tableau Desktop is now connected to the Salesforce Data Cloud and you can perform Tableau operations.

Tableau Cloud and Tableau Server

Connecting using Tableau Cloud Web Authoring is similar to Tableau Desktop.

Tableau Server requires additional configuration. Use the following links to find out more.

Next Steps

Use Accelerators for Quick Data Insights

You can quickly visualise your data using accelerators. Tableau Accelerators are pre-built dashboards designed to help you get a jump start on data analysis. Tailored to specific industries and enterprise applications. Accelerators are built with sample data that you can swap out for your own data, allowing you to discover insights with minimal setup. Accelerators are available on the Tableau Exchange. For more information about accelerators, see Use Accelerators to Quickly Visualise Data. You may want to try some of the following Salesforce Data Cloud accelerators.

Salesforce Data Cloud Identity Resolution Accelerator

You can use the Identity Resolution Accelerator to explore how identity resolution in Salesforce Data Cloud is working for your business. You can view your ingested sources, how they contribute to unified individuals and their composition. For more information, see Salesforce Data Cloud Identity Resolution.

Salesforce Data Cloud Email Marketing Campaign Accelerator

With the CDP Email Marketing Campaign Accelerator, you can monitor the efficiency of your email campaigns end to end. You can explore campaigns that have the highest conversion, email trends over time and more. For more information, see Salesforce Data Cloud Email Marketing Campaigns.

Salesforce Data Cloud Customer Engagement Accelerator

This accelerator is an exploratory dashboard that gives marketing and sales teams a comprehensive view of the engagement levels of customers across the following channels.

  • Sales
  • Email
  • Messages (SMS)
  • Website
  • Push Notifications

The accelerator helps these teams to select the best channels to interact with the customer, develop relevant messaging and create positive customer experiences to increase loyalty and retention. For more information, see Salesforce Data Cloud Customer Engagement.

 

See also:

Thanks for your feedback!Your feedback has been successfully submitted. Thank you!