What is Seller Labs Generic MySQL Connector?
The Seller Labs Generic MySQL Connector is a feature within the Seller Labs Data Hub that enables users to access and query their eCommerce data directly using MySQL. This connector allows for seamless integration with various reporting and visualization tools that support SQL, such as Tableau, Microsoft Power BI, Looker Studio. By utilizing the Generic MySQL Connector, users can efficiently analyze their Amazon seller data, create custom reports, and gain actionable insights to drive business growth.
To ensure secure and authorized access, it is important to whitelist specific IP addresses for the Generic MySQL Connector. This process restricts access to your data, allowing only authorized users to connect and preventing unauthorized access and potential security breaches.
1. Confirm Access Details
Ensure you have the following connection credentials from Seller Labs or your MySQL server setup:
Host
Port
Username
Password
Database name
You can find these credentials on the Data Hub page. If they are not visible, follow the instructions on how to establish the connection and whitelist IPs.
2. Connect via Data Visualization/BI Tools
If you are using software like Tableau, Power Query, or Looker Studio, follow these steps:
Set Up the Connection
Open your BI Tool and navigate to the MySQL connection setup.
Input your Seller Labs MySQL credentials:
Host: Provided by Seller Labs
Port: Default is 6603
Username and Password: As provided
Database Name: The relevant database
Test the connection to ensure it is working.
Import Data:
Select tables or write custom SQL queries to pull the required data.
Please check step-by-step instructions for Tableau, Power Query, Looker Studio and BigQuery.
3. Install MySQL Client Library (Optional)
Many BI tools have built-in connectors, but if you need additional client libraries or drivers, install them as follows:
Python: Install the mysql-connector-python or pymysql library:
pip install mysql-connector-python
Java: Use the MySQL JDBC driver (
mysql-connector-java).PHP: Use mysqli or PDO_MySQL for database connections.
4. Connect Using Code (Optional)
If you prefer to connect via code, use the connection details provided by Seller Labs. Below are examples in Python and PHP.
Python Example
import mysql.connector
# Replace with your Seller Labs MySQL credentials
connection = mysql.connector.connect(
host="your-mysql-host.com",
port=6603, # Default MySQL port
user="your-username",
password="your-password",
database="your-database-name"
)
if connection.is_connected():
print("Successfully connected to the MySQL database!")
cursor = connection.cursor()
cursor.execute("SHOW TABLES;")
for table in cursor.fetchall():
print(table)
cursor.close()
connection.close()
PHP Example
<?php
$servername = "your-mysql-host.com";
$username = "your-username";
$password = "your-password";
$database = "your-database-name";
// Create connection
$conn = new mysqli($servername, $username, $password, $database);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
// Fetch data
$result = $conn->query("SHOW TABLES");
while ($row = $result->fetch_assoc()) {
print_r($row);
}
$conn->close();
?>
5. Firewall and Security Considerations
When connecting over the internet, ensure the following:
The MySQL server is configured to allow external connections (bind-address setting in my.cnf or my.ini).
The correct port (default: 6603) is open in your firewall.
Use SSL for secure connections, if supported by Seller Labs.
6. Test Your Setup
Before integrating with any tool or software, test your connection using a database client such as:
MySQL Workbench
DBeaver
HeidiSQL
Troubleshooting Common Issues
If you encounter issues, verify the following:
Incorrect credentials: Double-check username and password.
Firewall settings: Ensure your IP is whitelisted and the correct port is open.
MySQL service availability: Confirm that MySQL is running and accessible.
Error Messages:
"Access denied for user..." → Verify username, password, and whitelisted IPs.
"Could not connect to MySQL server" → Ensure MySQL service is active and the hostname is correct.
By following these steps, you should be able to successfully connect to the Seller Labs MySQL Connector and start working with your eCommerce data efficiently.
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