Importing Data from MySQL Database
Last updated April 17, 2024
Introduction: MySQL databases are widely used for storing structured data, and Chartbrew makes it easy to import data from your MySQL databases for visualization and analysis. In this guide, we'll walk you through the simple steps to import data from a MySQL database into Chartbrew.
Step-by-Step Guide:
- Navigate to Data Sources: Log in to your Chartbrew account and navigate to the "Data Sources" page from the dashboard menu.
- Click on "Connect Data Source": On the Data Sources page, click on the "Connect Data Source" button to initiate the process of adding a new data source.
- Select MySQL Database: From the list of supported data source types, select "MySQL Database" as the type of data source you want to connect to Chartbrew.
- Enter Connection Details: Enter the connection details for your MySQL database, including the hostname, port number, database name, and authentication credentials (username and password).
- Test Connection: After entering the connection details, click on the "Test Connection" button to ensure that Chartbrew can successfully establish a connection to your MySQL database.
- Confirm Connection: If the connection test is successful, confirm the connection by clicking on the "Confirm" or "Save" button to proceed. If there are any errors, double-check your connection details and try again.
- Select Tables to Import: Once the connection is confirmed, you'll be presented with a list of tables available in your MySQL database. Select the tables from which you want to import data into Chartbrew.
- Define Data Models: For each selected table, define the data models by selecting the fields you want to import and specifying any data transformations or filters if needed.
- Configure Import Settings: Configure any additional import settings such as data refresh intervals, query parameters, or data sampling options to suit your requirements.
- Save and Import Data: Once you've configured all the necessary settings, click on the "Save and Import Data" button to initiate the data import process.
- Monitor Import Progress: Chartbrew will start importing data from the selected MySQL tables into your Chartbrew project. Monitor the import progress to ensure that all data is imported successfully.
- Explore Imported Data: Congratulations! You've successfully imported data from your MySQL database into Chartbrew. Take some time to explore the imported data and start creating visualizations and dashboards to analyze it.
- Seek Help if Needed: If you encounter any difficulties during the data import process, don't hesitate to consult the Chartbrew Help Center or reach out to our support team for assistance.
That's it! You're now ready to leverage the power of Chartbrew to visualize and analyze data from your MySQL databases.
Was this article helpful?