Connecting to MSSQL, MySQL, Cassandra, Teradata, Hive, PostgreSQL, DB2, and SAP Hana Databases via Single Connect SQL Proxy
1 min
The port number is the identifier of the connection to the Database via Single Connect SQL Proxy.
- Create 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 in the sql.proxy.bind.port field of the Device Properties of the related device.
Connecting via SQL Proxy
- Single Connect supports Domain Authentication by including Single Connect and the userโs PC in the Domain. Once this is in place, the Windows Authentication option will be ready to use.
- The username and password are the same as the user credentials used directly to the database. The username must be defined as a user in Single Connect, and realms must be created for connection and policy enforcement by a system admin.