What is Oracle DB?

Oracle DB is a high-performance, scalable, and secure relational database management system designed for enterprise applications. It provides advanced features such as robust data security, comprehensive backup and recovery options, and powerful analytics capabilities. Organizations choose Oracle DB for its ability to handle large volumes of data, support complex transactions, and ensure high availability and reliability.

Why Connect Oracle DB to Monte Carlo?

Integrating Monte Carlo with Oracle DB 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). These monitors can be used to generate notifications (incidents) to relevant stakeholders and circuit break pipelines.

After connecting Oracle here is what you can expect to see:

Volume:

Our volume monitors are active by default. By collecting metadata on your tables, Monte Carlo's machine learning algorithm can set automatic thresholds to alert when a table has gone too long without a change in size or when an abnormal amount of rows are added or deleted.

A user can choose to set the thresholds if they do not want to use the ones calculated by our machine learning algorithm, this is done by clicking the Edit threshold button.

Monitor & Lineage Support

Below are the monitors & lineage support for the Oracle Integration today. Please reach out to your Monte Carlo representative if you have requirements for additional monitors.

Connecting to Oracle DB

Now that we know the value connecting Oracle DB to Monte Carlo can bring, here are the necessary steps to set up the integration.

📘

Prerequisites

To create a service account, you will need admin credentials to your Oracle database.

This guide explains how to create a read-only service account for Monte Carlo in your Oracle DB.

To review all steps necessary to integrate your database with Monte Carlo, please see here.

Create a read-only service account

Please run the SQL snippet below on your Oracle database to create a read-only service account for Monte Carlo

CREATE USER montecarlo IDENTIFIED BY '<PASSWORD>';
GRANT CREATE SESSION to montecarlo;

/* 
Grant access to all tables and views. Repeat for all relevant tables (or schemas).
Select permissions are necessary to create assets and custom SQL monitors. 
*/
GRANT SELECT ON ANY TABLE TO montecarlo;
-- or
GRANT SELECT ON <SCHEMA>.<TABLE> TO montecarlo;
-- ... repeating for each table.
-- or, only available in Oracle 23c+:
-- GRANT SELECT ON ANY TABLE ON SCHEMA <schema> TO 'montecarlo';

FAQs

What is the minimum supported version?

Monte Carlo supports Oracle Database 12.1 and newer.

Are cloud variants of Oracle like AWS RDS supported?

Yes, AWS RDS for Oracle is supported.

What hosting solutions are supported?

This integration supports any instance that is reachable from one of our hosting options. Please see the networking docs for more detail.