Follow the steps below to connect the Seller Labs MySQL database to Tableau:
Step 1: Prepare for the Connection
Obtain MySQL Connection Details from the Seller Labs Data Hub page. If you do not see them there, feel free to check these instructions on how to establish the connection and whitelist IPs if needed:
SQL Host Server (e.g.,
servername.data.sellerlabs.com
).Port number (default: 6603).
Database name.
Your username and password.
Install MySQL ODBC Driver (if not already installed):
Tableau uses the MySQL ODBC driver to connect to MySQL databases. Download the driver from MySQL ODBC Downloads.
Install the driver on your system.
Step 2: Open Tableau and Initiate Connection
Launch Tableau Desktop.
On the start page, under Connect, select MySQL.
Step 3: Configure the Connection
Enter MySQL Connection Details:
Server: Enter the hostname provided by Seller Labs (e.g.,
servername.data.sellerlabs.com
).Port: Enter the port number (default is 6603 unless Seller Labs specifies a different port).
Database: Enter the database name given by Seller Labs.
Username: Enter your Seller Labs MySQL username.
Password: Enter your password.
Click Sign In to connect.
Step 4: Verify the Connection
If the credentials and connection details are correct, Tableau will establish the connection and display the database schema.
You should see a list of tables and fields available in the Seller Labs MySQL database.
Step 5: Start Analyzing Your Data
Drag and drop tables or fields into the Canvas to create your data source.
Start building visualizations by creating sheets, dashboards, and stories in Tableau.
Troubleshooting Tips
Connection Errors: If you encounter errors, verify:
The hostname and port are correct.
The username and password are accurate.
The MySQL ODBC driver is installed and compatible with your Tableau version.
Firewall or IP Whitelisting: Ensure that your network or IP is whitelisted by Seller Labs if required.
By following these steps, you should be able to successfully connect Seller Labs MySQL Connector to Tableau and start analyzing your data.
Need help? Our support team is happy to assist you! 🙂
Connect via the in-app chat icon, located in the bottom-right of your screen while logged into any of our apps
Search the Knowledge Base to see if your question has already been answered
Make an appointment with us for more direct support
*No Credit Card Needed