Oracle

Oracle Database is a relational database management system (RDBMS) and uses a structured query language called SQL (Structured Query Language) to manage and manipulate data. Data reliability is provided by Acceldata Data Observability Cloud (ADOC) for data saved in your Oracle data source.

To add Oracle as a data source in ADOC, you must first create or use an existing Data plane. Once Oracle has been added as a data source, you may view the specifics of your assets in the Oracle database under ADOC's Data Reliability tab.

Prerequisites

Before adding Oracle as a data source in ADOC, ensure the following:

1. You have an existing Data Plane or have set one up.
2. The Oracle user has the required permissions to allow Cadence job execution. The DBA must run the following commands before proceeding

Replace <ORACLE_USER> with the username provided while configuring the Oracle Data Source. If unsure, contact your Oracle database administrator (DBA) for assistance.

3. You have the Oracle connection details such as JDBC URL, username, password.

Add as Data Source

To add Oracle as a Data source follow the steps:

1. Navigate and select the Register icon from the left pane.
2. In the Data Source tab click on the Add Data Source button.

Note Before proceeding, ensure that the Oracle database user you specify during configuration has the necessary permissions for Cadence jobs. If not granted, request the Oracle database administrator (DBA) to assign the required permissions. Also see, Prerequisites.

3. Choose the Oracle Data Source. The Oracle Data Source Details page is displayed.

4. Enter the required Oracle connection details:
   1. Enter a name for the data source in the Data Source name field.
   2. (Optional) Enter a description for the Data Source in the Description field.
   3. Enable the Data Reliability capability by switching on the toggle switch.
   4. Select a Data Plane from the Select Dataplane drop-down menu.

To create a new Data Plane, click Setup Dataplane. To learn more about Data Plane setup, see Installing Data Plane document.

5. Click Next. The Oracle Connection Details page is displayed.

6. Steps to be followed for the Environment Type:
   1. Standalone
      1. Enter your Oracle URL in the JDBC URL.
      2. Enter your Oracle username in the JDBC Username field.
      3. Enter your Oracle password in the JDBC Password field.

b. Oracle Cloud Autonomous Database

i. Enter your Oracle URL in the JDBC URL.

ii. Enter your Oracle username in the JDBC Username field.

iii. Enter your Oracle password in the JDBC Password field.

iv. Enter your Oracle database connections credential files.

7. Click Test Connection. If your credentials are valid, you receive a Connected message. If you get an error message, validate the Oracle credentials you entered.
8. Click Next. The Set Up Observability page is displayed.

9. Provide the Database Name of the Oracle databases to be monitored by ADOC. To add multiple databases, click +.
10. Enable Crawler Execution Schedule: Turn on this toggle switch to select a time tag and time zone to schedule the execution of crawlers for Data Reliability.
11. Click Submit.

Oracle is now added as a Data Source. You can choose to monitor your Oracle account now or later.

A new Oracle card is added to the data sources page. This card displays the overall cost for the current month, crawler status and other Oracle data source statistics.

You can navigate to the Managing Data Sources page to view the options available after adding the Data Source.

Troubleshooting

Issue: Cadence Jobs Failing with ORA-00942 (Table or View Does Not Exist)

Possible Cause: The Oracle user does not have the necessary permissions to access metadata tables.

Solution: Ensure the following permissions are granted to the Oracle user used during Data Source configuration:

Replace <ORACLE_USER> with the actual username used in the Oracle Data Source configuration.