# How to add an OpenEdge JDBC datasource in ReportServer 4.7 CE

**URL:** <https://forum.reportserver.net/t/how-to-add-an-openedge-jdbc-datasource-in-reportserver-4-7-ce/1860>\
**Category:** ReportServer (EN)\
**Created:** [August 28, 2025, 2:38pm UTC](https://forum.reportserver.net/t/how-to-add-an-openedge-jdbc-datasource-in-reportserver-4-7-ce/1860 "2025-08-28T14:38:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![lacma](https://forum.reportserver.net/letter_avatar_proxy/v4/letter/l/f17d59/32.png) [@lacma](https://forum.reportserver.net/u/lacma)\
**Post date:** [August 28, 2025, 2:38pm UTC](https://forum.reportserver.net/t/how-to-add-an-openedge-jdbc-datasource-in-reportserver-4-7-ce/1860/1 "2025-08-28T14:38:45Z")

</div>

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 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!

---

<div class="post-metadata">

**Author:** ![IF\_Jasmin](https://forum.reportserver.net/letter_avatar_proxy/v4/letter/i/5e9695/32.png) [@IF\_Jasmin](https://forum.reportserver.net/u/IF_Jasmin)\
**Post date:** [September 1, 2025, 8:20am UTC](https://forum.reportserver.net/t/how-to-add-an-openedge-jdbc-datasource-in-reportserver-4-7-ce/1860/2 "2025-09-01T08:20:48Z")

</div>

Hello lacma,

This is only available in the EE. Please contact our [sales team](mailto:sales@infofabrik.de) if you would like a quote for the EE.

Best regards  
Jasmin