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]
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.
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.
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.
After that click “Save” button.
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".
After the scan completion, click on Scan Name (SCN-000286 in the above example) and it will open the Scan Summary page of this scan.
The Scan Summary page displays all the insights of the scan. It indicates how many new tables and columns are fetched in this scan.
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.
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 vs On-Premises Gateway
Read more about Gateway Installation
0 Comments