Skip to main content

SQL Server

This section explains how to create and test an SQL Server data source in DataDios.

Steps to Create and Test an SQL Server Data Source​

Step 1: Create a Data Source​

  1. Navigate to the DataSources tab in DataDios
  2. Click + CREATE DS
  3. From the list of available data source types, select SQL Server
    • select the SQLServer from list Datasources Tab

Step 2: Fill Connection Details​

In the Connection Details form, provide the required parameters:

  • Group: Optional grouping for data sources

  • Host: SQL Server host or IP address

  • Port: SQL Server port (default: 1433)

  • Service Type: Select on-prem or cloud

  • Username: SQL Server login username

  • Password: SQL Server login password

  • Database Name: Name of the database to connect to

  • Schema: Enter the schema you want to connect to

  • Object Types: Choose whether to fetch tables, views, or both

  • Version: Specify the SQL Server version if supported; otherwise, leave blank

  • Schedule Sync: Required for metadata timeline synchronization (Metadata Sync)

  • Secret Name: Optional, if your database password is stored in a key store such as AWS or Azure

  • JSON Structure

        {
           "group": "",
           "host": "198.168.1.1",
           "port": "1433",
           "service_type": "",
           "username": "sql-admin",
           "database": "QuickStart",
           "schema": "diff_test",
           "object_types": "",
           "password": "Admin@123"
        }

    SQL Server Connection Form

Step 3: Test Connection​

  1. After entering the details, click Test Connection

  2. If the connection is valid, the system will confirm the connection status

    Validate Connection

Step 4: Save Data Source​

  1. If the test is successful, click Create to save the data source
  2. You will be redirected to the Datasource Listing Page, where your SQL Server data source will appear

Step 5: Explore Data Source Items​

  1. Click on the SQL Server data source to view all items, including tables and views

    List Items SQL Server

  2. To view metadata about any item:

    • Click the item name
    • Click the three stacked lines icon to open the Object Metadata pop-up

    Object Metadata 3. You can also explore additional features in the Metadata Explorer:

    • Object Data

      • View the actual data present in the selected resource (e.g., table rows or file details)

    • Graphs

      • Visualize dependencies and relationships across schemas
      • See how the item is connected to databases or other schema objects

    • Data Quality Rules