ReportServer Forum

Slach

Member

Registered: 2013-07-28

Need Vertica CE jdbc driver support

Hello ReportServer development team
your software is awesome
it's a really what i want for reporting and dashboard

but i have jdbc datasource based on Vertica database

howto i can help you for append support Vertica Community Edition database to your great product??

Server Installation and JDBC driver can be found here
https://my.vertica.com/download-community-edition/

Thorsten J. Krause

Guest

Re: Need Vertica CE jdbc driver support

Hi Slach,

adding support for additional datasources to ReportServer is actually quite easy by means of ReportServers integrated script-engine.

I described the general process here:
http://blog.datenwerke.net/2013/06/addi … bases.html

Vertica is even easier to do, as it does not require special treatment for LIMIT and OFFSET.
I wrote down what you need to do in our blog:
http://blog.datenwerke.net/2013/07/add- … erver.html

Let me know, if it works or if you need additional help in setting things up.

Cheers,
Thorsten

Slach

Member

Registered: 2013-07-28

Re: Need Vertica CE jdbc driver support

i don't understand
where is fileserver/bin directory?
i need install groovy separately for run http://www2.datenwerke.net/files/blog/2 … ort.groovy ?

Thorsten J. Krause

Guest

Re: Need Vertica CE jdbc driver support

Hi,

sorry I probably should have explained better.
The directory mentioned is not a directory somewhere on your disk, but rather a location in ReportServers internal fileserver module (stored in the database).

You access it via ReportServers web interface.

(If the directory does not yet exist, you might have to create it)

Cheers,
Thorsten

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Need Vertica CE jdbc driver support

Hi Slach,

to give you a heads up. We have just released ReportServer 2.1 which includes a workaround for older jdbc drivers.
Let us know if you need further help.

Cheers
Arno