Versions Compared

Old Version 1

changes.mady.by.user Boaz Raufman

Saved on

compared with

New Version Current

changes.mady.by.user Boaz Raufman

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

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:

  • ODBC 32/64 bit
  • JDBC

Clients supported for Linux:

  • ODBC
  • JethroClient (CLI)
  • JDBC

Clients supported for Mac:

  • ODBC
  • JDBC

Best practices

  1. 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.
  2. JethroClient CLI can be invoked on any Jethro node, and is commonly used to execute SQL commands and queries outside of BI tools.
  3. 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.