Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Table Input and Schema in SQLServer

  1. #1

    Default Table Input and Schema in SQLServer

    Hi,
    I'd like to import tables from a Database (SQLServer) within different Schemas. I use the jdbc driver with integratedSecurity. The problem is, I can browse thrue the Schema to soemthing like Schema.Table. Then I have a select * from Schema.Table thats fine. But it produces an error while previewing and also in running (invalid object name Schema.Table). What is going wrong?
    Any Idea
    Thanks a lot
    Thoralf

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    First thing you should do is to use a standalone Java JDBC client (like SQuirreL) to verify your problem really is related to Kettle and Table-Input.
    So long, and thanks for all the fish.

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.