Working with MSSQL warehouse connection

To create MSSQL Warehouse connection for reading data, perform the following steps.

Select WAREHOUSE as Category value.
Select GENERIC as Provider value.
Provide com.microsoft.sqlserver.jdbc.SQLServerDriver in the driver class field.
Provide the URL, username, and password.
Provide JDBC as value in Spark Read Method field.
Add a new property by clicking the Properties link.
1. Enter property’s name as kyvos.connection.isRead
2. Enter its value as True.
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.
If the connection is valid, click the Save button.

Connection Details in Kyvos for Sanity Suite

To create MSSQL Warehouse connection for sanity suite, perform the following steps.

Parameter	Description

Parameter	Description
Name	Enter SanityConnection as a name.
Category	Select the Warehouse option.
Provider	Select the Generic option.
Driver	Enter the Driver class as com.microsoft.sqlserver.jdbc.SQLServerDriver
URL	Enter URL as jdbc:sqlserver://sqlServerIp:port;databaseName=yourDatabaseName;encrypt=true;trustServerCertificate=true
Username	Enter your SQL Server username.
Password	Enter your SQL Server password.
Spark ReadMethod	Select JDBC
Schema Enabled	Select this checkbox to enable schema.
Properties	Click Properties to view or set properties. You need to add a property to make the connection visible Name: kyvos.connection.isRead Value: true