Working with MSSQL warehouse connection
This section details how to configure and use an MSSQL warehouse connection in Kyvos to access Microsoft SQL Server data for creating datasets and building semantic models.
Important
You must create SQL-based Datasets. The table listing is not supported on the MSSQL connection.
To create MSSQL Warehouse connection for reading data, perform the following steps.
Select WAREHOUSE as the Category value.
Select the MSSQL Provider from the list.
The Driver Class field is displayed by default.
Provide the URL, username, and password.
After you finish configuring the settings using the table shown in the screenshot below, click the Test button in the top left to validate the connection settings.
If the connection is valid, click the Save button.
