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:
- 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 libary, 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.
- 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
- Download the Easysoft JDBC-ODBC Bridge. (Registration required.)
- 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.
- In SAP Lumira, choose File > Preferences.
The SAP Lumira Preferences dialog box is displayed.
- Choose SQL Drivers.
- In the Driver Installation pane, in the Select a Database list, choose Generic JDBC datasource - JDBC Drivers.
- Choose the Install Drivers button.
The Windows Open dialog box is displayed.
- 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.
- Choose the Done button.
- Restart SAP Lumira.
- In SAP Lumira, choose File > New.
The Add new dataset dialog box is displayed.
- In the Select a source list, choose Query with SQL, then choose the Next button.
The Add new dataset dialog box is displayed.
- 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.
- 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 - Choose the Connect button.
- Choose the database tables you want, and then choose the Create button.
The ODBC data is now available as a SAP Lumira data set.