ReportServer Forum

lacma

Member

Registered: 2025-01-15

How to add an OpenEdge JDBC datasource in ReportServer 4.7 CE

Product/Version: ReportServer 4.7 Community Edition
OS / App Server / Java: Windows (server), Apache Tomcat 9, Java 11
Config: External config dir via -Drs.configdir=D:/EDW/ReportServer/config

Goal: Connect ReportServer CE 4.7 to Progress OpenEdge using the JDBC driver:

Driver class: com.ddtek.jdbc.openedge.OpenEdgeDriver
JAR: openedge.jar

What I did
  Placed openedge.jar in both …/reportserver/WEB-INF/lib and {rs.configdir}/lib/.
  Restarted Tomcat / ReportServer (driver is on the classpath).
  In Administration → Datasources → New → Relational Database, the mandatory Database dropdown does not include “OpenEdge” (nor a  “Generic JDBC” option). Because the field is required, I cannot save the datasource.

What the docs suggest & what blocks me in CE
  The documentation shows adding custom databases by implementing a DatabaseHelper and registering it via a DatabaseHelperProviderHook (e.g., Firebird/H2 examples).
  That approach requires scripting (a Groovy script in /fileserver/bin/onstartup.d or similar and then exec <script> from the terminal).
  In CE, however, scripting isn’t available: the terminal command exec returns command not found. (So I can’t register a DatabaseHelper.)

Question(s) to the community:
Is there any supported way in CE to add a custom database type (OpenEdge) without scripting?
e.g., placing a helper class on the classpath for auto-discovery,
adding/merging an XML config via {rs.configdir}/fsimport,
or importing a prebuilt datasource entity via package/terminal (without using scripting hooks)?

If CE cannot register new database types at all, can I bypass the “Database” dropdown and still create a JDBC datasource (for BIRT/Jasper) by any non-scripting means (import/export, REST, pkg, etc.)?

For Dynamic Lists, is the DatabaseHelper strictly required only for paging/limit/offset? If (hypothetically) I could create the datasource, would BIRT/Jasper run SQL against OpenEdge without a DatabaseHelper (i.e., pass-through SQL), while Dynamic Lists would still need the Helper?
If CE truly cannot support OpenEdge as a datasource, what workarounds are recommended in practice?

Extra context
I also tried creating a Groovy script under /fileserver/bin/onstartup.d to register a helper, but as noted, exec isn’t available in CE.
I can confirm the OpenEdge driver class is correct (com.ddtek.jdbc.openedge.OpenEdgeDriver), and the JAR is loaded on restart.
Any guidance (or confirmation that this is EE-only) would be much appreciated.

If there’s a known CE-compatible pattern for OpenEdge, I’d love to follow it. Thanks!

Last edited by lacma (2025-08-28 15:09:42)

IF_Jasmin

Moderator

Registered: 2024-11-14

Re: How to add an OpenEdge JDBC datasource in ReportServer 4.7 CE

Hello lacma,

This is only available in the EE. Please contact our sales team if you would like a quote for the EE.

Best regards
Jasmin