Skip to content

MySQL Data Connector

MySQL is an open source relational database management system that enables anyone to store and query their data using SQL. Follow the steps below to connect your MySQL data to your Apteoo workspace.

  1. If your database is protected by a firewall or VPN, you'll need to whitelist our IP address:
  2. From the Home Dashboard on your workspace, click on the Data tab, then click on MySQL MySQL Icon
  3. On the MySQL Connection page, type in the host, port, user, password, and database to connect to. Your credentials will be encrypted. MySQL Connection Screen
  4. On the next page, you'll see a list of tables in your database, and will be asked to select the tables you want to connect. You'll be able to see each table's schema by clicking on the link labeled View Table Columns to the right of each table's name. Select each table you want to connect to Apteo, then click Continue. MySQL Table Selection
  5. On the next screen, you'll see a progress bar indicator to show you how many tables have been loaded into Apteo MySQL Extracting Data
  6. When all your data has been loaded, all members of your workspace will receive an email and you'll be able to see it all on the resulting page MySQL Data Table

That's it, you're all set! You can now start visualizing, analyzing, and predicting your data.