ODBC Installation IntroductionJethro has an ODBC driver that allows configuring Jethro to be used with various BI tools.The following sections specify the steps required for the installation and configuration of Jethro ODBC driver: Installing ODBC Driver Setting a new DSN for JethroData Troubleshooting Connection Issues Configuring ODBC for Various BI ToolsoQlik SenseoTableauoSAS JMP
Installing ODBC DriverODBC driver can be installed for either 32-bit or 64-bit environments.To install ODBC driver:1). Go to the download page, https://jethro.io/driver-downloads.2). Download the file relevant for your environment.3). Double-click the newly downloaded file to open the InstallShield wizard for JethroODBC.4). Click Next to proceed to the following screen, which allows you to choose whether to accept thedefault installation location or to select another location.5). Use the next screen: Ready to Install the Program, to review the installation settings and, if thesesettings are appropriate, click Install.
6). Click finish when installation is completed7). If you have Tableau Desktop installed, the following message appears after the installation is complete:When using Jethro with Tableau the file jethro.tdc must be copied to the correct location in Tableau to apply Jethrospecific connection setting. Click Yes to allow ODBC installer to copy jethro.tdc to the correct location in Tableau. Ifyou choose No Jethro will not work properly with Tableau unless the tdc file will be copied manually to correct location forTableau.Note:If you install Jethro ODBC before Tableau is installed and later install Tableau, you need to manually copy the filejethro.tdc from the directory where Jethro ODBC is installed (by default, C:\Program Files\JethroData\JethroODBC)to the Datasources directory under your Tableau repository directory.For more details, see: Tableau.
Setting a new DSN for JethroDataAfter the JethroODBC driver is created, you have to add a system DSN that provides connectivity to the newlyinstalled driver.To set s System DSN for JethroODBC:1). Open the ODBC Data Source Administrator window, by going to Start Search and typing either ODBCor Administrative Tools.2). Click the System DSN tab, as shown below.3). Click Add to open the Create New Data Source popup.This popup includes a sample DSN called JethroODBC, which was automatically created duringinstallation.4). Double-click this DSN to open the JethroODBC configuration dialog.
To connect to a single Jethro servers, specify:Host - Host name or IP address of the machine that runs JethroServer.Port - The port to which JethroServer listens, on the machine running JethroServer; default port is 9111, butthe actual port number can be verified on the server by viewing the configuration file JETHRO HOME/instances/services.iniTo connect to a multipale Jethro servers, specify:If you are connecting to multiple JethroData servers, by using the driver client-side load balancing feature,specify:Host - A list of host:port pairs, separated by semi-colons. For om:9111;jethro03.mycorp.com:9111Port - Leave empty5). In both cases, also specify:Instance - The name of the Jethro instance on the serverLogin Id / password - Default username/password is jethro/jethro.6). The following image displays sample settings used for connecting to a single JethroData server:7). To create additional DSNs, repeat steps 3 to 5.
Troubleshooting Connection IssuesIf connection with the client is not successfully established, check the following troubleshootingsuggestions: ) Verify that the JethroServer process is running on the server. ) Verify that the JethroServer port is accessible from the client (no firewalls are blocking the connection). ) Check the directory where Jethro server is installed (by default, c:\Jethro) logs. ) If you receive ODBC system error 193 when trying to connect – this is a generic ODBC error message meaningthat a 32-bit application is trying to use a 64-bit driver. Ensure that you use a 64-bit version of the clientapplication (BI tool and so on).
Configuring ODBC for Various BI ToolsQilk SenseTo configure JethroODBC for use with Qilk Sense:1). Install the JethroODBC driver and configure a DSN for it. For details, see Installing ODBC Driverand Setting a new DSN for JethroData.2). Open the Data Loader Editor.3). Go to Data connections and click Create new connection.4). From the Standard connectors list, click ODBC.5). In the Create new connection (ODBC) popup, pick the JethroData ODBC 64-bit DSN you havecreated (default name is JethroODBC).6). Enter a username and a password of your choice and click Save
TableauTo configure JethroODBC for use with Tableau:1). Install the JethroODBC driver and configure a DSN for it. For details, see Installing ODBC Driver andSetting a new DSN for JethroData.2). Copy the file jethro.tdc from the directory where Jethro is installed (by default, C:\ProgramFiles\JethroData\JethroODBC) to the Datasources directory under your Tableau repositorydirectory.For Tableau Desktop, copy the file to the following (default) directory:C:\Users\ user name \Documents\My Tableau Repository\DatasourcesFor Tableau Server, copy the file to the following (default) directory:C:\Program Files\Tableau\Tableau Server\[version]\binNote:Without the jethro.tdc Tableau-specific configuration file youwill not be able to connect.To configure connection with Tableau desktop:1. Start Tableau Desktop.2. Click Connect to Data.3. Under Connect To a server , click More 4. Scroll down to the bottom and click on Other Databases (ODBC).5. Under DSN, select the JethroData DSN that you have defined6. Click Connect and continue working as usual
SAS JMPTo configure JethroODBC for use with SAS JMP:1). Install the JethroODBC driver and configure a DSN for it. For details, see Installing ODBC Driver and Setting anew DSN for JethroData.2). Click File Database Open Table.The Database Operations dialog appears.3). In the Connections section, click Connect.The Select Data Source dialog appears.4). Click on the Machine Data Source tab, then click on the JethroData ODBC DSN you configured (default is"JethroODBC").5). Click OK to confirm.
C:\Users\ user_name \Documents\My Tableau Repository\Datasources For Tableau Server, copy the file to the following (default) directory: C:\Program Files\Tableau\Tableau Server\[version]\bin Note: Without the jethro.tdc Tableau-specific configuration file you will not be able to connect. To configure connection with Tableau desktop: 1.