Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: PDI 7 and MS SQL

  1. #1
    Join Date
    Dec 2016
    Posts
    1

    Default PDI 7 and MS SQL

    hi Sanket Kelkar

    Thanks for your solution which help me fied the same issue listed above. But I got another issue said that PDI can not create database connection with MS SQLSERVER 2008. It suggets me install SQLSERVER Driver for class (jar). I do not know how to to it and what I need to open big eye with it? Can you help me ? Many thanks!

    My PDI env:
    PDI: ce 7.0
    JDK: 1.8 above
    JRE: 1.8 above
    OS: Win7-64bit

  2. #2
    Join Date
    Nov 2016
    Posts
    25

    Default

    Hi Simonlu,

    It is a very common error while connecting to a database from PDI. It needs respective database's jdbc driver. Now download 'sqljdbc4-2.0.jar' from internet and copy it under <Your Location>\data-integration\lib\
    Restart spoon and you are done!
    TIA,
    Sanket Kelkar.

    PDI CE 6.1
    Oracle 11g
    Windows Server 2012

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.