SAP Lumira and the JDBC-ODBC Bridge

Are you evaluating

an ODBC driver?

Yes I am!

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.