Allowing Xplenty access to MongoDB

Xplenty can access your MongoDB on a variety of services and deployment models. This article discusses providing Xplenty access on your MongoDB and then details creating the MongoDB connection in Xplenty.

You must provide Xplenty access to MongoDB. If it is behind a firewall:
  • Create a MongoDB user and grant it minimum permissions required for Xplenty to read or write data from the database.
  • Allow access from Xplenty's IP addresses to MongoDB's port.
To create a MongoDB connection In Xplenty
  1. Click your avatar at the top right of the window, then click Manage Connections.
  2. To create a connection, click new connection. 
  3. Choose MongoDB.
  4. In the new Mongo DB connection window, name the connection and enter the connection information:
    new_mongo.png
    • Name - name for the new connection
    • Hostname - name of the host to connect to
    • User name - database user name
    • Password - database user's password
    • Port - TCP Port to connect to. You have to allow Xplenty access to this port on the specified host in order to be able to use the connection properly
    • Database - name of database to use
    • Read Preference - Determines how the connection should route read operations to members of a replica set.
    • Authentication Database - name of the database to use for authentication. Leave empty to use default database.
    • Connect using SSL - Determines whether to connect to the database using SSL. SSL allows encryption of client/server communications for increased security.
  5. You can test the MongoDB connection by clicking test connection. Note that although the test may fail, a job may be able to use the connection because the cluster on which you execute the job may have access to the database, whereas the Xplenty web application may not.
To modify MongoDB connections in Xplenty:
  1. Click your avatar at the top right of the window, then click Manage Connections.
  2. Click a connection to modify or delete it. To exit the edit MongoDB connection window without changes, click connections at the top of the edit MongoDB connection window.

Connectivity And Security

  1. Allowing Xplenty access to data on Amazon S3
  2. Allowing Xplenty access to my Redshift cluster
  3. Allowing Xplenty access to my data on Google AdWords
  4. Allowing Xplenty access to my data on Google Analytics
  5. Allowing Xplenty access to my Google BigQuery dataset
  6. Allow Xplenty access to my Google Cloud Spanner instance
  7. Allow Xplenty access to my data on Google Cloud Storage
  8. Allowing Xplenty access to my data on Hadoop Distributed File System (HDFS)
  9. Allowing Xplenty access to my server behind a firewall
  10. Allowing Xplenty direct access to relational databases on Amazon Web Services RDS
  11. Allowing Xplenty access to MongoDB
  12. Importing Heroku Connections
  13. Allowing Xplenty access to my data on Bing Ads
  14. Allowing Xplenty access to Azure SQL Databases
  15. Allowing Xplenty access to my data on Secure File Transfer Protocol (SFTP)
  16. Allowing Xplenty access to Facebook Ads Insights data (Beta)
  17. Allow Xplenty access your data on Salesforce
  18. Allowing Xplenty access to NetSuite
  19. Allowing Xplenty access to my data on Intercom
  20. Set up a reverse SSH tunnel from Windows
  21. Allowing Xplenty access to my data on Xero (Beta)
  22. Allow Xplenty access to my data on Azure Blob Storage
  23. Allowing Xplenty access to my Snowflake account
  24. Allowing Xplenty access to my data on YouTube
  25. Allowing Xplenty access to my data on Google Sheets
  26. Allowing Xplenty access to my data on Linkedin
  27. Allowing Xplenty access to my data on Instagram
  28. Allowing Xplenty access to my data on Shopify
  29. Allowing Xplenty access to my data on Pinterest
  30. Allowing Xplenty access to my Amazon Athena instance
  31. Allowing Xplenty access to my data on Xero

Feedback and Knowledge Base