Tableau analytics integration with databricks delta lake

[Ruby8376]

Hii there!!

Currently, we are exploring options for reporting on Salesforce. We extract data from salesforce via databricks and store it in delta lake.

Is there a connector by which data can be pulled from databricks into Tableau/CRM analytics??

I know that tableau databricks connector exists by which we can integrate databricks with on prem tableau… but looking for options to integrate databricks with CRM analytics!!

thanks in advance!!

[emillion25]

Hello @ruby 

Were you able to resolve this? I know it's been a while, but I believe we now have multiple ways to connect Tableau and Databricks.

1. Use the Native Databricks Connector for Tableau

• Tableau has a built-in Databricks connector, making it easy to connect to your Delta Lake tables directly.
• Steps to connect:
  1. In Tableau, go to Connect → Databricks.
  2. Enter your Databricks SQL Warehouse (formerly SQL Endpoint) credentials.
  3. Select the Delta Lake tables you need.
• This provides live queries and direct data access to your Databricks environment.

🔗Reference: https://docs.databricks.com/en/partners/bi/tableau.html

---

2. Connecting Databricks to Salesforce CRM Analytics (formerly Tableau CRM)

If you specifically want Databricks data in Salesforce CRM Analytics, you have a few options:

A. Use JDBC to Pull Data from Databricks

• CRM Analytics supports external data ingestion via JDBC.
• You can configure CRM Analytics to connect to Databricks SQL Warehouse using JDBC.
• This allows CRM Analytics to query Delta Lake tables directly.

B. Export Delta Lake Data to Salesforce via API

• If you need a batch sync, Databricks can export data to Salesforce objects using the Salesforce Bulk API.
• Once in Salesforce, the data can be used within CRM Analytics dashboards.

🔗Reference: https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/ 

---

 

3. Tableau Bridge for Cloud-Based Access

• If your Tableau deployment is in Salesforce Cloud or Tableau Online, you may need to use Tableau Bridge to securely connect to Databricks.
• Tableau Bridge keeps data refreshed without requiring direct database exposure.

🔗Reference: https://www.tableau.com/support/releases/bridge

Did you end up using any of these?