Connection Name

Enter a unique name for the connection.

Note: Once you save the connection, you cannot update the connection name later.

Provider Name

Select the database provider name from the list.

Select Big Data > Kyvos.

Driver Version

Select the associated driver version of the Kyvos instance.

Select Custom if you want to create a connection using custom hive jars. To upload customized drivers, refer Upload Drivers.

Host

Enter the IP or name of the machine where the Kyvos server is running.

Port

Enter the port number at which the server is listening.

Protocol

Select the transport protocol, which is HTTP or HTTPS.

HTTP Path

Enter the address of the path.

Username

Enter the username associated with the account to which this connection is made.

Blank Password

Select the checkbox if the password is not required to connect to the database.

Authentication Token

By default, this field is selected and non-editable.

Note: An authentication token is used to authenticate the requests securely.

Secure Sockets Layer (SSL) mode

Select the checkbox to enable SSL mode and ensure data transmission remains encrypted and secure.

SSL Trust Store 

Enter the SSL trust store file reference to allow the system to access the certificates stored in the trust store for validation purposes.

SSL Trust Store password

Enter the password to access the SSL trust store file.

Max Rows

Specify the maximum number of rows to be fetched from the dataset.

Connection URL

It is an auto-generated connection string that connects to the database.

Mask Connection String

If the field is selected, the connection string is masked.

Charset Encoding

Select UTF-8 if the database is created or started with UTF-8 encoding. Otherwise, keep it blank.

Database Timezone

Select the time zone to receive the output of date/time fields based on the time zone in which the data was entered into the database.

Is Default

Select this checkbox to use this connection as the default data connection to fetch report data.

Read Only

By default, the field is selected and non-editable.

Note: The selected checkbox ensures that only SQLs having read operations are executed using this connection. The write or load operation is not executed.

Pool Settings

Initial Connection(s)

Incremental Size

Resubmit Time

Max. Connections

Specify the number of pool connections that must open initially. The number of default initial connections is 5.

Specify the number of connections that will open when all the open connections are consumed. The default incremental size is 5.

Specify the waiting time in seconds before generating a re-submit request. The default resubmit time is 30 seconds.

Specify the maximum number of connections that can be opened to the selected database simultaneously. The default maximum number of connections is 30.

Cache

Enable MetaData Caching

MetaData Cache Purge Frequency

By default, the field is deselected and non-editable as it does not impact this connection.

By default, the field is disabled as it does not impact this connection.