Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: Run kettle transformation in CDE

  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

  7. #7
    Join Date
    Mar 2017
    Posts
    17

    Default

    Quote Originally Posted by pamval View Post
    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.
    Mmmmm... there is something I miss...

    - I follow steps to migrate pentaho server to Mysql (I create a new server). Seems working.
    -- These steps create 3 db: jackrabbit, hibernate, quartz. I Guess jackrabbit is where pentaho server stores all files.

    Name:  1.png
Views: 480
Size:  10.8 KB

    - In Kettle I setup a new repository connection pointing to jackrabbit db.
    -- Previous steps added some tables to jackrabbit db... ok.

    Name:  2.png
Views: 472
Size:  30.9 KB

    - I created a test transformation ans saved it to root folder of repository

    Name:  3.jpg
Views: 468
Size:  18.8 KB


    The question is... how can I find my test transformation in bi server???

    Name:  4.jpg
Views: 473
Size:  11.1 KB

    Thanks for your help and patience!!!

  8. #8
    Join Date
    Mar 2017
    Posts
    17

    Default

    Ok, maybe I need holidays...

    I used to create repository using "other repository menu", skipping "get started" button... doh!!!

    Now I see pentaho server repository.

    Thank youuuuuu!!!!

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.