Skip to main content
This section provides reference documentation for the different SQL client connectors available for connecting to Ocient.

​
Available Drivers

JDBC Driver

Java Database Connectivity driver for Ocient

pyocient Driver

Python driver for Ocient following DB-API 2.0

​
JDBC Driver

The Ocient JDBC driver provides Java applications with connectivity to Ocient databases. It supports both CLI mode and programmatic access.

​
Download

Download the latest JDBC driver from the Maven repository.

​
Connection String Format

jdbc:ocient://<host>:<port>/<database>?<options>

​
Common Options

OptionDescriptionDefault
tlsTLS mode: on, off, or unverifiedunverified
maxRowsMaximum rows to returnNo limit
timeoutMillisQuery timeout in millisecondsNo timeout
For complete JDBC documentation, see the JDBC Manual.

​
pyocient Driver

The pyocient driver provides Python applications with connectivity to Ocient databases, following the Python Database API Specification 2.0.

​
Installation

pip3 install pyocient

​
Connection String Format

ocient://<user>:<password>@<host>:<port>/<database>
For complete pyocient documentation, see the pyocient Manual.

​
Third-Party Integrations

Ocient also integrates with various third-party tools:

DBeaver

Database administration tool

Metabase

Business intelligence platform

Tableau

Data visualization tool

Superset

Open-source BI platform

SQLAlchemy

Python SQL toolkit

Looker

Google Looker Studio connector