Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Ms access to oracle 10

  1. #1
    Join Date
    Nov 2008
    Posts
    8

    Default Ms access to oracle 10

    We have a 3 step process....
    1 Access input which we can see the data
    2 execute SQL script which runs a very complect select statement (we took the one from access)
    3 output....

    We are not getting though step 2....
    Attached Files Attached Files

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

    Default

    You can define an ODBC connection to your access database and then treat it as a regular database.
    You can execute your query in a "Table Input" step.

    The alternative is that you rewrite the query to make use of Kettle components like "Filter Rows" etc.

  3. #3
    Join Date
    Dec 2009
    Posts
    332

    Default

    I notice you have three queries unioned together. It might help to debug the process by running each section separately.

    Are you working with a significant amount of data?

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.