Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Oracle User Schemas

  1. #1
    Join Date
    May 2007
    Posts
    3

    Default Oracle User Schemas

    Do you have any ideas how change oracle schemas in kettle from one user connection to access same tables from other schemas like this in oracle: alter session set current_schema = <other shema>

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    If you want this type of stuff executed when an Oracle connection is opened, I bet you could use the SQL tab in the database dialog.

  3. #3
    Join Date
    May 2007
    Posts
    3

    Thumbs up

    Thanks, it works, but is it possible add variable into connection sql tab? Main problem is in many same tables in own schemas. We need transform all of them with one connection and dynamics variables.

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    It is not yet possible. Please add a feature request for this. It should be easy to implement.

  5. #5
    Join Date
    Sep 2011
    Posts
    12

    Default

    Hi Matt Casters,
    I'm using the PDI 4.2.1 CE and I have need run the "alter session" command with a variable value. Is it not possible yet?

    thanks
    Gibon

  6. #6
    Join Date
    Sep 2011
    Posts
    12

    Default

    Sorry Matt, please, disconsider this post. I made a mistake on my tests, It is working fine now, only not show the variable picture on right side box.

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.