SINGLE CONNECT
...
3.4 SQL Proxy
3.4.4 Logging SQL Queries
4 min
connecting single connect sql proxy https //archbee io/docs/1s a8r9fnbldt7zdyf13d/nifhyvaitxtp gc7f5o5i#connecting single connect sql proxy connecting oracle database via single connect sql proxy create new connection on the sql client enter username and password of the database 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 into the service name field values should be separated by the colon " " punctuation connecting mssql, cassandra and mysql database via single connect sql proxy the port number is the identifier of the connection to the database via the sql proxy feature of single connect create new connection on sql client enter in the username and password of the database 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 device properties of the related device note single connect supports domain authentication by including single connect and user's pc to the domain later this process, "windows authentication" option will be ready to use logging sql queries https //archbee io/docs/1s a8r9fnbldt7zdyf13d/nifhyvaitxtp gc7f5o5i#logging sql queries checking sql proxy command logs log in to the single connect gui navigate to logging > session log open the “command logs” tab enter in the information into the search filter and click search