AnsweredAssumed Answered

How to setup a SQL Server Datasource on Pentaho BI Server?

Question asked by Mirko Mozzilli on Dec 17, 2018
Latest reply on Dec 24, 2018 by Johan Hammink

I've just installed 8.2 pentaho server ce and I'd like to configure a Datasource that read data from my SQL Server Database.

I need to connect to the dbms using sql server integrated authentication, that I successfully used using pentaho Data Integration, but in this case I can't select an MS SQL Server (native) or an MS SQL Server because anyone of two doesn't exist.

I tried using a connection string like this jdbc:sqlserver://MYSQLSERVERNAME:1433;integratedSecurity=true;databaseName=MYDBNAME;

as connection string and com.microsoft.sqlserver.jdbc.SQLServerDriver as Custom Driver Class Name (I positioned mssql-jdbc-7.0.0.jre8.jar in C:\pentaho-server-ce-8.2.0.0-342\tomcat\lib) but I hadn't success.

Have I any other method to follow?

Outcomes