Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to connect PDI with MS SQL Server 2016

  1. #1
    Join Date
    Dec 2016
    Posts
    3

    Default How to connect PDI with MS SQL Server 2016

    Step1: MS SQL Server
    ServerName: MINK-NB
    Authen username: sa password: mink

    Step2: PDI
    2.1 I download sqljdbc_6.0 from microsoft and copy sqljdbc.jar / sqljdbc4.jar / sqljdbc41.jar / sqljdbc42.jar to path pdi-ce-7.0.0.0-25\data-integration\lib already.
    2.2 I create connection in PDI.
    Connection Type: MS SQL Server Access: Native(JDBC)
    Hostname: localhost << I'm not sure
    Database name: MyDB
    Instance name: MINK-NB (ServerName from Step1)
    Username: sa
    Password: mink

    But I can't working that it show .... How can I do?

    Error connecting to database [con] rg.pentaho.di.core.exception.KettleDatabaseException:
    Error occurred while trying to connect to the database

    Driver class 'net.sourceforge.jtds.jdbc.Driver' could not be found, make sure the 'MS SQL Server' driver (jar file) is installed.
    net.sourceforge.jtds.jdbc.Driver


    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occurred while trying to connect to the database

    Driver class 'net.sourceforge.jtds.jdbc.Driver' could not be found, make sure the 'MS SQL Server' driver (jar file) is installed.
    net.sourceforge.jtds.jdbc.Driver

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    You are using the MS SQL Server connection.
    See
    Driver class 'net.sourceforge.jtds.jdbc.Driver' could not be found, make sure the 'MS SQL Server' driver (jar file) is installed.
    net.sourceforge.jtds.jdbc.Driver
    Then you need to have the jtds.jar driver. You can download this file from https://sourceforge.net/projects/jtds/files/
    When you whant to use the sqljdbc then you need to use the MS SQL Server (Native) connection

  3. #3
    Join Date
    Sep 2011
    Posts
    3

    Default

    You need download driver jdbdc and install it in your installation directory in the folder ../biserver-ce/tomcat/lib.
    I'll hope help you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.