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.
You must also enable SSL for this JDBC endpoint to work. Using SSL relies on digital certificate to work. For ease of implementation, ODAS 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
Note The catalog name when connecting to Okera is
SQL Tool-Specific Instructions¶
For tool-specific documentation, see one of the following links: