End User Guide
...
Data Access Manager
SQL Proxy

Establishing a Connection via Kron PAM SQL Proxy

1min

The port number is the identifier of the connection to the Database via Kron PAM SQL Proxy.

To establish a connection using SQL Proxy:

  1. Utilize an SQL client (such as DBeaver, DataGrip, SQL Workbench, etc.)
  2. Initiate a new connection in the SQL client, selecting the type of database added to Kron PAM (e.g., if Oracle was added to Kron PAM, select an Oracle-type connection).
  3. Enter the username and password for the device you entered in Kron PAM into the connection screen of your SQL client.
  4. Enter the SQL proxy port number, specifically assigned in Kron PAM, into the PORT field.
  5. Or if you defined a property named sql.proxy.bind.port you need to use that information (look at the figure above)Input the IP number of Kron PAM into the Host field.
  6. Enter the database name you entered in Kron PAM into the Service Name field.
  7. Establish the connection.
Demonstrates the screen for connecting via an SQL client.
Demonstrates the screen for connecting via an SQL client.




PREVIOUS
Preliminary Steps for SQL Proxy
NEXT
SQL Proxy Logging and Monitoring
Docs powered by Archbee