Hello,

Limesurvey is wonderful software. For analyses purposes, like dashboards, we would not like to query the operational database frequently. Instead, we would like to use ETL to extract new information in the operational Limesurvey database, transform the data into the traditional star schema, and load it into a datawarehouse. Frankly, we are looking for suggestions about how this can be best performed using open source software.

Is there anyone who ever dealt with such case?

Thanks!

Real example

Use API and export as STATA or R or …

All done via python script to update data if needed.

We run a weekly script for relevant surveys, resulting in an Excel file being sent to the email of the person doing analysis.

All done via R and the LimeSurvey API.

Oh,
I don't remind : usage of PowerShell to to update some Active directory part.

But i didn't touch to powershell