MongoDB Integration
In this article, we’ll integrate a MongoDB data source with Y42.
Overview
Authentication
Your database credentials allow you to log into your database, either locally or remotely. A credential is a record that contains the authentication information. This information is used internally by server hosting the SQL database. The credentials entail the host address, the IP hosting the server/database, the port number, the default port on MongoDB is 27017, the user and the password.
You may also use SSH tunneling or use a Y42 IP for whitelisting.
SSH tunneling is a method of transporting arbitrary networking data over an encrypted SSH connection. The SSH connection is used by the application to connect to the application server. With tunneling enabled, the application contacts to a port on the local host that the SSH client listens on. The SSH client then forwards the application over its encrypted tunnel to the server. See the configuration example page for detailed configuration instructions. The SSH command line options and SSH server configuration file pages may also be helpful.
Meanwhile, whitelisting means taking manual steps to ensure that a certain IP address isn't blocked from accessing your application by some automated security process. Whitelisting IP addresses enables you to control who can (or cannot) access your database. You can add an IP to Whitelist on the security configurations of your database.
Import Settings
This integration has no import settings.
Schema
There is no predefined schema for this integration. The integration will dynamically load the tables & columns which are defined within your specific system.
Updating your data
You have the option of scheduling Full imports or Incremental Imports by the month, weeks, days, and even by the hour. With the incremental import you will only add the new rows to that table, while a full import will actually re-import the entire table completely.
Incremental imports significantly increase the import speed, we import your table incrementally based on the last imported state e.g. id - If the table does not have a state, a full import will be triggered - This is done automatically.
We recommend therefore to schedule an incremental import regularly, but also schedule a full import with a certain frequency -- this is because only the full import will guarantee that old rows that have been updated on the data source will also get updated on your Y42 integration destination.
MongoDB Setup Guide:
Note: In order to connect MongoDB with Y42, you will need to have a MongoDB Account.
- On Integrate, click on "Add..." to search for MongoDB and select it.
- Name your integration
- Authorize access:
You can authorize a MongoDB integration in two ways:
- Add in your Connection URL, e.g. http://username:password@Y42-d-imzvl.mongodb.net/test?retryWrites=true&w=majority
(here, you can find more information about Connection URL)
- Click Connect, and you are good to go to start importing your tables.
- Select the tables you need and click import. You can start accessing the tables once the status is “Ready”.
Note: You can always import and reimport other tables as well, or delete them.
You can also connect a MongoDB integration without the need of entering your URL:
- Enter your Database.
- Your Host & your Port.
- Your User name & your Password.
Note: You can choose to either connect now or to connect by using a SSH tunnel.
- You’ll need to enter your SSH Host, your SSH Port & User.
- Finally, add in your Private Key File as well.
- Click Connect, and you are good to go to start importing your tables.
- Select the tables you need and click import. You can start accessing the tables once the status is “Ready”.
Note: You can always import and reimport other tables as well, or delete them.