SAP Lumira and the JDBC-ODBC Bridge

Bear in mind the following when using the JDBC-ODBC Bridge that's included in the SAP Lumira distribution:

• SAP Lumira currently ships with Java 1.7. This was the last version of Java to include the JDBC-ODBC Bridge. Future versions of SAP Lumira that are based on Java 1.8 and later will therefore no longer contain the JDBC-ODBC Bridge.
• The JDBC-ODBC Bridge is not recommended for production use.
• The 32-bit version of SAP Lumira has been phased out. At the time of writing, SAP Lumira is only available as a 64-bit application. The libraries it ships with, including the JDBC-ODBC Bridge's native library, JdbcOdbc.dll, are 64-bit. The implications of this are that the JDBC-ODBC Bridge can only be used to connect SAP Lumira to a 64-bit ODBC driver. Some ODBC drivers, such as the Microsoft Access ODBC driver for MDB format databases, are only available in a 32-bit version.

If you need to connect SAP Lumira to a 32-bit ODBC driver, use the Easysoft JDBC-ODBC Bridge instead. The Easysoft JDBC-ODBC Bridge has a Java component and a 32-bit native component. It is fully supported by Easysoft and is currently being deployed in production environments throughout the world.

1. Configure a system ODBC data source for the database that you want to connect to in SAP Lumira.

   To do this, use the 32-bit version of ODBC Data Source Administrator on your SAP Lumira machine. On some versions of Windows, this is located in Control Panel > Administrative Tools. On some version of Windows, you need to search for "ODBC" in the taskbar search box. The 32-bit version of ODBC Data Source Administrator should be clearly labelled. If in doubt, in the Windows Run dialog box, enter:

   %windir%\syswow64\odbcad32.exe

2. Download the Easysoft JDBC-ODBC Bridge.
3. Install and license the Easysoft JDBC-ODBC Bridge on the machine where the SAP Lumira is installed.

   For installation instructions, refer to the Easysoft JDBC-ODBC Bridge documentation.

4. In SAP Lumira, choose File > Preferences.

   The SAP Lumira Preferences dialog box is displayed.

5. Choose SQL Drivers.
6. In the Driver Installation pane, in the Select a Database list, choose Generic JDBC datasource - JDBC Drivers.
7. Choose the Install Drivers button.

   The Windows Open dialog box is displayed.

8. Use the dialog box to browse for Easysoft JDBC-ODBC Bridge JAR file, EJOB.jar.

   EJOB.jar is installed in the following location on the machine where you installed the Easysoft JDBC-ODBC Bridge:

   easysoft_install\Jars

   On 64-bit Windows, the default location for easysoft_install is drive:\Program Files (x86)\Easysoft Limited\Easysoft JDBC-ODBC Bridge.

9. Choose the Done button.
10. Restart SAP Lumira.
11. In SAP Lumira, choose File > New.

    The Add new dataset dialog box is displayed.

12. In the Select a source list, choose Query with SQL, then choose the Next button.

    The Add new dataset dialog box is displayed.

13. In the Select a Database list, choose Generic > Generic JDBC datasource - JDBC Drivers. Choose the Next button.

    The Add new dataset dialog box is displayed.

14. Complete the dialog box field:

    Field	Value
    User Name	dummy
    Password	dummy
    JDBC URL	jdbc:easysoft://localhost/data_source:logonuser=windows_user:logonpassword=password
    JDBC Class	easysoft.sql.jobDriver

15. Choose the Connect button.
16. Choose the database tables you want, and then choose the Create button.

    The ODBC data is now available as a SAP Lumira data set.