Configure Oracle as a Source

Overview

This article describes the steps needed to configure Oracle as a source in DvSum Data Catalog (DC). The same steps apply to configure a source in DvSum Data Quality (DQ) with only a slight variation.

Prerequisites

Oracle configuration

User: Create a user to be used in DvSum, or identify an existing user.

Table permissions: Grant read-only access to the user for schemas and tables that you would like to catalog and profile.

System table permissions: Grant read-only access to the user for the following system tables:

  • V$SQL
  • DBA_USERS
  • ALL_USERS
  • ALL_OBJECTS
  • ALL_TABLES
  • ALL_SYNONYMS
  • ALL_TAB_COMMENTS
  • ALL_EXTERNAL_TABLES
  • ALL_TAB_COLS
  • ALL_COL_COMMENTS
  • ALL_CONSTRAINTS
  • ALL_CONS_COLUMNS

In order to grant access the below statement can be used:

GRANT SELECT ON [TABLE_NAME] TO [USER]

Oracle GRANT documentation

Detailed Steps

DvSum configuration

1. Add Source

To create a data source, navigate to Administration → Data Sources → ⊕Add Source.

Select Oracle.

Give the source a name, and save it.

Screenshot 2023-11-04 at 3.41.02 PM.png

 

2. Configure Connection

Once the source is saved, you will be redirected to the connection settings detail page.

Most common: Connect Using DvSum Web Service

Whitelist the DvSum application by IP address as indicated. Then enter the required connection information:

  • Host
  • Port
  • SID or Service Name
  • DB Login
  • DB Password

Alternative: You may install a DvSum Edge Gateway behind your firewall. Then connect to your Oracle instance using this web service installed on premises. Read more details in DvSum Web Service vs On-Premises Edge Gateway.

After entering the credentials, Authenticate the source.

Once the source is Authenticated, the Database section will appear.

Select the schemas which you want to catalog.

mceclip4.png

 

3. Save the Connection

After credentials are authenticated and Schema(s) are selected, then you must save the source. For that, scroll up to the top. From the top right corner click the “Done” button.

mceclip5.png

 

 

After that click “Save” button. 

 

mceclip6.png

 

4. Scan the data source

Navigate to Scan History Page and click the "Scan Now" button. When the scan completes, the status will change to "Completed".

mceclip8.png

 

After the scan completion, click on Scan Name and it will open the Scan Summary page of this scan.

mceclip3.png

 

The Scan Summary page displays all the insights of the scan. It indicates how many new tables and columns are fetched in this scan.

mceclip4.png

 

Your Oracle connection is now fully configured and functional.

 

Browsing the Data Catalog

Next you can analyze the Tables and Columns discovered in the scan. Navigate to "Data Dictionary" on the left sidebar. The table listing view will appear. Click on the "Recently Refreshed" tab. In this tab you see the tables discovered in the recent scan. Click on table names to see more details.

mceclip5.png


Watch this quick video tutorial of how to add and configure an Oracle source into DvSum app.

Additional Resources

Read more about DvSum Web Service (Cloud SAWS)

Read more about DvSum Edge Gateway (On-Premises SAWS)

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk