groovy-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Péter Gergely Horváth <peter.gergely.horv...@gmail.com>
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 (http://dyna4jdbc.org/), 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. :)

Cheers,
Peter

[1] http://www.eclipse.org/birt/
[2] http://dyna4jdbc.org/
[3] https://github.com/peter-gergely-horvath/dyna4jdbc/wiki
[4] https://github.com/peter-gergely-horvath/dyna4jdbc/releases
[5] http://search.maven.org/#search%7Cga%7C1%7Cg%3A%22com.
github.peter-gergely-horvath%22%20a%3A%22dyna4jdbc%22

Mime
View raw message