MongoDB (Beta)

How to set up MongoDB Imports

MongoDB 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 MongoDB 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 IP address 52.44.27.22 in order to allow Akkio to access your data.

Importing Data

To import data, first create a new project.

Select the MongoDB button.

Click "Connect Dataset" to add a new dataset.

Enter connection details for your database.

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 MongoDB instance (this looks like the URL).

  • Database The name of the database within your MongoDB instance that your table is inside.

  • 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.

When complete, hit continue.

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

This will run a connection test; if successful, you'll see the data loading screen. Data will take some time to import based on table size.

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 Prepare to get started.

Last updated