Transactional Databases (beta)

Integrate Monte Carlo with your Transactional Databases

Summary

Integrating Monte Carlo with a database allows you to monitor your data assets through custom SQL monitors, which can be created in either the UI wizard and/or programmatically via monitors as code (API/SDK too).

UI Wizard

Custom SQL UI wizard

These monitors can be used to generate notifications (incidents) to relevant stakeholders and circuit break pipelines.

Connection steps

To integrate with a database, you will need to do the following:

  1. Enable network connectivity between the database and Monte Carlo's data collector.
    See detailed instructions here.
  2. Create a read-only service account with the appropriate permissions on your database.
    See detailed instructions in dedicated database guides for Postgres and SQL Server.
  3. Provide service account credentials to Monte Carlo.
    See detailed instructions in dedicated database guides for Postgres and SQL Server.