Discover an Azure SQL Server database

Discover an Azure SQL Server database

To discover an Azure SQL Server database with the Discovery Companion, please first:

  • Download and install the ODBC driver for SQL Server from here to be able to use encryption with the Discovery Companion application
  • Prepare the source YAML file with:
    • The specifications to access the source system
    • The specifications for the output file

 

Here is an example:

  • An Azure Microsoft SQL Server database named blackforestmarkets
  • A local output folder for the Discovery JSON file is named outputs. The complete path is:
    ./outputs/azure_mssql_discovery_output.json
source:
  type: mssql
  config:
    # Coordinates
  host_port: training-demo-sql-server.database.windows.net
    database: blackforestmarkets
    schema_pattern: {'allow': ['Sales.*'], 'deny': [], 'ignoreCase': True}
    # Credentials
  username: training
  password: training

    use_odbc: "True"
    uri_args:
      driver: "ODBC Driver 18 for SQL Server"
      Encrypt: "yes"
      TrustServerCertificate: "Yes"
      ssl: "True"
sink:
  type: file
  config:
    filename: ./outputs/azure_mssql_discovery_output.json

The output folder in your source YAML file should exist.

You can download this YAML file example here or create a .yaml file with the previous example and then adapt it:

  • The host_port (training-demo-sql-server.database.windows.net in the example)
  • The database name (blackforestmarkets in the example)
  • The schema_pattern (Sales in the example)
  • The username (training in the example)
  • The password (training in the example)
  • The output path

Then, you can use it in the Discovery Companion.

 

All possible configurations are described on the DataHub official website.