Configure MSSQL 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, 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 MSSQL(SQL Server) 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 1Go 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 MSSQL source, provide some source name, and Save it.

mceclip0.png

 

mceclip2.png

 

Step 2: Once the source is saved, we will be redirected to the connection settings detail page of this new MSSQL 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, Instance Name, DB Login, and Password. After entering the credentials, Authenticate the source by clicking the “Authenticate” button. 

mceclip15.png

 

Step 3: Once the source is Authenticated, Database section will appear below the Authenticate button from where we have to select the database that we need to scan. This database selection field is a single select field and we can only select one database. 

mceclip4.png

 

Once the database is selected, we now have an option of limiting the scan to some specific schema(s) or we have to scan all of them. For MSSQL source we would have a Schema field as well which will contain a checkbox, If we want to scan all the schemas then we shouldn't check this checkbox and proceed with saving and scanning the source. But if we want to limit our scan to some specific schemas then check this checkbox.

 

mceclip5.png

 

Once it is checked then the list of available schemas will be displayed. User can select single or multiple schemas from the Available Schemas list and move them to the Selected Schemas tab on the right. 

 

mceclip6.png

 

mceclip7.png

 

Step 4: After credentials are authenticated, and Database & Schema(s) are selected we need to save the source. For that, scroll up to the top. From the top right corner click on the “Done” button.

mceclip8.png

 

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

mceclip9.png

 

mceclip16.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 MSSQL source's scan will be completed successfully. 

mceclip11.png

 

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

mceclip12.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 schemas we selected earlier.

mceclip13.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.

mceclip14.png

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk