Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: SQL Server Question

  1. #1

    Default SQL Server Question

    Hi
    I want to be able to use SQL Server With Pentaho
    I dont see any documentation regarding that..Can anybody help me on that?
    I got it working by adding the jtds1.2.2.jar
    how stable is it?
    Is there anything i should be keeping in mind while using the SQL Server connection

  2. #2

    Default

    Folks are definitely using it, as with anything it depends largely on what you're doing. As usual, PDI and Reporting tend to be less sensitive to dialect issues than Analysis, as the Mondrian engine does some pretty heavy lifting in SQL generation.

    Some folks report success with the jTDS driver, some with the Microsoft driver. I would personally probably try the Microsoft one first unless there was a compelling reason to use the other or you saw a significant performance difference.

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.