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:
- Utilize an SQL client (such as DBeaver, DataGrip, SQL Workbench, etc.)
- 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).
- Enter the username and password for the device you entered in Kron PAM into the connection screen of your SQL client.
- Enter the SQL proxy port number, specifically assigned in Kron PAM, into the PORT field.
- 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.
- Enter the database name you entered in Kron PAM into the Service Name field.
- Establish the connection.
Demonstrates the screen for connecting via an SQL client.