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, MSSQL(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 MySQL 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: In order to add and configure a MySQL source in the DvSum DI app, first it needs to be set up locally on the machine where SAWS is running. To set up MySQL workbench locally go through this link.
Step 2: Once MySQL is set up on the machine, go to the DvSum DI app. In it 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 MySQL 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 MySQL 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, DB Login, and Password of your MySQL workbench which was set up on the machine. After entering the credentials, Authenticate the source by clicking the “Authenticate” button.
Note: SAWS and MySQL workbench should be set up on the same machine. Else Authentication will fail.
Step 3: Once the source is Authenticated, Database section will appear below the Authenticate button from where we have to select the schema that we need to scan. All the schemas' names will populate in this field which exists in the MySQL workbench which was set up locally. This database selection field is a single select field and we can only select one schema.
Step 4: After credentials are authenticated, and the Schema is selected we need to save the source. For that, scroll up to the top. From the top right corner click on the “Done” button.
After that click the “Save” button. The source will get saved successfully.
Step 5: Now we can move to Scan History Page and click the "Scan Now" button. The scan will run and a job will be created once we click on the "Scan Now" button. Once the status of the job gets Completed, our new MySQL 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 database 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.