Akkio Docs
  • Akkio Documentation
    • Akkio FAQ
  • Account and Settings
    • Team Settings
    • Organization Settings
    • Account Settings
    • Role Based Access Control
  • Demo Models
    • Demo Models
      • Lead Scoring
      • Retail Sales Forecasting
      • Predict Credit Card Fraud
      • Identify Customer Churn
  • Setting up Integrations
    • Connecting Data
    • Airtable (Beta)
    • Google Ads (Beta)
    • Google Analytics 4 (Beta)
    • Google BigQuery
    • Google BigQuery (Service Account)
    • Google Sheets
    • HubSpot (Beta)
    • MariaDB (Beta)
    • MongoDB (Beta)
    • MySQL (Beta)
    • PostgreSQL (Beta)
    • Redshift (Beta)
    • Salesforce
    • Akkio Data Chat for Slack
    • Snowflake (Username / Password) (Beta)
    • Zapier
  • Prepare your Data
    • Prepare
      • Chat Data Prep
      • Clean
      • Merge & Fuzzy Merge
      • Table View
      • Pivot View
      • Deploying Chat Data Prep
  • Explore
    • Chat Explore
    • Chart Types
  • Building a Model
    • Predict
      • Insights Report - Classification
      • Insights Report - Regression
    • Forecasting
      • Insights Report - Forecasting
    • Model Types
  • Deploying a Model
    • Deploy
      • Google BigQuery
      • Google Sheets
      • HubSpot (Beta)
      • PostgreSQL (Beta)
      • Salesforce
      • Snowflake (Beta)
      • Web App
      • Zapier
  • REPORTING AND SHARING
    • Reports
    • Dashboards
  • REST API
    • API Introduction
      • Quickstart
    • API Options
      • cURL Commands
      • Python Library
      • Node.js Library
    • API FAQ
  • Rest API (v2)
    • Documentation
Powered by GitBook
On this page
  • Overview
  • Importing Data

Was this helpful?

  1. Setting up Integrations

MySQL (Beta)

How to set up MySQL Imports

PreviousMongoDB (Beta)NextPostgreSQL (Beta)

Last updated 9 months ago

Was this helpful?

MySQL support is currently in beta. Please raise any issues you encounter via the chat bubble in the bottom-right of the site, and we'll be happy to help.


Overview

Our MySQL integration allows you to import your data; allowing you to clean, transform, and ask questions via Chat Explore.

You must allow network traffic from the public IP address 54.197.189.139 in order to allow Akkio to access your data.

Importing Data

To import data, first create a new project.

Select the MySQL button.

Click "Connect Dataset" to add a new dataset.

Enter connection details for your MySQL integration:

Select Continue, then add details for the Table name:

Make sure your security settings allow us to connect to your database. You'll need to add our IP Address, 54.197.189.139, to your security settings so that we can connect and pull your data in.

To pull in your data, input the following:

  • Hostname: The hostname of your MySQL instance (this looks like the URL).

  • Database Name: The name of the database within your MySQL instance that your table is inside. NOTE: Each database can hold multiple tables.

  • Username/Password: Credentials for the database user to authenticate. This user must have read permissions for a table to import and write permissions to deploy.

  • Port: The port we should use to connect to your database. This is generally 3306 but should be verified.

  • Table Name: The name of the table to pull from.

  • Use SSL: Specify whether the MySQL connection uses SSL encryption for security or not.

When complete, hit Continue and Akkio will then validate the connection and begin the import process.

If we're successful, you'll move forward to the data loading screen, where your data is syncing behind the scenes.

You may need to wait for a little bit for the data to import. Rest assured that we're importing data behind the scenes. Small datasets should only take a few minutes; large datasets may take longer.

Once your data is done importing, you'll see it populate onto the screen.

Now, your data is loaded into Akkio and will function normally. If this is your first time connecting data, take a look at to get started.

Prepare
Create a new project from the homepage.