Pentaho Data Integration - Connection - SQL Server 2012 Cluster (#016)

To run Pentaho you need to install Java first. Required Java version can be found in the run batch or shell script. Both files, Spoon.bat and spoon.sh, are located in the main Pentaho folder.

The next step is selecting of a proper JDBC driver which is associated with SQL Server and Java version.
 

 

Download the native jdbc driver for the SQL Server 2012 from the Microsoft's website:

http://msdn.microsoft.com/en-US/sqlserver/aa937724.aspx

Download the installation file, i.e.: sqljdbc_4.0.2206.100_enu.exe, unpack and place the driver in the following directory:

\data-integration\libext\JDBC

 

Naming convention:

sql - SQL Server

jdbc - Java database connectivity

4.0 - type 4, suitable for Java EE 5 and 6 (1.5 and 1.6)
 

Information about the connection string can be found on one of the msdn's sites:

http://msdn.microsoft.com/en-us/library/ms378428.aspx

The "Database Connection" window should look in the following way:

 

The "Feature List" window will look in the following way:

 

 

Run the test.