# MariaDB (Beta)

*MariaDB 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 MariaDB integration allows you to import your data; allowing you to clean, transform, and ask questions via Chat Explore.

{% hint style="danger" %}
You must allow network traffic from the public IP address `54.197.189.139` in order to allow Akkio to access your data.
{% endhint %}

### Importing Data

To import data, first create a new project.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FyAvYjZJdVfNys2RGIRzF%2Fimage%20(40).webp?alt=media&#x26;token=f7e1a7cc-798f-4f9c-b8b4-980698287332" alt=""><figcaption><p>Create a new project from the homepage.</p></figcaption></figure>

Select the MariaDB button.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2Fwi3TBbBso7jvh7USKtBQ%2Fimage%20(49).webp?alt=media&#x26;token=4d34010f-75a0-4132-89a4-6cd6f63c288b" alt="" width="446"><figcaption></figcaption></figure>

Click "Connect Dataset" to add a new dataset.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FaMoKobilXXn5zX9xTdeK%2Fimage.png?alt=media&#x26;token=6acc6e13-a3cd-4503-8033-9fb3092a2de9" alt=""><figcaption></figcaption></figure>

Enter a connection name:

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FDtbXJ72do7Vf1gGjacJz%2Fimage%20(50).webp?alt=media&#x26;token=888f07b1-37c2-4881-9cac-700a1919180b" alt="" width="520"><figcaption></figcaption></figure>

Enter connection details for your MariaDB integration:

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FBaIs9DjWtHEZBkU79riH%2Fimage%20(51).webp?alt=media&#x26;token=da5f55d5-06ce-41b2-bfb6-9e729194f317" alt=""><figcaption></figcaption></figure>

Select Continue, then add details for the Table name:

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FmffpUG7vPE1W83zdrNso%2Fimage%20(52).webp?alt=media&#x26;token=691a5225-6200-4961-8632-33896abd647e" alt="" width="520"><figcaption></figcaption></figure>

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

To pull in your data, input the following:

* **Hostname:** The hostname of your MariaDB instance (this looks like the URL).
* **Database Name:** The name of the database within your MariaDB 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 MariaDB connection uses SSL encryption for security or not.

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

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FMKha1ABHu1wNjPmE0TO4%2FScreenshot%202024-02-13%20at%2011.08.10%E2%80%AFAM.png?alt=media&#x26;token=f29b683b-19f9-4850-ba35-bf96cbddc13e" alt="" width="239"><figcaption></figcaption></figure>

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

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FqH9fkPU3TonkjoUKOyt0%2Fimage.png?alt=media&#x26;token=75013bf2-6393-4f61-a165-5136a8803c27" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FT2QiQwdkQMllWZVvNLqc%2Fimage.png?alt=media&#x26;token=dc40fca7-9290-44df-b271-5a7e7bd2543a" alt=""><figcaption></figcaption></figure>

Now, your data is loaded into Akkio and will function normally. If this is your first time connecting data, take a look at [Prepare](https://docs.akkio.com/akkio-docs/prepare-your-data/prepare) to get started.
