Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Extend predefined flow by customers?

  1. #1
    Join Date
    Sep 2008
    Posts
    1

    Question Extend predefined flow by customers?

    Hi all,

    We are considering using ETL for a new project we plan.
    I'm currently trying to understand what I can (or can't) do with PDI.
    I've gone over most of the documentation and played with cocoon a bit too.
    I still have a few questions I hope someone can help with.

    We plan to provide to our customers a predefined job which will be built from these steps:
    1. Read data from Excel file in known format.
    2. transformations
    3. Load the data to MySQL

    It is required that customers will be able to customize/extend our tool by writing their own readers/tranformations.
    They might have input files with slightly different formats, it might have different columns or will require preliminary transformation etc.

    My question is can I give them this ability with PDI?
    Do they need to write Java for that? can they do this with any scriptng languages or just by mapping XML?

    Thanks a lot,
    Anat

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Anat, it's probably safer if you build a small application (in Java) that executes the transformation you describe.Doing the work is easy for Kettle. Configuring it "automagically" by a user with unknown competence is probably not that easy.Kettle is easy enough, but the GUI, Spoon is definitely only meant to be used by ETL designers, not any old user.

    Matt

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.