Skip to main content
The Ocient® Management UI is a web-based interface designed to support the primary tasks of database users without requiring command-line tools. Here, learn about how to connect to the UI, configure access control, and set up connection endpoints. For an overview of UI features and pages, see Ocient Management UI Features.

​
Connect to the UI

Learn how to connect to the Ocient Management UI remotely. This process assumes you have access to an Ocient System with the UI installed.

​
Prerequisites

Any computer that you use to access the UI remotely must have:
  • Network access to an Ocient System with the UI installed
  • Google® Chrome, Safari®, Microsoft® Edge, or Firefox® (latest version)

​
Log Into the Ocient Management UI

Follow these steps to connect to your Ocient System from any machine with network access. To access the Ocient Management UI, use a web browser to navigate to the SQL Node using its IP address or hostname as a URL domain. This URL must use the https protocol. Your SQL Node connection information is available from your Ocient System or database administrators. For details, see Configure Connection Endpoints. To connect, specify the SQL Node IP address or hostname.
After loading, your web browser displays the Ocient Management UI login page.
Ocient Management UI login page showing database connection and credential fields, with a single sign-on option.

​
Select the Database

The Ocient Management UI can connect to individual databases or the default system database. Connect to the Default Database By default, the login page connects to system, which gives you visibility into all databases where you have access. To create or modify tables or to execute data pipelines, connect to an individual database instead. For details, see Manage Users, Groups, and Roles. Connect to Your Database To connect to your database, enter the name of the database in the Connect to field on the login page.
Ocient Management UI login page showing the database selection field and a single sign-on option.
You can also change your active database connection after logging in using the database switcher in the sidebar navigation.

​
Login Credentials

You can log in to the Ocient Management UI using either of these methods:
  • User credentials (username, password).
  • Single Sign-On (SSO) authentication — The UI supports multiple SSO integrations configured per database or Connectivity Pool.
For details about configuring SSO integrations, see Authentication Methods.

​
Administration

Learn how to configure and administer the Ocient Management UI.

​
Access Control

For full UI visibility and functionality, you must have read, create, and modify privileges on each database that you want to connect to. These user roles have full visibility and functionality in the Ocient Management UI:
  • System Administrator
  • Database Administrator
Other roles can use the UI but have limited capabilities based on their privileges. To assign user roles and privileges, see Data Control Language (DCL) Statement Reference.

​
Install and Manage the ocui Package

The Ocient System includes a base version of the Management UI bundled with the core ocient package. The ocui package is a separate DEB or RPM package that allows you to update the Management UI without upgrading the entire Ocient System. Install the ocui package on any SQL Node where you want to host the updated UI. When the ocui package version matches the installed ocient package version, the system hosts the UI from the ocui package. When the versions differ, the system falls back to the base UI included with the ocient package.
For access to the ocui package, contact Ocient Support.

​
Install the ocui Package

Transfer the ocui package file to the target SQL Node, then install it using the appropriate package manager command. Install using DEB.
Install using RPM.
After installation, verify that the Management UI is accessible by navigating to the SQL Node URL in a web browser. For details, see Connect to the UI.

​
Verify the Installed Version

Use the package manager to check the installed ocui version on the SQL Node. Check the version using DEB.
Check the version using RPM.

​
Uninstall the ocui Package

Remove the ocui package from the SQL Node using the appropriate package manager command. After removal, the system reverts to the base Management UI included with the ocient package. Remove using DEB.
Remove using RPM.

​
Configure Connection Endpoints

Access the Ocient Management UI by connecting to a SQL Node using the connection parameters set by its Connectivity Pool. The Connectivity Pool defines a SQL Node connection configuration with:
  • IP address
  • Hostname
  • Port
  • SSO integration
For information on all Connectivity Pools created in your system, query the sys.connectivity_pools system catalog table. For information on SQL Node connection parameters (IP address and network ports), query the sys.connectivity_pool_participants system catalog table. To alter SQL Node connection parameters (IP address, port, and SSO integration), see Cluster and Node Management.

​
Configure API Port

For network access, the Ocient Management UI requires a Connectivity Pool with an open port for the HTTP Query API. Follow these steps to ensure your port is accessible.
  1. Identify the Connectivity Pool and SQL Node you want to use by querying the sys.connectivity_pool_participants system catalog table.
  1. In the system catalog output, check the openapi_port value for the Connectivity Pool and SQL Node you want to use. If this openapi_port value is NULL, the port is not open.
  2. If you need to open the port or change its value, execute this statement using your Connectivity Pool and SQL Node names. This example uses port 443, which is the default port for HTTPS traffic.

​
Install SSL Certificates

The Ocient Management UI uses SSL certificates to connect to the system, similar to other methods such as the JDBC driver.
By default, the system uses self-signed certificates. Using these certificates can result in the browser displaying an invalid certificate warning. For details about installing certificates, see Secure Connections Using TLS.
Ocient Management UI Load Data SQL Reference Database Administration
Last modified on September 23, 2026