Need Vertica CE jdbc driver support

ReportServer (EN)
1

Hello ReportServer development team :wink:
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/

2

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/adding-support-for-additional-databases.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-vertica-support-to-reportserver.html

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

Cheers,
Thorsten

3

i don’t understand
where is fileserver/bin directory?
i need install groovy separately for run http://www2.datenwerke.net/files/blog/2013/vertica/AddVerticaSupport.groovy ?

4

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

5

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