ReportServer Forum

xeijin

Member

Registered: 2017-12-18

ReportServer & SQLite?

Hello,

I want to run a local instance of ReportServer (just for myself, so can be considered 'non-production'), but I don't want the overhead and maintenance of having to install a database server like MySQL or Postgres just to run the application.

I'd prefer to use SQLite if possible, after some research it appears:

1. There is a Hibernate dialect for SQLite: https://github.com/gwenn/sqlite-dialect
2. There is also a JDBC driver: https://github.com/xerial/sqlite-jdbc

However I'm unsure on how to:

a. Add the hibernate dialect to ReportServer
b. Create & setup the necessary tables (since there is obviously no ddl script for SQLite)

Could anyone point me in the right direction?

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: ReportServer & SQLite?

Hi xeijin,

please take a look to the tutorial on adding support for other databases here: https://reportserver.net/blog/2013/06/2 … -firebird/
In the tutorial you can see the example of firebird. It should work analogously for SQLite.

If it works for you, we would be happy if you send us the files/scripts you use, so we may consider adding official support for SQLite in a future reportserver version.

Regards,
Eduardo

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: ReportServer & SQLite?

Hi xeijin,

we are working on adding SQLite support, but this only will be for adding datasources. For the reportserver metadata, you will still have to install a db.
An alternative for this is just to install the bitnami package, where you just have to click "next next next" and everything will be installed and configured for you. It is really easy to install and you don't have to configure anything. Check our bitnami downloads here: (installer packages): https://reportserver.net/en/download/

Regards,
Eduardo

Martin

Member

Registered: 2020-08-19

Re: ReportServer & SQLite?

Hello,

same problem here.

I have a SQLite database with installed SQLite ODBC driver on Windows 10.
Using JasperReports Studio, I can create Jasper Reports (jxml) connecting the SQLite db via JDBC (Driver: org.sqlite.JDBC, URL: jdbc:sqlite:C:\DATA\DB\SQLite).

Now I installed ReportServer via bitnami installer and the demo reports works fine in the installed ReportServer.
But Ican't see any way to create a SQLite Datasource in the ReportServer.
The Solution "adding support for other databases..." in this thread is not working on any step.

After searching the web for some hours - I put my question now here. Any help possible?

Many Thanks
Martin

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: ReportServer & SQLite?

Hi Martin,

The Solution "adding support for other databases..." in this thread is not working on any step.

what exactly is not working ?

Regards,
Eduardo

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: ReportServer & SQLite?

Hi Martin and xeijin,

pls note that the next ReportServer 4.2.0 will probably have support for SQLite datasources. Note that this does not mean you will be able to install ReportServer on SQLite, but you will be able to create/query/edit SQLite datasources.

Regards,
Eduardo

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: ReportServer & SQLite?

Hi Martin and xeijin,

pls note that ReportServer 4.2.0 is released where SQLite datasources are supported. Note that this does not mean you will be able to install ReportServer on SQLite, but you will be able to create/query/edit SQLite datasources.

Release notes: https://reportserver.net/releasenotes/R … tml#sqlite

Regards,
Eduardo