Connect to Ocient

Users connect to any of the SQL Nodes in an Ocient® system to connect and run queries or commands. The SQL Node is available by default on port 4050 at the IP address or hostname assigned to the SQL Nodes. When more than one SQL node is present in the Ocient system, Ocient will automatically load balance connections between the nodes to even out the load across connections.

Ocient provides a JDBC driver, an ODBC driver, and a Python® driver called pyocient. You can use any of these drivers to connect to an online Ocient system.

To connect from a client computer that can access the SQL Node via the network, following any of the following examples. Note that you must have the IP address of the SQL Node and a valid username and password to connect.

If you are unable to connect, check the logs on the SQL Nodes for issues or check the Errors and Warnings for more detail on error codes.