在 SQL Server 2005 中使用 Pentaho 社区版 [英] Using Pentaho Community Edition with SQL Server 2005

问题描述

我曾多次尝试将 Pentaho CE 连接到 SQL Server 2005 中的数据库，但没有成功.我首先从安装了 Pentaho CE 的 Ubuntu 中执行此操作.似乎无法连接到 SQL Server.然后我在同一台机器上安装了 Pentaho CE 和 SQL Server 并遵循 官方指南设置，失败.

I have tried many time to connect Pentaho CE to database in SQL Server 2005 but not successful. I first did this from Ubuntu on which Pentaho CE installed. It seems impossible to connect to SQL Server. I then installed Pentaho CE on the same machine with SQL Server and was following official guide to set it, failed.

步骤是:

• 下载 MS JDBC 驱动程序(版本 4)并将其放置在 pentaho\bi-server\tomcat\webapps\pentaho\WEB-INF\lib 和 pentaho\administration-console\jdbc 分别
• 之后，我去 Pentaho 控制台创建一个新的数据源并按照手册中的说明设置所有内容.

但是总是提示没有合适的驱动程序..."

However, it always prompts that "No suitable driver for ..."

有没有人遇到过这个问题或者可以提供解决方案?提前致谢.

Does anybody meet this issue or could give a solution? Thanks in advance.

推荐答案

终于解决了.它并不那么神秘，并且不需要修改任何文件.有两个重要的事情:

Finally, I solved it. It's not so mystery, and don't need to modify any files. There are two important things:

首先，使用 jtds 驱动程序而不是 MS JDBC 驱动程序，虽然 MS JDBC 4 可以工作(但不是那么好，早期版本根本不适用于 Java 6 和更高版本).将驱动程序放在管理控制台和 biserver-ce 下的相应目录中.您可能会注意到新 Pentaho 版本中的目录与以前不同.它们应该看起来像:administration-console/jdbc/和 biserver-ce/tomcat/webapps/pentaho/WEB-INF/lin/

First, use jtds driver instead of MS JDBC drivers, although MS JDBC 4 is working (but not so good, the earlier version not working with Java 6 and later at all). Place the driver in corresponding directories beneath administration-console and biserver-ce. You may notice that the directories in the new Pentaho version are different from before. They should look like:administration-console/jdbc/ and biserver-ce/tomcat/webapps/pentaho/WEB-INF/lin/

其次，您必须在 URL 中提供实例类型.正确的 URL 类似于:jdbc:jtds:sqlserver://localhost:1433;instance=MSSQLSERVER;DatabaseName=test.MS SQL Server 的每个版本都有不同的 URL 格式，这非常棘手.你必须找到合适的.

Second, you have to provide the instance type in the URL. The correct URL looks like: jdbc:jtds:sqlserver://localhost:1433;instance=MSSQLSERVER;DatabaseName=test. It's very tricky that MS SQL Server has different URL format for each version. You have to find the right one.

还有一点是，(我认为)您必须在 MS SQL Server 2005 中启用 SQL Server 身份验证才能与之连接.

One more thing is that, (I think) you have to enable the SQL Server Authentication in MS SQL Server 2005 to connect with it.

这篇关于在 SQL Server 2005 中使用 Pentaho 社区版的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！