Integration with Jasper/ Pentaho

More
2 years 10 months ago #115796 by Rexyboy
Rexyboy created the topic: Integration with Jasper/ Pentaho
Hi,
I wonder if anyone can give me some pointers on integrating Jasper or Pentaho reporting into the back end of Limesurvey. I have done quite a bit of searching on the subject and can see similar questions in the past but am not significantly advanced.

I understand that one of the difficulties is the 'dynamic' naming of tables and fields that can create some challenges in directly pointing the reporting engine to the LS database.

The surveys that I use are simple and linear (i.e. approx 100 questions that get answered by all with multi choice responses).

If someone has been down this path can you head me i the right direction? Do I need to create scripts to translate the tables, use the RC2 API to query the db to create new tables or can I point one of these engines directly to the LS db.

I should say that I need this to be automated and cannot rely on manual exporting of data (e.g. csv).

Any help and pointers would be most appreciated.

Thanks in advance.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!