Easysoft Blog

Fri, 15 Jun 2018

Eclipse Data Tools Platform

Eclipse Data Tools Platform is a an open source project developed by the Eclipse community that provides tools for creating, managing and using data across multiple platforms and data sources.

Eclipse Data Tools Platform supports JDBC, enabling it to connect to databases for which a JDBC driver is available. The Easysoft JDBC-ODBC Bridge extends the number of databases that are available to Eclipse Data Tools Platform by bridging between JDBC and ODBC. You can then also work with data from backends for which an ODBC driver is available. For example, you can connect Eclipse Data Tools Platform to Microsoft Access by using the Easysoft JDBC-ODBC Bridge and the ODBC Driver for Microsoft Access:

Note Currently, the Easysoft JDBC-ODBC Bridge supports 32-bit ODBC drivers only. On Windows, all recent Easysoft ODBC drivers install both a 32-bit and a 64-bit ODBC driver.

These steps show how to work with ODBC data in Eclipse Data Tools Platform on Windows:

  1. Configure a System ODBC data source for the database that you want to connect to in Eclipse Data Tools Platform.

    To do this, use the 32-bit version of ODBC Data Source Administrator on your Eclipse Data Tools Platform 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 you created the data source.

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

  4. In Eclipse, create a new General Project.
  5. Create a lib folder under the new project's directory structure in your Eclipse workspace.
  6. Copy the Easysoft JDBC-ODBC Bridge JAR file, EJOB.jar to the lib folder.

    EJOB.jar is installed in the following location on the machine where you install 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.

  7. In Eclipse, choose the Open Perspective icon..

    The Open Perspective dialog box is displayed.

  8. Choose Database Development, and then choose Open.
  9. In the Data Source Explorer pane, right-click Database Connections, and choose New.
  10. The New Connection Profile dialog box is displayed.

  11. Choose Generic JDBC from the list, type "Easysoft JDBC-ODBC Bridge" in the space provided, and then choose Next.
  12. Complete the dialog box's General fields:
    Setting Value
    Database Dummy
    URL jdbc:easysoft://localhost/MyODBCDataSource:LogonUser=MyWindowsUser:LogonPassword=MyWindowsPassword
    User name Dummy
    Password Dummy
  13. Choose the New Driver Definition button.

    The New Driver Definition dialog box is displayed.

  14. Choose Generic JDBC Driver from the list and then choose the JAR List tab.
  15. Choose the Add JAR/Zip... button. Browse to the lib folder and then choose EJOB.jar
  16. In the Properties tab, enter the driver URL shown earlier into the Connection URL box.
  17. In the Driver Class box, enter easysoft.sql.jobDriver. Choose OK and the Finish
  18. In the Data Source Explorer pane, right-click the new connection, and then choose Connect.
  19. In the Data Source Explorer pane, right-click the new connection, and then choose Open SQL Scrapbook.
  20. In the SQL Scrapbook pane, choose Generic JDBC_1_x from the Type list. Choose New Generic JDBC from the Name list.
  21. Execute a SQL query against the new database connection . For example:
    select * from suppliers
  22. Execute the query by pressing ALT+X