如何将 LimeSurvey 与 Pentaho 集成？
我正在尝试将 LimeSurvey（一个用于开发和收集在线调查回复的 PHP Web 应用程序）与 Pentaho（ETL、商业智能、报告等）集成，但我遇到了一些严重的问题。
LimeSurvey 自动生成一个新表，用于存储在我的应用程序中创建的每个调查的答案，并且我需要使用 Pentaho 根据调查答案动态生成报告。
我如何处理具有未知数量的表作为 Pentaho 的数据源的问题，其中表的名称及其字段的名称都是由 LimeSurvey 自动生成的？我可以在 Pentaho 中使用哪些策略、想法或机制从这样一个不可预测的数据源加载信息，并从中生成报告？
或者，是否有办法告诉 LimeSurvey 将所有调查答案存储在一个表中，并且可以轻松地从 Pentaho 等商业智能工具中提取？
提前致谢！
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!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
如果您知道或可以预测 LimeSurvey 如何命名表以及如何连接它们的架构，那么您可以使用“高级 SQL 数据源”以及表达式来计算查询。它可能是一个 BeanShell 或 Bean-Scripting-Host 表达式，因为据我所知，早期弄乱这些表会很复杂。
如果您想了解有关高级 SQL 数据源和计算查询的更多信息，请查看 Mike Tarrallo 的“Guided Adhoc”记录，网址为
http://wiki.pentaho.com/display/COM/April+7%2C +2010+-+Michael+Tarallo+-+引导+Adhoc+报告+使用+BI+服务器
If you know or can predict the schema on how LimeSurvey names the tables and how to join them, then you could use a "Advanced SQL Datasource" along with a expression to compute the query. It will probably be a BeanShell or Bean-Scripting-Host expression, as AFAIK messing with those tables will be complex early on.
If you want to know more about the Advanced SQL datasource and calculated queries, have a look at Mike Tarrallo's "Guided Adhoc" recording at
http://wiki.pentaho.com/display/COM/April+7%2C+2010+-+Michael+Tarallo+-+Guided+Adhoc+reporting+using+the+BI+Server
正确：将 LimeSurvey 打造成形状，每个调查一张表，来吧。虽然有点超出范围。
可行：创建一个包含所有表的视图 + Pentaho 可以使用的“survey-id”列。重新创建调查添加/删除，祈祷 Limesurvey 中有挂钩可以轻松添加这些 SQL 语句。
Proper: Whip LimeSurvey into shape, a table per survey, come on. A little bit out of scope though.
Workable: Create a view with all tables + a column for the 'survey-id' which Pentaho can use. Recreate on survey adding / removing, pray there are hooks in Limesurvey to easily add those SQL statements.