Reference Guide
...
Dynamic Data Masking
Hive - Zookeeper Configuration

Connecting to Zookeeper via Kron PAM SQL Proxy

1min

Users can connect to the Zookeeper database through the Kron PAM SQL Proxy using an SQL client:

  1. Open an SQL client (e.g., DBeaver, DataGrip).
  2. Create a new connection and select the appropriate database type.
  3. Enter the following connection details:
    • Host: The IP address of the Kron PAM server. Please look at below example of URL below that contains the host port and any etc.)
      • jdbc:hive2://10.20.42.159:1022/newdb;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2;
    • Port: The SQL proxy port assigned to the Zookeeper device in Kron PAM.
    • Username: The username configured in Kron PAM (must match the database username).
    • Password: The corresponding password.
    • Database/Service Name: The name of the Zookeeper database as defined in Kron PAM.
Document image

  • Test the connection to ensure that it is successful.