...
Select WAREHOUSE as Category value.
Select GENERIC as Provider value.Provide com.microsoft.sqlserver.jdbc.SQLServerDriver in the driver class fieldthe MSSQL Provider from the list.
The Driver Class field is displayed by default.
Provide the URL, username, and password.
Provide JDBC as value in Spark Read Method field.
Add a new property by clicking the Properties link.
Enter property’s name as kyvos.connection.isRead
Enter its value as TrueAfter 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.
.
...
Parameter | Description | ||
|---|---|---|---|
Name | Enter SanityConnection as a name. | ||
Category | Select the Warehouse option. | ||
Provider | Select the Generic MSSQL 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. isReadValue: true |