MySQL
MySQL is the world's most popular open-source relational database management system, a fundamental component for countless web applications and transactional systems.
Why Connect MySQL to Whatsdash?
Integrating your MySQL database with Whatsdash allows you to unlock the raw power of your transactional and application data, transforming it from a data storage system into a source of real-time, actionable business intelligence for all stakeholders.
-
Simplified Real-Time Reporting: Connect directly to your live database to pull custom datasets and metrics into visual, easy-to-digest dashboards without needing to run complex, repetitive SQL queries.
-
Custom Metrics & Granular Control: Use Whatsdash's interface to build reports based on the exact SQL queries your business needs, creating Custom Metrics and visualizations from any table or view within your database.
-
Data Blending & Cross-Source Analysis: Combine key performance indicators (KPIs) from your MySQL database (like sales orders or user signups) with data from other sources (e.g., Google Ads spend, Shopify inventory) to get a true, holistic view of your business's performance.
📋 Steps to Integrate your MySQL Database to Whatsdash
💡 Tip : When setting up the MySQL connection, always use a dedicated, read-only database user to ensure the reporting tool can only retrieve data, not modify or delete it, maintaining the security and integrity of your live application database.
📋 Steps to Integrate your MySQL Databases to Whatsdash
Integrating your SQL Server instance typically involves providing connection details and credentials to establish a secure link. We will incorporate the detailed steps for selecting the specific data source and defining its schema (Dimensions and Metrics) for Whatsdash.
Step 1: Configure Connection Credentials 🔐
✔️ Navigate to the 'Integrations' page using the Navigation bar.
✔️ Select MySQL from the Available Integrations.
✔️ Click the + button to open the connection configuration window.
✔️ Enter the following required connection parameters for your SQL Server Connection:
Host Name/IP: The hostname or IP address of your SQL Server.
Port: The port number (default is typically 1433, but specify if different).
Username: The SQL or Domain user name.
Password: The corresponding password.
✔️ Click Next button to ensure the provided credentials and details can successfully connect to the database.
Step 2: Select Database and Tables/Views 📁
Once the connection is validated, the system will allow you to specify the exact data source within the server.
Select Database:
Select Tables/Views: You will be presented with a list of available tables and views within that database. Select the specific table or view containing the core data you intend to query (e.g., the Sales.Orders table or a specific reporting view).
Click Next to proceed.
Step 3: Define Dimensions and Metrics (Schema) 📊
In this crucial final step, you define how the columns from your selected table/view will be interpreted and used in Whatsdash reports.
Specify Fields: You are now prompted to specify which columns from your selected tables will be treated as Dimensions and which will be treated as Metrics.
Dimensions: Select columns that categorize or segment data (e.g., OrderDate, CustomerID, ProductCategory).
Metrics: Select columns that contain numerical values you want to measure, aggregate, or calculate (e.g., OrderTotal, LineItemQuantity).
Finalize Integration: After defining your core dimensions and metrics, the connection is finalized.
✔️ Once the process is complete, click Next. Your MySQL Integration will appear in the Connected Integrations list.
🔗 Explore More Integrations
Whatsdash supports a wide range of marketing, analytics, and eCommerce integrations to give you a holistic view of your business performance.
👉 Visit the Integrations Page to explore all available connections