Configure MySQL as a Source

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.

mceclip0.png
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 1In 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.

mceclip0.png

mceclip1.png

 

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, enable the checkbox of On-premise Web Service and then 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. 

NoteSAWS and MySQL workbench should be set up on the same machine. Else Authentication will fail.

before_gateway.pngafter_gateway.png

authenticate.png

Note: By Default the SAWS type will be cloud. For more information regarding Cloud SAWS, click here

 

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. 

mceclip3.png

 

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.

mceclip4.png

 

After that click the “Save” button. The source will get saved successfully.

mceclip5.png

 

mysql.png

 

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. 

mceclip7.png

 

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

mceclip8.png

 

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.

mceclip9.png

 

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.

mceclip10.png

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk