Configure Microsoft SQL Server as a Source

Overview

This article describes the steps needed to configure Microsoft SQL Server 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.

Detailed Steps

1. Add Source

To create a data source, navigate to Administration → Data Sources → ⊕Add Source.

Select Microsoft SQL Server.

Give the source a name, and save it.

mceclip0.png

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
  • Instance Name
  • DB Login
  • DB Password

Alternative: You may install a DvSum Edge Gateway behind your firewall. Then connect to your SQL Server 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.

mceclip4.png

Once the database is selected, you have the option of limiting the scan to some specified schema(s).

If you chose to limit the scan to certain schemas, then select the relevant schemas.

mceclip6.png

3. Save the Connection

After credentials are authenticated and Database & 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.

mceclip8.png

After that click the “Save” button.

mceclip9.png

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

mceclip11.png

 

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

mceclip12.png

 

The Scan Summary page displays all the insights of the scan. It indicates how many new tables and columns are fetched in this scan.

mceclip13.png

 

Your SQL Server 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 Microsoft SQL Server source into DvSum app.

 

 

Additional Resources

Read more about DvSum Web Service (Cloud SAWS)

Read more about DvSum Edge Gateway (On-Premises SAWS)

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk