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 back ends 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.

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, 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 you created the data source.

   For installation instructions, refer to 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.

The New Connection Profile dialog box is displayed.

10. Choose Generic JDBC from the list, enter "Easysoft JDBC-ODBC Bridge" in the space provided, and then choose Next.
11. 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

12. Choose the New Driver Definition button.

    The New Driver Definition dialog box is displayed.

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

    select * from suppliers

Execute the query by pressing ALT+X.