Skip to content

Connecting to Okera via ODBC/JDBC Clients

You can connect your favorite SQL tool to Okera's Presto endpoint using JDBC or ODBC.

In general to connect to Okera via JDBC or ODBC you will need:

  • A Presto JDBC or ODBC driver
  • SSL enabled
  • Okera's Presto endpoint host and port number

Downloading a Presto JDBC or ODBC driver

Consult your SQL tool documentation to get the right JDBC or ODBC driver. For example, the Tableau driver is available here. The Simba Presto ODBC driver is available here and can be used for PowerBI. Okera also provides the JDBC driver JAR for download.

For information on how Okera uses JDBC drivers, see JDBC Driver Use in Okera.

Enabling SSL

You must also enable SSL for this JDBC endpoint to work. Using SSL relies on digital certificate to work. For ease of implementation, Okera will implement a self-signed, wildcard certificate for the cluster if one is not already in place. Consult your client tool documentation for any settings you need to:

  • Enable SSL
  • Allow self-signed certificates
  • Allow common name (CN) and hostname mismatches

Okera's Presto Endpoint

The default port for Okera's Presto endpoint is 14050. You can also find the Okera Presto host/port in the Okera UI by clicking the System page.

Note The catalog name when connecting to Okera is okera.

SQL Tool-Specific Instructions

For tool-specific documentation, see one of the following links: