There are different kinds of SQLs supported by Kron DAM. The port number is the identifier of the connection to the Database via Kron DAM 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 DAM (e.g., if Oracle was added to Kron DAM, 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 DAM, into the Port field.

Input the IP number of Kron DAM into the Host field.

Enter the database name you entered in Kron DAM into the Service Name field.

For MSSQL DB Connections some SQL Clients could give connection errors. To solve this please change the 

To allow Oracle database connections via TOAD, the 

 parameter must be defined in the system configuration.

Even if the connection parameters are correctly configured, metadata retrieval may fail due to timeout in some cases. This is typically caused by slow response from the target database. If necessary, the 

 parameter can be increased to extend the timeout duration.

Learn how to connect to various databases using Kron PAM SQL Proxy in this informative document. Discover the step-by-step process for Oracle databases, including creating a new connection and entering essential credentials. Additionally, explore how Kron

Connecting to Zookeeper via Kron DAM SQL Proxy

Connecting with the Kron DAM SQL Proxy

Connecting with the Kron DAM SQL Proxy with MFA

3.8.1 User/Device/Policy Definition

Dynamic Data Masking

Oracle RAC Configuration

Hive - Zookeeper Configuration

Read-Only Mode on SQL Server

SQL Proxy

Session Logs

Query Logs

Active Sessions

Database Session Logs and Activity Views

Kron DAM with Azure SQL Database

Creating a Notification Target

Defining an Alarm Policy (cloned)

Defining an Alarm Policy

Database Alarm

Kron DAM Configuration for Connection of ML-Based Threat Analytics and Response Engine

ML Engine Endpoint Configuration

Threat Analytics Dashboard and Investigation

Kron DAM Configuration for Threat Threshold Incident Response

Anomaly Actions

Detected Risk Scores

Threat Analytics and Response Engine Configuration

User and Entity Behavior Analytics

SQL Proxy Configuration for SSO

Device Group Configuration in SSO

Configuring SSO Token Generation for Oracle and MSSQL Databases

Establish Connection to Database with SSO

Single Sign-On (SSO)

Creating a Vault Account

Vault Password Checkout

Associating a Vault Account with a Database Device

Add Vault Account

Connection Reservation and Approval

Query Approval and Management

Logging and Auditing

Connection Reservation & Command Approval

Denial-of-Service (DoS) Protection

Connection Rate Limit

Database Packet Rate

User Packet Rate

Buffer Overflow Attack Protection

DAM Object Explorer Usage

DAM Object Explorer

Creating Data Types 

Bulk Data Type Import

Data Discovery

Schedule Discovery

Data Regulatory Standards

Data Dictionary

Excluded Column Data Types

Applying Masking from Scheduled Discovery Results

Sensitive Data Discovery

Database Audit Report

Vulnerability Scanner Report

Reports

Permit Zone

Database Discovery

Adding Function Groups

Adding Function Realms

Menu Lists Management

APPENDIX 1: System Config Manager Parameters

APPENDIX 2: SQL Proxy Application Properties

Reference Guide