Back to Top

Odoo Tableau Connector User Guide

Updated 18 July 2024


Odoo Tableau Connector:  Unleash the ability of Data Visualization!!

Tableau is a leading business intelligence platform trusted by millions of users worldwide and enables the user with a user-friendly interface, scalability, strong data analysis, and data visualization tools.

Integrate your Odoo with Tableau and unlock the power of your data: Our Odoo Tableau Connector allows you to analyze vast amounts of data within the Odoo system.

It also helps you to identify business growth and optimize business operation efficiency.

Odoo AI Dashboard is an exceptional tool that simplifies the process of extracting valuable insights from your Odoo data. With its powerful search functionality, you only have to enter your query and get instant visuals

Searching for an experienced
Odoo Company ?
Find out More


  1. It imports Projects and Tableau workbooks directly into Odoo for centralized control and easy access.
  2. Smoothly export and visualize your Odoo data within Tableau for clearer insights.
  3. Users can create several projects on this module.
  4. Build data sources within Odoo with defined structures and tables, then export data to the tableau for further use.
  5. Utilize the Cron scheduler to ensure your workbook always reflects the latest data.
  6. Import workbooks directly into Odoo for a unified reporting environment.
  7. A ‘reset_connection’ button allows for easy disconnection and re-editing of credentials.
  8. Grant access levels to related projects based on user roles using the “Responsible User” feature.

Explore and check out our Odoo development services and a plethora of quality Odoo Apps.


  1. Once you purchase the App from the Webkul store, you will receive the link to download the zip file of the module.
  2. Extract the file on your system after the download finishes. You will be able to see a folder named- ‘odoo_tableau_connect.’
  3. Copy and paste this folder inside your Odoo Add-Ons path.
  4. Now, open the Odoo App and click on the Settings menu. Here, click on Activate the Developer Mode.
  5. Then, open the Apps menu and click ‘Update Modules List.’
  6. In the search bar, remove all the filters and search ‘odoo_tableau_connect.’
  7. You will be able to see the module in the search results. Click on ‘Install’ to install it.

Also, Check out our other Odoo ERP Connector For Magento it integrates Odoo with Magento and successfully brings out the best.


Setting Up Odoo Connector:

1. Log in to your Odoo App and Navigate to the Odoo Tableau Connector module.

Odoo Tableau Connector

2. Under the configuration menu, You will find the option to create a connection.

Odoo Tableau Connector connection option

3. Click the ‘New’ button in the top left corner to create a new connection.

Odoo Tableau Connector new connetion

4. Fill in the following details to configure the connection:

Name: Fill in the name of your connection. 

Server URL: Fill in the URL of your Server i.e. the URL of your tableau instance.

Auth Method: Select the authentication method with which you want to connect your odoo and Tableau App. there are two options for connecting your odoo and tableau i.e. PAT tokens and User Credentials. Select ‘User Credential’ from the Auth Method dropdown.

Odoo Tableau Connector  Credentials

5. Under the Credentials Tab, Enter the Username and password of your tableau account.

6. Navigate to the General Tab and Fill in the Tableau Site Name. You can get the site name from the  URL of the tableau.

Odoo Tableau Connector  General setting

7. Now, Click ‘Test Connection.’ and your odoo and tableau will be connected.

Odoo Tableau Connector  Connection succesfull

Are you looking for some easy-to-use connectors ?? Explore our Odoo Opencart connector that will Integrate your Opencart store with Odoo.

Creating New Projects

8. Navigate to the project section under the projects tab and create a new project by clicking the new button.

Odoo Tableau Connector  Project options
Odoo Tableau Connector  new project

9. Fill in the details of the new project.

Name: Provide a name for your project 

Responsible User: Assign a user who will be responsible for the project.

Tableau Instance: Select ‘Tableau Instances’ Under which you want to create a project

Odoo Tableau Connector  configure new project

10. Now, Click the ‘Publish’ Button to publish the project from odoo to Tableau. A pop-up window will appear as ‘Project Successfully Exported’

Odoo Tableau Connector  project sucessfully exported

Configuring a New Datasource:

11. Navigate to the Datasourc section under the projects tab and create a new datasource by clicking the new button on the top left corner.

Fill in the details of the new Datasource.

Name: Provide a name to your datasource 

Tableau Instance Select ‘Tableau Instances’ Under which you want to create a Datasource.

Hyper file name: this will already be configured according to your datasource.

Run Cron: Enable this feature if you want to sync your datasource with a set interval of time.

Description: Describe your datasource.


Creating a New Table:

12. Navigate to the table section under the projects tab and create a new table by clicking the new button.

Fill in the details of the new project.

Name: Provide a name for your project 

Datasource: Assign a Datasource under which you want to create a table.

Model: Select a model for which you are creating a table.

Tableau Instance:  Select ‘Tableau Instances’ Under which you want to create a table.

Run Cron: Enable this feature if you want to sync your table with a set interval of time.

table creation

Configure Table:

13. Click ‘Add a line’ under the Columns tab. A popup window appears. Select the desired field from the dropdown menu. Click ‘Save & New’ to add more columns as needed and Save & close to view the final table.

add fields in the table
table configured

Publish Project

14. Navigate to the Project and click on the publish button in the top left corner to publish your project from odoo to Tableau.

project sucessfully updated

Export Datasource

15. Navigate back to the ‘Datasource’ menu. Click ‘Publish’ to make the datasource available in Tableau.

export datasource

16. Click on ‘Export Data’ to make your data accessible in Tableau. A new pop-up window will appear showing ‘Data source successfully exported’.

Datasource Sucessfully exported

Setting up Workbook Embedding:

17. Go to the ‘Project’ section and update your project. In the connection details, navigate to ‘General Option’ and check ‘Enable Workbook Embedding.’

Workbook Embedding option

18. Under ‘Embedding Credentials,’ fill in the following details: Email, Client ID, Secret ID, Secret Key. You can get all these by navigating to settings >> Connected app >> Select the app >> Access the Client ID, Secret ID, and Secret Key.

workbook embedding credentials

Importing Workbook:

19. Navigate to your Tableau Connection from the ‘Configuration’ menu and Choose ‘Import Workbook’ Select your Tableau Instance and project from the popup window. Click ‘Import’ to import the workbook.

Import option in odoo tableau connector
import workbook

20. Your Workbook is successfully imported from the tableau to odoo apps

workbook successfully exported

Viewing Your Project:

21. You can access your workbook list from the ‘Workbook’ section. Click on your desired workbook to view your Odoo data visualizations in Tableau.

workbook list
Workbook view


Hope you find the guide helpful! Please feel free to share your feedback in the comments below.

If you still have any issues/queries regarding the same, please raise a ticket at the UV Desk.

I hope this helps. In case of any further queries, contact us at our support mail.

Thanks for paying attention!!

Current Product Version - odoo 17, 16, 15

. . .

Leave a Comment

Your email address will not be published. Required fields are marked*

Be the first to comment.

Back to Top

Message Sent!

If you have more details or questions, you can reply to the received confirmation email.

Back to Home