Easysoft Blog

Tue, 10 May 2016

SAP Lumira and the JDBC-ODBC Bridge

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

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, type:

    %windir%\syswow64\odbcad32.exe
  2. Download the Easysoft JDBC-ODBC Bridge. (Registration required.)
  3. Install and license the Easysoft JDBC-ODBC Bridge on the machine where the SAP Lumira is installed.

    For installation instructions, see 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:
    FieldValue
    User Namedummy
    Passworddummy
    JDBC URLjdbc:easysoft://localhost/data_source:logonuser=windows_user:logonpassword=password
    JDBC Classeasysoft.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.