/
Working with Azure SQL database connections

Working with Azure SQL database connections

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

Kyvos supports connection to Azure SQL database connections using JDBC connectivity, enabling users to perform business analytics on semantic models designed on AzureSQLDB.

Note

In the Azure SQL Database, ensure that the fact tables having high data volume are partitioned in the table column, which is used in the Partition column option of the Kyvos dataset.

Refer to Creating a dataset section for details.

Prerequisites

Before creating an Azure SQL database connection, ensure that the following are available.

  1. Provide Kyvos and Databricks virtual network access on your Azure SQL database. For this, go to Networking and add your networks, as shown in the image below.

Creating Azure SQL database connection

To create the connection, perform the following steps.

  1. From the Toolbox, click Connections.

  2. From the Actions menu ( ⋮ ) click Add Connection.

  3. Enter the following details: 

Parameter/Field

Comments/Description

Name

Enter a unique name for the connection.

Category

Select the Warehouse option.  There may be more than one warehouse connection.

Provider

Select AZURESQLDB, and enter provider details.

Driver class

Provide the Driver class to connect to the Azure SQL DB.

URL

In the URL field, provide the Azure SQL DB URL in the format: jdbc:sqlserver://kyvosazuresql.database.windows.net:1433;database=automationtables;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;

User Name

Enter your Azure SQL Database user name. 

Password

Enter your Azure SQL Database password. 

Use as source

By default, the checkbox is selected as this connection can only be used to read data (creating datasets) on which the semantic model will be created. 

Properties

Click Properties to view or set properties.

  1. After you finish configuring the settings using the table shown below the screenshot, click the Test button from the top left to validate the connection settings.

  2. If the connection is valid, click the Save button. 

Copyright Kyvos, Inc. 2026. All rights reserved.