The MongoDB destination combines the analytical power of your data warehouse with the low-latency performance of a transactional database. It's been battle-tested with syncs up to hundreds of millions of rows.
You need to allowlist Hightouch's IP addresses to let our systems contact your MongoDB instance. Reference our networking docs to determine which IPs you need to allowlist.
When creating a MongoDB destination, you can either enter the Host, Port, Database, User, and Password, or you can provide the full URI connection string. For more information, go to the official connection guide.
Enter the following required fields into Hightouch:
Host: The hostname or IP address of your MongoDB server. For help finding this, go to the official connection guide.
Port: The port number of your MongoDB server. The default port number is 27017, but yours may be different. You don't need to specify the port if you are using SRV protocol.
Database: The name of the your MongoDB database.
Username: This can be your personal MongoDB login or a dedicated user for Hightouch.
Password: This is the password for the user specified above.
Is the host name a seedlist record?: To use SRV protocol (Hightouch defaults to standard), you must toggle this setting. If you are using MongoDB Atlas and the connection string begins with protocol mongodb+srv, toggle this setting to connect.
Hightouch requires choosing one column to define how to match data in your source to documents in MongoDB. It's usually best to use the _id field in MongoDB. This field is automatically generated by MongoDB if not provided, but you can choose any other field. Be aware that you might need an index on that field to speed up the sync.
Create a user in MongoDB specifically for Hightouch and only allow that user to access the collections you want Hightouch to access. Don't use the 'root' user.
Hightouch provides complete visibility into the API calls made during each of your sync runs. We recommend reading our article on debugging tips and tricks to learn more.