Connection to Jethro from external BI tools or SQL query tools can be established using Jethro ODBC / JDBC drivers. Jethro also provides a SQL command line interface client (JethroClient). Installation and configuration instructions for each driver and method are provided under the following sections:
Clients supported for Windows:
Clients supported for Linux:
Clients supported for Mac:
- On windows OS, when a few connection methods are offered by a query tool, it is recommended to install and use the ODBC driver 64 bit version (if possible), and to create a DSN connection.
- JethroClient CLI can be invoked on any Jethro node, and is commonly used to execute SQL commands and queries outside of BI tools.
- Another great SQL query tool commonly used to interact with Jethro, is SQL Workbench. A step by step guide for connecting SQL Workbench to Jethro, can be found under the JDBC driver - Connecting to SQL Query Tools section.