This guide will help you learn how to connect to a Progress OpenEdge database using the OpenEdge connector in Apatar.

Description

Apatar works with Progress OpenEdge through JDBC drivers (type 4) provided by Progress as part of any OpenEdge RDBMS product. For Progress version 9 the JDBC drivers (type 2) are provided separately under the Progress SQL92 Client Access product. In any cases no drivers are included in the installation package and required driver files need either to be in the system CLASSPATH or specified using the Manage Driver Files configuration window.

Configuration

To gain access to OpenEdge tables, please do the following:

1. Drag-and-drop connector for OpenEdge to Apatar's work panel.
   
   
   
   
2. Double-click on the connector.
3. Fill in the authorization details (database name, user name, password, host name or address and port number).
   If necessary, change the version number - the default is OpenEdge 10.1B, this is only required if you work with a Progress version 9 database in which case the connection is using a different driver class and URL format (i.e. 9.1D). Connector Configuration window:
   
4. Input fields specification (all fields are mandatory):
   UserName - user login name
   Password - user password
   Host - host where DB engine is running
   Port - port number where DB engine is running
   DBName - database name
   Version - version number
   
   
   
   
5. Manage driver files (please read the paragraph below)
6. Click Next.
7. The list of OpenEdge tables occurs. Make a selection and choose the table you would like to extract data from or write data to.
   
   
   
   
8. Click Next. If all the previous actions were performed correctly, you will see the names of the data fields.
   
   
   
   
9. Click Finish.

Managing Driver Files

The connector requires the OpenEdge JDBC driver files to be present in it's CLASSPATH in order to be able to connect to the database. For that you can either manually alter the system variable or edit the Apatars' launch script, alternatively there is a simple interface where you can manage the driver files so the connector directly load them when it's used. Driver files list is empty by default and you should add all required files in order to be able to connect to the database, please note that after the driver files were added the OpenEdge connector plug-in need to be reloaded and the only way seems to be to restart Apatar.

To add a driver file,

a) please click the Add button
b) enter the driver file path or select it using the Browse button
c) click Ok

To edit a driver file,

a) select a driver file from the list
b) click the Edit button
c) change the driver file path or select it using the Browse button
d) click Ok

To delete a driver file,

a) select a driver file or several driver files from the list clicking Ctrl+A or holding Shift or Ctrl and clicking on the driver files
b) click the Delete button
c) click OK to confirm selecting the driver files in the Confirmation window

Close the Manage OpenEdge Drivers window.

Preview

If necessary, you can preview data. To do so, right-click on the connector and choose "Preview Results".