Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How can I get SQL for whole transformation.

  1. #1

    Default How can I get SQL for whole transformation.

    I am trying to get the sql statements for the whole process so that I can use the sql statements without having to run pan. Is there a way I can get the SQL statements for a transformation or a job? I am kind of lost when looking at the source codes and need to figure out if there is a class definition that holds sql parsed from the xml file.

    Need something like xml to sql converter if any..

    Thanks

  2. #2
    Join Date
    Feb 2008
    Posts
    107

    Default

    Try changing the logging level to "Row-level" when executing the job or transformation. You should see the SQL (along with _lots_ of debugging info) in the Execution Results "Logging" section.

    Cheers,
    Paul
    Last edited by buachaille; 09-27-2010 at 09:03 AM.

  3. #3
    Join Date
    Apr 2008
    Posts
    4,690

    Default

    Note that PDI can be doing more than just running a series of SQL statements, so the statements will not necessarily help you.

    for example if you just get the SQL statements, you might end up with:
    SELECT * FROM table1
    INSERT value5 INTO table2

    But unless you know the transform, there could be group by steps, or calculators, or many other things that change what those values are. There is also the possibility that one or the other SQL statement is looping - which also changes the process.

    In short, runnning pan is likely your easiest solution.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

Tags for this Thread

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.