- Posts: 2
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Connect Limesurvey to datawarehouse for analyses
- dwight1976
- Topic Author
- Offline
- New Member
Less
More
5 months 4 weeks ago #251624
by dwight1976
Connect Limesurvey to datawarehouse for analyses was created by dwight1976
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!
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!
Please Log in to join the conversation.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
5 months 3 weeks ago #251654
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Connect Limesurvey to datawarehouse for analyses
Real example
Use API and export as STATA or R or …
All done via python script to update data if needed.
Use API and export as STATA or R or …
All done via python script to update data if needed.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Please Log in to join the conversation.
- tammo
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 967
- Thank you received: 220
5 months 3 weeks ago - 5 months 3 weeks ago #251686
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
Replied by tammo on topic Connect Limesurvey to datawarehouse for analyses
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.
All done via R and the LimeSurvey API.
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
Last edit: 5 months 3 weeks ago by tammo.
The following user(s) said Thank You: DenisChenu
Please Log in to join the conversation.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
5 months 3 weeks ago #251717
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Connect Limesurvey to datawarehouse for analyses
Oh,
I don't remind : usage of PowerShell to to update some Active directory part.
But i didn't touch to powershell
I don't remind : usage of PowerShell to to update some Active directory part.
But i didn't touch to powershell
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Please Log in to join the conversation.