Overview:

This article outlines the process of configuring Azure SQL or Azure Synapse Analytics as a data source in DvSum, enabling integration for data cataloging and profiling. The steps provided apply to both DvSum Data Insights (DI) and DvSum Data Quality (DQ), with only minor variations based on the specific platform.

Prerequisite: Enabling General Query Log for MySQL
Before proceeding, ensure that the general query log is enabled for your Azure server. This is essential for tracking data lineage and obtaining insights into usage patterns. For more information, refer to the Enabling General Query Log for Data Sources article.

You can follow the steps mentioned below to configure and authenticate a Azure SQL or Azure Synapse Analytics source:

Add Source

Navigate to Administration → Data Sources.

Click "⊕ Add Source" to begin the wizard.

Add

Select the appropriate Data Source type, name your data source, then save. Your data source has now been created, but it must still be configured.

Configure Source

The connection tab will automatically open when you save the data source. You can navigate directly to configure a source as follows:
Administration → Data Sources → Settings → Connection

Click "Edit" and configure your connection details.

Most DvSum customers connect using the DvSum web service. See the note at the end of this article for the less common case of using a DvSum Edge Gateway Web Service installed on premises.

Screenshot

Enter your connection information, then click "Authenticate".

After authenticating, the Database and Schemas fields will appear and will automatically populate. Select a database. Optionally select schemas. Then be sure to click "Done" in the upper right corner. Click "Save" to complete the process.