Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: API usage

  1. #1
    Join Date
    Sep 2007
    Posts
    19

    Default API usage

    Hi,

    Could anybody provide some workflow of function calls in using API to implement transformation?
    E.g., from Access to Postgres....

    In addition, when I connect to Access database,
    some error messages appear as follows:

    be.ibridge.kettle.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
    Unable to find Kettle Variables for thread [main]

    What does the Kettle Variables mean?

    Hannah

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Kettle variables is the stuff that fills in ${}/%%.

    To implement Kettle in Java either:
    1) Look at the source code of pan, strip the code from there. This will allow you to run transformations stored in files e.g.
    2) Look at the unit testcases under the test directory on how to build transformations completely with java

    1) is recommended as you would still be able to maintain the transformations with spoon. But 2) also works

    Regards,
    Sven

  3. #3
    Join Date
    Sep 2007
    Posts
    19

    Default

    Thank you, Sven.
    I tried to implement some transformation task using function calls. It seems that I must spend some time to study the codes and procedure to call functions.

    If there is some manual on workflow of function callings, it would be great.
    (It seems its like a day dream as well...)

    Hannah

    Quote Originally Posted by sboden View Post
    Kettle variables is the stuff that fills in ${}/%%.

    To implement Kettle in Java either:
    1) Look at the source code of pan, strip the code from there. This will allow you to run transformations stored in files e.g.
    2) Look at the unit testcases under the test directory on how to build transformations completely with java

    1) is recommended as you would still be able to maintain the transformations with spoon. But 2) also works

    Regards,
    Sven

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    No manual on "workflow of function calls"... study the code

    Regards,
    Sven

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.