RDBMS DATA SOURCES
An RDBMS is a type of database management system (DBMS) that stores data in a row-based table structure that connects related data elements. In DvSum we have different types of RDBMS data sources including Oracle, Snowflake, My SQL, SQL Server, Azure SQL, and Azure Synapse.
To create any data source, go to the Data Sources tab and click on the “Add Source” button. Then specifically any source can be selected to add.
Data Sources tab > Add Source
Note: Before configuring any RDBMS source, SAWS should be installed and correctly configured in order to authenticate the sources successfully. If you want to know how to configure a SAWS, click here.
Adding an Oracle source in DvSum:
Watch this quick video tutorial of how to add and configure an Oracle source into DvSum app.
However, you can also follow the steps mentioned below to configure and authenticate an Oracle source:
Step 1: Go to the Data Sources tab and click on Add Source button. A modal will open which will ask us to choose a data source that is to be added. Select Oracle source, provide some source name, and Save it.
Step 2: Once the source is saved, we will be redirected to the connection settings detail page of this new Oracle source. There we need to add Credentials, Host, and Basic Information. First, select the SAWS which is set up and is currently up and running Then enter the correct Host, Port, Database SID, DB Login, and Password. After entering the credentials, Authenticate the source by clicking the “Authenticate” button.
Step 3: After successful Authentication, Database section will appear underneath the Authenticate button. In this section, all the schemas will be listed in “Available Schemas” tab. We can select schema(s) to be scanned and move them to “Selected Schemas” tab.
Step 4: After credentials are authenticated and schema is selected we need to save the source. For that, scroll up to the top. From the top right corner click on “Done” button.
After that click “Save” button. The source will get saved successfully.
Now we can move to Scan History Page and click the "Scan Now" button. A job will be created and once its status gets Completed, our new Oracle source's scan will be completed successfully.
After the scan completion, click on Scan Name and it will open the Scan Summary page of this scan.
On the Scan Summary page, it will show all the insights of the scan i.e how many new tables and columns are fetched in this scan from the schema(s) that we selected earlier.
In order to have more insights of the tables' details, click on "Data Dictionary" from the sidebar. Table listing view will appear. Click on "Recently Refreshed" tab. In this tab, we will see all the tables that we have got in the recent scan. Click on table names to get to know more details of the table from the detail page.