...
The following table lists the supported data type mappings.
Spark Type | SQL Type |
BIGINT | SQL_BIGINT |
CHAR | SQL_CHAR |
DATE | SQL_TYPE_DATE |
DOUBLE | SQL_DOUBLE |
INT | SQL_INTEGER |
SMALLINT | SQL_SMALLINT |
STRING | SQL_VARCHAR |
TIMESTAMP | SQL_TYPE_TIMESTAMP |
TINYINT | SQL_TINYINT |
VARCHAR | SQL_VARCHAR |
BOOLEAN | SQL_BIT |
BINARY | SQL_VARBINARY |
Prerequisites
Each computer on which you install the driver must meet the following minimum system requirements:
...
To access SSL options for a DSN, open the ODBC Data Source Administrator, where you created the DSN. Select the DSN and click Configure.
On the Kyvos ODBC Driver DSN Setup dialog box, select the Use SSL checkbox in the Advance Options
To specify the CA certificates that you want to use to verify the server, do one of the following:
To configure the driver to load certificates from a specific PEM file, specify the full path to the file in the Trusted Certificate Path.
To use the Windows Trust Store, select the Use System Trust Store checkbox.
| Panel | |||||||
|---|---|---|---|---|---|---|---|
| IMPORTANT
| ||||||
Important If using Windows Trust Store, you MUST import the trusted CA certificates to the Trust Store. |
...
To help troubleshoot issues, you can configure logging settings for the driver. In addition to the functionality provided in the Kyvos ODBC Driver, the ODBC Data Source Administrator provides tracing functionality.
| Panel | |||||
|---|---|---|---|---|---|
| |||||
| |||||
Important Logging or tracing decreases performance and can consume a large quantity of disk space, so make sure to keep log level as FATAL which will have a negligible impact on performance and disk space. |
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note After the maximum file size is reached, the driver creates a new file and continues logging. |
...
Click OK.
Restart your BI application for new settings to come in effect. The Kyvos ODBC Driver creates a log file named log at the location specified in the Log Path field.
...