MongoDB Integration

Guide for Resmo MongoDB integration

Resmo seamlessly integrates with MongoDB, providing the capability to collect directory assets like users, schemas, and tables, query Mongo users and assets, and set up custom rules and run custom SQL queries to enhance asset visibility, ensuring a safe and compliant MongoDB environment.

What does Resmo offer to Mongo users?

• Collect your directory assets like users, schemas, and tables from your Mongo database.

• Ability to query your Mongo users, schemas, tables, and much more.

• Set up custom rules and run custom SQL queries to improve asset visibility.

How does the integration work?

Resmo Mongo Integration collects resources by using our database agent. After you create and integrate and set the configurations as specified in the How to Install section, the database agent starts to operate. Once triggered, it sends requests to our servers, pulling resources inside the database.

Then, we process them on the server. You can use the database agent as a binary or docker image, depending on the installation path you choose. Resmo performs the resource validation with a unique IngestKey. Note: An IngestKey is different for each integration.

Available resources:

MongoDBResource Directory

Integration Walkthrough

1. Login to your Resmo account and navigate to the Integrations page. Then, find and click MongoDB.

2. Click the Add Integration button from the bottom right corner of the opening modal.

3. Copy and paste your MongoDB ingest key (Ingest Key is used as a secret for authentication).

4. Hit the Create button.

5. Go to Resmo-Database-Agent.

6. Click on "tags".

7. If you want to binary version, click on the desired OS version of the Resmo Database Agent.

8. After downloading, you can run the database agent by providing the config values.

9. Config list:

   • IngestKey: Ingest key of your integration. (Required)

   • DSN: Database connection URL (Required). We expect the URL to follow a specific format starting with "mongodb://...".

   • Schedule: Schedule for running queries(Optional)

   • Timeout: Timeout duration for database connections, ingesting etc. (Optional, 10 seconds default)

   • DbIdentifier: Database identifier for related Resmo resources.

10. You can run database runner for the binary version with commands:

    • `./resmo-database-agent -ingestKey="d1f947fa-f585-11ed-b67e-0242ac120002" -dsn="mongodb://resmo:resmo@localhost:27017" -schedule="10m" -timeout="10s" -dbIdentifier="mongo-prod"` or:

    • `INGEST_KEY="d1f947fa-f585-11ed-b67e-0242ac120002" DSN="mongodb://resmo:resmo@localhost:27017" ./resmo-database-agent`

11. Or you can use the docker version via command:

    • `docker pull ghcr.io/resmoio/resmo-database-agent:latest`

    • `docker run ghcr.io/resmoio/resmo-database-agent -ingestKey="d1f947fa-f585-11ed-b67e-0242ac120002" -dsn="mongodb://resmo:resmo@localhost:27017" -schedule="10m" -timeout="10s" -dbIdentifier="mongo-prod"` or:

      • `docker run -e DSN="mongodb://resmo:resmo@localhost:27017" -e INGEST_KEY="d1f947fa-f585-11ed-b67e-0242ac120002" /resmo-database-agent`

12. You are ready! Now you can start querying your Mongo database resources!

How to uninstall

1. Go to your Integrations page on Resmo and click on MongoDB.

2. Navigate to the Connected Integrations tab on the opening modal.

3. Select the MongoDB account you want to remove or disable. Click the Disable/Delete button from the top right of the modal.

Note that account removal cannot be undone; you would need to integrate again. Instead, you can choose to disable an integration until you enable it back.