Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: PDI on linux, Spoon on Windows

  1. #1
    Join Date
    Aug 2013
    Posts
    3

    Default [Solved] PDI on linux, Spoon on Windows

    Hello,

    I've installed PDI/Kettle on a Linux machine (no graphical display allowed) in order to schedule jobs/transformations
    but I want to use "Spoon" graphic interface on my Windows desktop to do the ETL.
    I want to use database-repository (NOT file-repo).

    Is it possible?
    How can I do this?
    Last edited by vs06; 11-18-2013 at 02:13 PM. Reason: Solved

  2. #2
    Join Date
    Sep 2013
    Posts
    235

    Default

    You may consider to use linux machine as a repository (means database is installed on linux machine), and have a Carte instance (which is Jetty server that run Kettle transformations under the hood) installed on same linux machine.
    Then - you can install on Win machine Spoon only - and use this to create Jobs/trans (they are a xml files actually).
    Then - you will save your work in repository - (under the hood repository is apache vfs - so technically your xml jobs/trans will persists in a database, which you have choose to run repository, and since database is running on linux machine - they will be stored there).
    And then - if you want to run it form win Spoon on remote linux machine - you can run it on linux Carte (Jetty server) server as mentioned before.
    And if you want to see execution of them - you can choose remote execution from Spoon win client - pointing on remote slave server (Carte instance) on linux machine.

    Is this will be an option?

  3. #3
    Join Date
    Aug 2013
    Posts
    3

    Default

    I've just added the repositories.xml (in ~/.kettle) file from Windows to Linux.
    Then,
    ./kitchen.sh -rep=MyRepoName -user=RepoUser -pass=P4s$ -job=JobName

  4. #4

    Default

    Another option : Use
    - spoon as development tool on Windows system(s)
    - store transformations and jobs in a source code repository, e.g. svn
    - get trafos and jobs from svn repo into the linux system

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.