/
ODBC Driver for Mac

ODBC Driver for Mac

Feb 26, 2019

The Jethro ODBC driver for Mac, enables access to the data stored in Jethro instances, from Business Intelligence (BI) applications with ODBC support.

The following sections specify the steps required for the installation and configuration of Jethro ODBC driver:

Installation and configuration

Download

Jethro ODBC drivers can be downloaded from the drivers download page.

Prerequisites

  1. MacOS version 10.12.6 (Sierra)

  2. 51 MB of available disk space

  3. iODBC version 3.52.12 installed or ODBC Manager 1.0.12 installed

Installation

To install the ODBC driver:

  1. In Finder, Control-click or right click the icon of the app.

  2. Select Open from the top of contextual menu that appears.

  3. Click Open in the dialog box. If prompted, enter an administrator name and password.

  4. The installer installs the ODBC driver files in the following directories:

    1. <INSTALLATION-PATH>/jethro/jethroodbc/lib/         (By default <INSTALLATION-PATH> is '/opt/')

    2. /Library/ODBC/

Setting up the driver in the Driver Manager

In order to create a connection, the driver manager need to have Jethro defined as a driver.

This action can be done in two ways:

Manually

  1. Open the configuration file '/Library/ODBC/odbcinst.ini' in a text editor. If the file doesn't exist, create it.

  2. Add the following configs:

    [ODBC Drivers] JethroODBCDriver=installed [JethroODBCDriver] APILevel=1 ConnectFunctions=YYY Description=64-bit JethroData DSII Driver=/opt/jethro/jethroodbc/lib/libJethroODBC64.dylib DriverODBCVer=03.80 SQLLevel=1

ODBC Manager

  1. Open ODBC Manager, Navigate to 'Drivers' tab, and click on 'Add...':

  2. Enter the following details:

    1. Driver Name: JethroODBCDriver

    2. Driver File: /opt/jethro/jethroodbc/lib/libJethroODBC64.dylib

    3. Add the following Keywords and Values:

  3. Click on 'OK' to save the driver.

Setting a new connection (DSN)

To setup a DSN based connection to a Jethro instance on Mac, create a user/system DSN with the instance connection details, depending on the type of DSN you create:

User DSNs: ~/Library/ODBC/odbc.ini

System DSNs: /Library/ODBC/odbc.ini

To create a DSN, either use ODBC Manager, or edit the appropriate odbc.ini file manually.

Manually

Create/Edit the ODBC.ini file, (located at /Library/ODBC/odbc.ini for system DSN) and add the following configs into the file:

To connect to a single Jethro server, specify:

To connect to multiple Jethro servers, by using the driver client-side load balancing feature, specify:

In both cases, also specify:

For example:

[ODBC Data Sources] JethroDataDSII=JethroODBCDriver [JethroDataDSII] Description=64-bit JethroData DSII Driver=/opt/jethro/jethroodbc/lib/libJethroODBC64.dylib Locale=en-US UID=jethro PWD=jethro SERVER=jethro01.mycorp.com PORT=9111 DATABASE=demo

ODBC Manager

Setting a new connection (DSN-less)

Some BI applications allow setting up a DSN-less connection. The interface for setting up a DNS-less connection is BI tools specific, and it should generate a Jethro ODBC connection string. Jethro recommends using a DSN connection if possible, but some tools requires DSN-less connection string only.

To connect to your instance without a DSN, provide your application with a connection string. The elements format of the connection string are:

DRIVER={JethroODBCDriver};HOST={host};PORT={port};INSTANCE={instance_name};UID={user};PWD={password};

For example:

DRIVER=JethroODBCDriver;HOST=localhost;PORT=9111;INSTANCE=demo;UID=jethro;PWD=jethro;

Tableau Datasource Customization (TDC)

If Tableau is installed, Jethro will need a jethro specific connection settings for Tableau, to be copied into the required Tableau directory. To do so:

  1. Copy the TDC file from: /<INSTALLATION-PATH>/jethro/jethroodbc/conf/jethro.tdc       (By default <INSTALLATION-PATH> is '/opt/')

  2. Locate it under your repository: Documents/My Tableau Repository/Datasources

Testing the connection

To test the connection, use any BI or query tool of your choice. Here are two examples using iODBC:

  1. iODBC administrator offers a built in 'Test' button whithin the DSN tab.

  2. Using a Terminal screen:

    1. Type 'iodbctest'

    2. Type '?' to see all the DSNs defined

    3. Type DSN=<DSN-name> (don't use '<>')

    4. If the connection succeded, you should see 'SQL>'

    5. According to your schema, run any query and verify the results