JethroData ODBC Installation and Configuration For Windows 64-bit Table of Contents 1 ODBC Driver Installation and Configuration.........................................................................................2 1.1 ODBC Driver Installation...............................................................................................................2 1.2 Setting a new DSN for JethroData..................................................................................................3 1.3 Troubleshooting Connection Issues.................................................................................................4 2 Configuration Steps for Qlik Sense........................................................................................................5 3 Configuration Steps for Tableau.............................................................................................................6 4 Configuration Steps for SAS JMP..........................................................................................................7

1/8

1 ODBC Driver Installation and Configuration •

This ODBC driver only works on Windows 64-bit. It will not work on Windows 32-bit.

•

If there are firewalls between the Windows machine and Jethro server , make sure that the Windows client can access to the JethroServer machine on JethroServer port (over TCP). ◦ The default port number for JethroServer is 9111. The actual port number can verified on the server by viewing the configuration file $JETHRO_HOME/instances/services.ini

1.1 ODBC Driver Installation 1. Download and install "Visual C++ Redistributable for Visual Studio 2012 Update 4" for Windows 64-bit (vcredist_x64.exe) from Microsoft web site: http://www.microsoft.com/en-us/download/details.aspx?id=30679 2. Download / copy the Jethro ODBC driver ZIP file to the Windows machine. 3. Create a directory for Jethro driver under C:\Jethro (use this specific directory name) and unzip the ODBC driver into it - the directory should include several files and an ErrorMessages directory. 4. Double click SetupJethroODBC-64on64.reg to automatically register the Jethro DLLs in the Windows registry . You will need to confirm the execution by clicking on Run, followed by Yes. You should get a confirmation message – click OK.

2/8

1.2 Setting a new DSN for JethroData 1. Open the ODBC Data Source Administrator window - Either from Start → Search ODBC or from the Control Panel under Administrative Tools → Set up data source (ODBC) 2. Click on System DSN tab.

3. You will find a sample DSN called JethroODBC that was automatically created. Click “Configure...” to edit it: ◦ If you are connecting to a single JethroData server, specify: Host: host name or IP address of the machine running JethroServer. Port: the port that JethroServer listens for, on the machine running JethroServer. Default port is 9111 (see the firewall note in the beginning of page 2). ◦ If you are connecting to multiple JethroData servers, using the driver client-side load balancing feature, specify: Host: a list of host:port pairs, separated by semi-colons. For example: jethro01.mycorp.com:9111;jethro02.mycorp.com:9111;jethro03.mycorp.com:9111 Port: leave empty ◦ In both cases, also specify: Instance: the name of the Jethro instance on the server Login Id / password: default username/password is jethro/jethro

3/8

An example, connecting to a single JethroData server:

If you want to create additional DSNs, click “Add...”, choose JethroODBCDriver and click Finish. You will get the same dialog as in step 3 above.

1.3 Troubleshooting Connection Issues •

Verify that the JethroServer process is running on the server.

•

Verify that the JethroServer port is accessible from the client (no firewalls blocking in the middle).

•

Check c:\Jethro directory for logs

•

If you receive ODBC system error 193 when trying to connect – this is a a generic ODBC error message meaning that a 32-bit application is trying to use a 64-bit driver. Make sure you use a 64-bit version of the client application (BI tool etc).

4/8

2 Configuration Steps for Qlik Sense 1. Follow chapter 1 ODBC Driver Installation and Configuration to install the JethroData ODBC driver and configure a DSN. 2. Open the Data loader editor. On the right side, click Create new connection under Data connections, then click ODBC.

3. In the Create new connection (ODBC) popup, pick the JethroData ODBC 64-bit DSN you have created (default name is JethroODBC). Fill any text under username and password and click save. 4. Continue as usual, for example, clicking Select data or Insert connection string on the right

5/8

3 Configuration Steps for Tableau 5. Follow chapter 1 ODBC Driver Installation and Configuration to install the JethroData ODBC driver and configure a DSN. 6. Copy the file jethro.tdc from the driver directory C:\Jethro to the Datasources directory under your Tableau repository directory. For example, for Tableau 8,x Desktop, copy the file to (replace user_name with your Windows user name): C:\Users\user_name\Documents\My Tableau Repository\Datasources NOTE – without this Tableau-specific configuration file, you will not be able to connect 7. For Tableau Desktop 1. Start Tableau Desktop 2. Click “Connect to Data” 3. Under “On a server” scroll down to the bottom and click on “Other Databases (ODBC)” 4. Under DSN choose the JethroData DSN that you have defined. 5. Click “Connect” and continue as usual

6/8

4 Configuration Steps for SAS JMP Tested on JMP 11.2.0 on Windows 64-bit. 1. Follow chapter 1 ODBC Driver Installation and Configuration to install the JethroData ODBC driver and configure a DSN. 2. Click “File” --> “Database” --> “Open Table...” The "Database Operations" dialog will open

3. In the "Connections" section, click "Connect". The "Select Data Source" dialog will open. 4. Click on "Machine Data Source" tab, then click on the JethroData ODBC DSN you configured (default is "JethroODBC"), then click "OK"

7/8

5. A dialog with the DSN attributes will appear. Review and click "OK" 6. You will return to the “Database Operations” dialog. Click on the schema name (def_schema by default) to populate the list of tables, then pick a table

8/8