ALEXS_vbulletin3_import18288
New Member
I'm trying to integrate LimeSurvey (a PHP web application to develop and collect responses to online surveys) with Pentaho (ETL, business intelligence, reporting, etc.), but I'm facing some serious problems.LimeSurvey automatically generates a new table for storing the answers of each survey created within my application, and I need to use Pentaho for dynamically generating reports from the answers of the surveys.How could I deal with the problem of having an unknown number of tables as data sources for Pentaho, where both the name of the tables and the names of its fields are generated automatically by LimeSurvey? What strategies, ideas or mechanisms could I use in Pentaho for loading information from such an unpredictable data source, and generating reports from it?Alternatively, is there a way to tell LimeSurvey to store all the survey answers in a single table, in a way that is easily extracted from a business intelligence tool such as Pentaho?Thanks in advance!