I am quite confused with the installation of Jasper report server for my database, my system use a Redis api and I wondered if it is possible to connect the Redis data source into Jasper report server or in other words, deploy Jasper report server on top of the RedisDB, I know there is no official Redis connector, but I actually found a JDBC-redis (which may be out of date) on the web and tried to connect it to Jasperreports server, but it printed out connectivity Errors.
Could anyone help me with this please?? Thanks everyone for read or reply to my question.
RedisDB is not something that would work for the repository DB, so deploying the server "on top" of RedisDB wouldn't likely work.
If what you are looking for is to report of of the data that is stored in the RedisDB, then all you need is a JDBC driver for redis that is SQL92/JDBC2.1 compliant. If you have this, you would:
- Deploy JasperReports Server with the regular repository database (PostgreSQL)
- Add the Redis JDBC driver to the classpath (.../WEB-INF/lib), and then
- Login to the server and create a JDBC datasource with the appropriate connection string for your RedisDB
Once you have done this, then creating a report using that datasource should be just like creating one with any other JDBC datasource. Again, the JDBC driver must meet the SQL92/JDBC2.1 standards to really work right.