Reference Guide
...
Data Access Manager
SQL Proxy
Connecting with the Single Connect SQL Proxy
4min
There are different kinds of SQLs supported by Single Connect.
To connect to an Oracle database:
- Create a new connection on the SQL Client (Toad, Navicat, etc.)
- Enter the database username and password.
- Set the Single Connect IP address and port as the connection host and port address.
- Enter the target database IP address, target database port, and database name in the Service Name field. Values should be separated with a colon ":"
Connecting with SQL Proxy

Single Connect supports the proxy user authentication feature of Oracle DBs. The connection string for proxy user authentication is proxy_user[authorized_user]. The password for this connection should be the password of the proxy user.
Connecting to MSSQL, MySQL and Cassandra, Teradata, Hive, PostgreSQL, DB2, SAP HANA, and Couchbase Databases via Single Connect SQL Proxy
The port number is the connection identifier to the Database when using the Single Connect SQL Proxy feature.
- Establish a new connection on the SQL Client.
- Enter the database username and password.
- Set the Single Connect IP address as the connection host and IP address
- Enter the Bind Port number defined by sql.proxy.bind.port in the Device Properties of the related device.
Connecting with SQL Proxy

Single Connect supports Domain Authentication by including Single Connect and the user's PC in the Domain. After this is set up, the "Windows Authentication" option will be available to use.