Configure Hive Accounts
Overview
You must create Hive accounts to connect to data sources that you want to use in your pipelines. You can configure your accounts from SnapLogic Platform using the Designer or Manager.
Snap-account compatibility
| Snaps | Generic Hive Database Account | Hive Database Account |
|---|---|---|
| Hive - Execute |  |
|
Configuring Hive with SSL
Add the following properties to the Url properties table of the respective Account to configure Hive with SSL.
Important:
- These configurations work only with Groundplexes and not Cloudplexes.
- The list is specific to Hive with or without Kerberos enabled. With Kerberos enabled, include the properties such as Client Principal, Key tab file, and Service principal in this list.
| URL property name | URL property value |
|---|---|
| ssl | Required. Binary value to denote that SSL is enabled. This value must always be 1. |
| sslTrustStore | Required. The path of SSL Trust store key file pointing to a JKS, PEM or CER file. The file can be referenced from the Groundplex's file system. |
| sslTrustStorePassword | Required. Password configured for the SSL Trust store. |
| AllowSelfSignedCerts | Binary value to denote whether the driver allows the server to use self-signed SSL certificates. Pass the value 1 to allow the use. |
| CAIssuedCertNamesMismatch | Binary value to denote that the driver requires the CA issued SSL certificate's name to match the host name of the Hive server. Pass the value 1 to indicate the names must match. |