MongoDB

Phiona can connect to your MongoDB collections, import tables from your collections, and write back transformed tables into your collection. To set up your MongoDB connection, click on Add New Data Source in your Project page, and then click the MongoDB button.

Click on the MongoDB button to connect your clusters

Click on the Create a New Connection link at the top right of the menu, and you'll be prompted to fill in a few details about your MongoDB connection.

Configure your MongoDB connection

As part of the connection set up, you'll need to enter a name for your connection, the connection string from Mongo, and the specific database collection that you would like to connect to.

To find your MongoDB connection string, you'll need to go into your MongoDB Clusters screen, and select the "Connect" button under the cluster that you would like to connect to.

Connect in MongoDB

A screen will pop up. Select the Connect via Application option highlighted below.

Select "Connect your application"

Next, you'll see a screen where there's a dropdown on driver / version and a connection string.

Select the Python Driver and copy your string

Select the Python Version 3.1.1 or later option, and then copy the connection string from the MongoDB screen into Phiona. To find your database name, go back to your main clusters screen, and select "Collections" to see your collection databases.

Select Collections to find your database name

Remember the database name that you would like to import, and enter the database name as a replacement to <dbname> into the connection string in Phiona. If you have a read/write password for MongoDB, then replace those values into the connection strings as well. After you have all of your information entered into Phiona, save the connection.

To connect to your MongoDB collections, you must enable connections from any IP address into your database (for security, it will still require knowing your username, password, and specific database name). Many Phiona users create separate User IDs for the Phiona application, rather than storing their admin credentials in multiple places- we would suggest this as a security best practice.

If you require an extra measure of security, you can set up VPC Peering for your MongoDB connections, the instructions are located here: https://docs.atlas.mongodb.com/security-vpc-peering. Please reach out to us at [e-mail] for additional detail.