Work with MongoDB data
Once you've imported your MongoDB data into the DoiT platform, you can start analyzing and monitoring your MongoDB cost and usage. MongoDB data is tracked and reported on an hourly basis.
Mongo Atlas API
The DoiT console interacts with the MongoDB Atlas APIs.
| API | Description |
|---|---|
| Authentication | Access token for MongoDB Atlas APIs. |
| Return all organizations | Returns all organizations to which the requesting Service Account or API Key has access. |
| Returns all invoices for one organization | Returns all invoices that MongoDB issued to the specified organization. This list includes all invoices regardless of invoice status. |
| Return one invoice for one organization | Returns one invoice that MongoDB issued to the specified organization. |
The required permissions are granted when you create a service account for the DoiT connector.
MongoDB data in Cloud Analytics
You can get MongoDB data through dimensions and metrics. See below for the mapping between the DoiT and MongoDB terminologies.
Basic metrics
DoiT term | MongoDB term | Description |
|---|---|---|
cost | cost | The billing data for MongoDB Atlas organizations using MongoDB Atlas Cost Explorer APIs. |
usage | usage | The usage data for MongoDB Atlas organizations using MongoDB Atlas Cost Explorer APIs. |
Standard labels
| DoiT Term | MongoDB Term | Description |
|---|---|---|
| Billing Account Name | organization.id | Unique identifier that identifies the MongoDB Atlas organization. |
| Project Account ID | line_item.groupId |
|
| Project Account Name | line_item.groupName | The name of the MongodDB project. |
| SKU Description | sku_description | Description of a MongoDB Atlas resource, for example, M1 - AWS- US_EAST_1 |
| SKU ID | sku_id | Unique identifier of a MongoDB Atlas resource. |
| Usage Date Time | line_item.startDate | Timestamp of when usage occurred. |
| Usage Start Time | lineItem.startDate | Start time of the billing period for the usage. |
| Usage End Time | line_item.endDate | End time of the billing period for the usage. |
| Usage Amount in pricing units | line_item.quantity | The pricing unit, depending on the MongoDB service you are using. |
| Cost | line_item.totalPriceCents / 100 | The final cost amount in billing currency (after discounts/credits), in dollars. |
| Usage | line_item.startDate | The cost depending on the MongoDB category, for example, compute, storage, data transfer, and so on. |
| USD | currency_code | ISO currency code for the costs. |
| Usage Amount | line_item.quantity | Quantity of resource usage, for example, hours, or GB. |
| Unit | line_item.unit | Unit of measure for the usage amount. |
| Export Time | line_item.startDate | The duration of the time it takes to complete a data export from a MongoDB database. |
| Report Cost | line_item.totalPriceCents / 100 | The costs associated with running MongoDB reports. |
| Report Usage | line_item.quantity | The amount of compute, storage, and data transfer resources consumed when running reports. |
| Resource ID | line_item.clusterName | A unique identifier for a MongoDB resource. |
System labels
The MongoDB integration has a mongodb/environment system label that you can use in Cloud Analytics. The mongodb/environment is the name of your MongoDB environment, for example, development, testing, staging, and so on.