Introduction

Tableau is a lightweight data visualization analysis platform that combines data operations with beautiful charts perfectly. It seamlessly combines data computation with visually appealing charts, requiring no coding from the user. By simply dragging and dropping, users can quickly gain insights into the data. They can explore different views and even easily combine multiple data sources to complete tasks such as data visualization, exploration, and analysis.

Precondition

Tableau Desktop via the following link to download: https://www.tableau.com/products/desktop/download

Driver installation

  1. Install iODBC
    1. Close the Tableau Desktop
    2. Install iODBC Driver Manager. Obtain the latest version (mxkozzz.dmg) from iODBC.org
    3. Click on the downloaded dmg file to install
  2. Install the MySQL driver

When choosing the ODBC driver for MySQL to connect to Doris, you should install the MySQL 5.x ODBC driver. Using the latest MySQL driver may result in an “Unsupported command” error when connecting to Doris.

Connection Configuration and Usage

  1. Click the Tableau Desktop home page and select MySQL at the connection data source

    main page

  2. Fill in the Doris server address, port and other relevant information, and click sigin in button after correctly filling

    sign in page

  3. After entering Tableau, select the corresponding library table to carry out the relevant compass processing.

    usage page