如何使用postgresql数据库在Pentaho中执行sql脚本？
我在我的 ETL 工具项目中使用 Pentaho。我可以详细说明如何进行 ff.
- 我想要一个存储我们每天运行的所有 sql 脚本的存储库。
- 我想学习如何安排这个例程。
每天我们在 postgres 数据库中运行不同的查询，我们希望它能够自动化。你能帮我这个吗？我将不胜感激您的立即回复。谢谢。
锡，
Im using Pentaho for my ETL tool project. Can I have a detailed step by step on how to for the ff.
- I want to have a repository for all the sql scripts we are running everyday.
- I want to learn how to schedule this routine.
Daily we ran different queries in postgres database and we want it to automate. Can you help me this. I would appreciate your immediate response. Thank you.
tin,
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我建议此时退一步阅读手册。如果你是认真的，稍后你会很高兴读到它。一旦您熟悉了该工具，您可能会想阅读这本优秀书籍 也是如此。这样做，你所有的问题都会得到解答，承诺。您还可以访问非官方 IRC 频道。社区中总是有优秀的人员和一些核心开发人员可以为您提供帮助。这是 irc.freenode.net 上的频道 ##pentaho。
没有快速的方法来正确使用这些工具。它们很强大，可以帮助您做很多事情，但它们很复杂，您必须弄清楚如何利用它们来发挥自己的优势，而这需要经验。相信我，我在 Pentaho 工作。 =)
I suggest taking a step back and reading the manual at this point. If you're serious about this, later on you'll be happy you have read it. Once you feel comfortable with the tool, you might want to read this excellent book as well. Do that and all your questions will be answered, promised. You can also drop by the unofficial IRC channel. There are always fine folks from the community and some core developers available to help you. It's channel ##pentaho on irc.freenode.net.
There are no quick way to properly use these tools. They are powerful and will help you do a lot, but they are complex and you will have to figure out how to use them to your advantage and that requires experience. Trust me, I work at Pentaho. =)