Integrating Monte Carlo with Oracle 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.
To connect Monte Carlo to a Oracle database, follow these steps:
- Enable network connectivity between the database and Monte Carlo's data collector.
- Create a read-only service account with the appropriate permissions on your database.
- Provide service account credentials to Monte Carlo (requires Using the CLI).
Follow the Network Connectivity guide to IP Allowlist or VPC peer to provide access to Oracle.
To create a service account, you will need admin credentials to your Oracle database.
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';
- Please follow this guide to install and configure the CLI.
- Please use the command
montecarlo integrations add-oracleto connect. For reference, see help here.
montecarlo integrations add-oracle \ --name artemis-dev \ --host example.cluster.us-east-1.rds.amazonaws.com \ --database ORCL \ # this is the SITE name in Oracle --user montecarlo \ --password -1
Below are the supported monitors for the Oracle Integration today. Please reach out to your Monte Carlo representative if you have requirements for additional Monitors.
|Automated Anomaly Detection||Freshness|
|Automated Anomaly Detection||Volume|
|Automated Monitoring||Schema Changes|
|Opt-in Monitor||SQL Rule|
|Opt-in Monitor||Comparison Rule|
|Opt-in Monitor||Field Quality Rule|
|Opt-in Monitor||Freshness Rule|
|Opt-in Monitor||Volume Rule|
|Opt-in Monitor||Field Health Monitor|
|Opt-in Monitor||Dimension Tracking|
|Opt-in Monitor||JSON Schema Changes|
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 the AWS cloud (e.g. AWS hosted, site-to-site VPN with AWS, publicly accessible, etc). Please see the networking docs for more detail.
Updated 1 day ago