如何在 Pentaho 报表设计器中连接到远程 MySQL 数据库?
我已经在我的笔记本电脑平台ubuntu 10.10中安装了pentaho报表设计器。我需要创建报告,但问题是如何连接其他服务器中而不是我的笔记本电脑中的 mysql 数据库映射。我已经尝试过研究,但我不明白是否有任何一步一步的方法来解决这个问题?
请帮助我这周急需的帮助。谢谢你!!!如果您能提供任何帮助,我将不胜感激。
I already installed pentaho report designer in my laptop platform ubuntu 10.10. I need to create report but the problem was how to connect the mysql database map in other server not in my laptop. I already tried researching but I cannot understand is there any step by step way on how to work on this?
Please help me badly needed this week. Thank you!!! I would appreciate any assistance you can give.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
对 Pentaho 不太了解,但您可能会发现 Pentaho 论坛是一个有用的地方。
http://forums.pentaho.com/showthread .php?58459-how-to-connect-to-database-MySQL
这可能会有所帮助
http://wiki.pentaho.com/display/COM/Designing+Reports+With+MySQL+and+JNDI
Don't really know anything about Pentaho, but you may find the Pentaho forum a useful place.
http://forums.pentaho.com/showthread.php?58459-how-to-connect-to-database-MySQL
This may help
http://wiki.pentaho.com/display/COM/Designing+Reports+With+MySQL+and+JNDI
最简单的解决方案是将数据库克隆到本地笔记本电脑上,并使用 JNDI 定义(对于 PRD,您可以将其放入 ~/.pentaho/simple-jndi/default.properties 中,并使用 Pentaho 管理控制台对双服务器进行配置) -只要 JNDI 源具有相同的名称,并指向具有相同架构的数据库,您的报告在部署它们时就应该可以正常工作。
戴夫.
The easiest solution is to clone the database locally to your laptop, and use JNDI definitions (which you can put in ~/.pentaho/simple-jndi/default.properties for PRD, and configure with Pentaho Administration Console for bi-server) - and as long as the JNDI sources have the same name, and point to databases with the same schema, your reports should work fine when you deploy them.
Dave.