Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Connection to MS SQL Express 2012 - my table does not show up

  1. #1
    Join Date
    Sep 2011
    Posts
    171

    Default Connection to MS SQL Express 2012 - my table does not show up

    Hello Everyone,

    I am connecting to MS SQL Express 2012 using JDBC (Native). In Database connection I specify the database which I would like to connect and test it successfully, however when I continue with Table output step the table I need does not show up. It displays bunch of system tables.

    I can clearly see and edit table when I log in through SQL Management Studio with the same account.

    Any suggestions?

    UPDATE: When I change Database to "System Databases" I get the same set of tables. Got to be something obvious.

    ANOTHER UPDATE: I tried PDI 5.0.1 and was successfully able to see my table, so I guess it is specific to PDI 4.4

    Regards,
    august_month
    Last edited by august_month; 01-04-2014 at 11:01 AM. Reason: New info

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.