Configuring the JDBC Adapter for Jethro

Configuring the adapter consists of specifying connection and authentication information for each of the connections you want to establish.

Configure the Jethro JDBC Adapter

Procedure
1. From the WebFOCUS Reporting Server browser interface Applications page, click Get Data.

   or

   From the ibi Data Migrator desktop interface, expand the Adapters folder.

   In the WebFOCUS Reporting Server browser interface, the Get Data page opens showing your configured adapters. In the ibi Data Migrator desktop interface, the Adapters folder opens.

2. In the WebFOCUS Reporting Server browser interface, click the (+) button, and find the adapter on the page.

   or

   In the ibi Data Migrator desktop interface, expand the Available folder if it is not already expanded.

   In the WebFOCUS Reporting Server browser interface, you can select a category of adapter from the drop-down list or use the search option (magnifying glass) to search for specific characters.

3. In the ibi Data Migrator desktop interface, expand the appropriate group folder and the specific adapter folder. The group folder is described in the connection attributes reference.
4. Right-click the Jethro folder.
5. Click Configure ODBC.
6. In the URL box, enter the URL used to connect to your Drillbit. For more information, see Jethro URL Configuration Settings.
7. In the Driver Name box, enter the following:

   com.jethrodata.JethroDriver

8. Enter your User and password. The default values are jethro/jethro.
9. Click Test. You should see a list of data sources on your server.
10. Click Configure.

Jethro URL Configuration Settings

jdbc:JethroData:://host:port[;host:port]�/instance_name

Troubleshooting

If the server is unable to configure the connection, a dialog opens with an error message. The message typically begins with the following:

(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF) XOPEN: nnnn

where:

Some of the more common errors are:

(FOC1500) : (-1) [00000] JDBFOC>> connectx():
(FOC1500) : java.lang.UnsupportedClassVersionError:   
org/apache/drill/jdbc/Driver :   
(FOC1500) : Unsupported major.minor version 51.0   
(FOC1479) ERROR CONNECTING TO SQL DATABASE

This indicates that your Java version is less than 1.7, which is required.

Configuring the ODBC Adapter for Jethro

Configuring the adapter consists of specifying connection and authentication information for the connection that you want to establish.

Note that the ODBC Adapter for Jethro is only available for servers running on Windows.

Configure the ODBC Adapter for Jethro

Procedure
1. From the WebFOCUS Reporting Server browser interface Applications page, click Get Data.

   or

   From the ibi Data Migrator desktop interface, expand the Adapters folder.

   In the WebFOCUS Reporting Server browser interface, the Get Data page opens showing your configured adapters. In the ibi Data Migrator desktop interface, the Adapters folder opens.

2. In the WebFOCUS Reporting Server browser interface, click the (+) button, and find the adapter on the page.

   or

   In the ibi Data Migrator desktop interface, expand the Available folder if it is not already expanded.

   In the WebFOCUS Reporting Server browser interface, you can select a category of adapter from the drop-down list or use the search option (magnifying glass) to search for specific characters.

3. Right-click Jethro and click ODBC.

   The Add Jethro ODBC to Configuration dialog opens, as shown in the following image.

   

4. Enter the values for the parameters as described in Connection Attributes for the ODBC Adapter for Jethro
5. Click Configure.

Connection Attributes for the ODBC Adapter for Jethro