Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: Run kettle transformation in CDE

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Mar 2017
    Posts
    17

    Default Run kettle transformation in CDE

    Hi all,

    I've searched a lot into documentation and web, found nothing

    We have a mysql kettle repository. I'd like to run transformations in a cde dashboard.

    Which is the best practise to run kettle transformations (saved in mysql repository) in cde?

    kettle over kettleTransFromFile works as well but I'd like to work in synchronized environment...

    Thanks!

    Alex

  2. #2
    Join Date
    Nov 2011
    Posts
    1,229

    Default

    kettle over kettleFransFromFile is the way to run kettle on CDE. What do you mean you want to work in synchronized environment? You want the call to be synchronous, is that it?
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

  3. #3
    Join Date
    Mar 2017
    Posts
    17

    Default

    Quote Originally Posted by pamval View Post
    kettle over kettleFransFromFile is the way to run kettle on CDE. What do you mean you want to work in synchronized environment? You want the call to be synchronous, is that it?
    Thank you!

    I mean that I want to use transformations stored in mysql repository.

    Just as information about my environment:
    - kettle repository in mysql database.
    - pentaho server in "default" mode (hypersonic?).
    - settings.xml already modified in pentaho-solutions/system/kettle.

    As I understand, to use kettleFransFromFile I have to store .ktr files in pentaho server.
    In this way, I have to:
    - save transformation from spoon mysql repository to a local path;
    - upload .ktr to pentaho server;
    - use kettleFransFromFile.

    I don't want to use such steps...

    I thought that there is a way to point directly to kettle repository transformation...

    Maybe there is something I miss...

    Thank you...

    Alex

  4. #4
    Join Date
    Nov 2011
    Posts
    1,229

    Default

    yes, you have to store your .ktr files in the pentaho server repository. But you can use the same repository for kettle and pentaho server. Why don't you just point your server at that mysql and use that as your repository for both tools?
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

  5. #5
    Join Date
    Mar 2017
    Posts
    17

    Default

    Quote Originally Posted by pamval View Post
    yes, you have to store your .ktr files in the pentaho server repository. But you can use the same repository for kettle and pentaho server. Why don't you just point your server at that mysql and use that as your repository for both tools?
    This could be the idea.

    Do you mean to follow this link? https://help.pentaho.com/Documentati...itory_database

    Thanks

    Alex

    EDIT: ok, I followed instructions and pointed kettle repository to jackrabbit db. How can I find my transformations? Thanks
    Last edited by anietorp; 07-19-2017 at 12:10 PM.

  6. #6
    Join Date
    Nov 2011
    Posts
    1,229

    Default

    In order to find it you first need to save it there, I guess. When you're saving the ktr to the repo you choose the folder where to store it.
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

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.