/
Working with MSSQL warehouse connection

Working with MSSQL warehouse connection

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

  1. Select WAREHOUSE as Category value.

  2. Select GENERIC as Provider value.

  3. Provide com.microsoft.sqlserver.jdbc.SQLServerDriver in the driver class field.

  4. Provide the URL, username, and password.

  5. Provide JDBC as value in Spark Read Method field.

  6. Add a new property by clicking the Properties link.

    1. Enter property’s name as kyvos.connection.isRead

    2. Enter its value as True.

  7. 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.

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

image-20240729-100334.png

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

Related content

Working with Azure Synapse warehouse connection for No-Spark
Working with Azure Synapse warehouse connection for No-Spark
More like this
Kyvos 2024.3.x - Supported environments and applications
Kyvos 2024.3.x - Supported environments and applications
Read with this
Working with MSSQL warehouse connection
Working with MSSQL warehouse connection
More like this
Creating Kyvos Resources for GCP using Script
Creating Kyvos Resources for GCP using Script
Read with this
Working with MSSQL warehouse connection
Working with MSSQL warehouse connection
More like this
Prerequisites for Kyvos Deployment on Azure
Prerequisites for Kyvos Deployment on Azure
Read with this

Copyright Kyvos, Inc. All rights reserved.