DBeaver SQL Client for OpenEdge
Progress does not have a SQL Client like Microsoft has SQL Server Management Studio or MySQL has Workbench. DBeaver is an excellent SQL Client for OpenEdge using JDBC. This article discusses how to configure DBeaver to connect to OpenEdge using JDBC and execute SQL statements.
This article will not discuss downloading and installation since that process is fairly easy. Download community edition. Then, review wiki for documentation. During the installation, you may be asked to install drivers. You can safely skip that portion. If you would like to install drivers during the installation process, you are most welcome to do so.
Add OpenEdge Driver
In order to add OpenEdge Driver, you will need to have access to openedge.jar and progress.jar. You will find those JAR files under /usr/dlc/java on Linux. On Windows, search for those files. Note down the location of both those files.
Open DBeaver. Then, go to Database > Driver Manager
Click on New in Driver Manager window
Set these values for properties when creating a new OpenEdge driver:
- Driver Name = Progress OE
- Driver Type = Keep Generic or choose that from drop down
- Class Name = com.ddtek.jdbc.openedge.OpenEdgeDriver
- Category = OpenEdge
- Description = Progress OpenEdge
- Click on Add File button and choose openedge.jar AND progress.jar
- Then, click on openedge.jar after adding that file
- Then, click on Find Class
You’ll notice that Driver class dropdown gets filled automatically with com.ddtek.jdbc.openedge.OpenEdgeDriver. Click on OK to save the driver configuration.
Now that a driver is created, let’s create a connection to Sports database that’s running on port 10000.
- Click on Database > New connection
- You’ll, then, be asked to select the driver. Expand the category OpenEdge and choose Progress OE and click Next
- JDBC URL = jdbc:datadirect:openedge://localhost:10000;databaseName=sports;defaultSchema=pub
- Username = sysprogress
- Password = whatever password you gave sysprogress
- Then, click on Test Connection button and you should see a successful connection
- Click Next
- Set Connection Name to sports2000
- Then, click Finish
Now you have a connection created.
Connect and execute some queries
Right click on your connection and click Connect.
Then, press F3 to open a SQL Editor.
In the SQL Editor, type the following command:
SELECT * FROM department;
Then, press CTRL+ENTER to execute the query. You will see a list of all departments in the results pane below the SQL Editor.
DBeaver will show a list of schema, tables, indexes and many more properties of objects within Sports database. You can write your own queries in SQL Editor and execute them as well.
See more articles on Modern web applications and API with OpenEdge, SQL, ODBC and PHP