groovy-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Péter Gergely Horváth <>
Subject Using Groovy in Business Intelligence applications via dyna4JDBC driver
Date Tue, 08 Nov 2016 16:45:37 GMT
Hi Groovy Users,

There is one more area where the power of Groovy can now be utilized: I
developed a JDBC driver called dyna4JDBC (, which
allows Groovy (or any JSR-223 compatible scripting language) to be called
via the JDBC API. The standard output echoed by the script is parsed to a
JDBC Result Set, so that the caller application can process it further.

The goal of this driver was to allow JDBC-compatible reporting and ETL
applications calling dynamic JVM language scripts as if they were databases
and exposing the script output as a result set for further processing
(e.g.: advanced visualizations: charts etc.)

For example, you can now use Eclipse BIRT [1] reporting application and
create reports, which are backed by a Groovy script: You can simply
configure a JDBC datasource in Eclipse BIRT and write a Groovy script
against that datasource instead of SQL. The output the script prints to the
standard output will appear as the result set of the "query".

You can get a quick introduction on the project home page [2]. The
documentation is on GitHub Wiki [3], and the binary version of the driver
can be downloaded from GitHub [4] or from Maven Central [5].

I am sharing it here in the hope that it might be useful for some people
and that I could potentially get some feedback you. :)



View raw message