The Jethro ODBC driver for Linux, 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:
Jethro ODBC drivers can be downloaded from the drivers download page.
To install the ODBC driver:
Navigate to the directory where the download placed the file, and run:
rpm -ivh jethroODBC-3.9.0-21970.x86_64.rpm
The driver will be installed under: /opt/jethro/jethroodbc/lib/libJethroODBC64.so
To setup a DSN based connection to Jethro instance on Linux, configure a system DSN with the instance connection details.
Edit Jethro's driver configuration file: /opt/jethro/jethroodbc/lib/JethroODBC.ini, and uncomment the line with the ODBCInstLib parameter, under the corresponding Driver Manager being used by your BI application. Most chances are, your driver manager is UnixODBC. In such case, you will need to uncomment the line under "SimbaDM / unixODBC" (remove the '#' sign), and your file will look like that afterwards:
# To use this INI file, replace [INSTALLDIR] with the # directory the tarball was extracted to. [Driver] DriverManagerEncoding=UTF-8 DriverLocale=en-US ErrorMessagesPath=/opt/jethro/jethroodbc/ErrorMessages/ LogLevel=0 LogNamespace= LogPath=/var/log/jethro/jethroodbc/ ## - Uncomment the ODBCInstLib corresponding to the Driver Manager being used. ## - Note that the path to your ODBC Driver Manager must be specified in LD_LIBRARY_PATH (LIBPATH for AIX, DYLD_LIBRARY_PATH for Darwin). ## - Note that AIX has a different format for specifying its shared libraries. # Generic ODBCInstLib # iODBC #ODBCInstLib=libiodbcinst.so # SimbaDM / unixODBC ODBCInstLib=libodbcinst.so # Darwin specific ODBCInstLib # iODBC #ODBCInstLib=libiodbcinst.dylib # AIX specific ODBCInstLib # iODBC #ODBCInstLib=libiodbcinst.a(libiodbcinst.so.2) # SimbaDM #ODBCInstLib=libodbcinst.a(odbcinst.so) # unixODBC #ODBCInstLib=libodbcinst.a(libodbcinst.so.1)
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:
# To use this INI file, replace [INSTALLDIR] with the # directory the tarball was extracted to. [ODBC Data Sources] JethroDataDSII=JethroODBCDriver [JethroDataDSII] Description=64-bit JethroData DSII Driver=/opt/jethro/jethroodbc/lib/libJethroODBC64.so Locale=en-US UID=jethro PWD=jethro SERVER=localhost PORT=9111 DATABASE=demo
Create and update the following required environment variables:
export JETHRO_ODBC_HOME=/opt/jethro/jethroodbc export ODBCINI=$JETHRO_ODBC_HOME/conf/odbc.ini export ODBCINSTINI=$JETHRO_ODBC_HOME/conf/odbcinst.ini export SIMBAINI=$JETHRO_ODBC_HOME/lib/JethroODBC.ini export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$JETHRO_ODBC_HOME/lib
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 allow using a DSN-Less connection with Jethro, you need to define the driver in the odbcinst.ini file and then provide a DSN-less connection string in your application. If your machine is already configured to use an existing odbcinst.ini file, then update that file by adding the settings described below. Otherwise, copy the odbcinst.ini file from /opt/jethro/jethroodbc/conf/ to the home directory (cp /opt/jethro/jethroodbc/conf/odbc.ini ~/.odbc.ini), and then update the file as described below.
In the [ODBC Drivers] section, add a new line by typing 'JethroODBCDriver' as a name for the driver, an equal sign (=), and then 'Installed':
[ODBC Drivers] JethroODBCDriver=installed
Create a section that has the same name as the driver (as specified in the previous step - JethroODBCDriver), and then specify the following configurations:
[JethroODBCDriver] APILevel=1 ConnectFunctions=YYY Description=64-bit JethroData DSII Driver=/opt/jethro/jethroodbc/lib/libJethroODBC64.so DriverODBCVer=03.90 SQLLevel=1
If connection with the client is not successfully established, check the following troubleshooting suggestions:
Any general-purpose BI/SQL query tool that supports the SQL-92 standard should be able to connect with Jethro.
The instructions below refer to MicroStrategy, but other tools would most probably require a similar process to establish that connection.
Description=MySQL ODBC 5.x Driver
Description=64-bit JethroData DSII