Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Example Data Migration

  1. #1
    Join Date
    Dec 2013
    Posts
    1

    Default Example Data Migration

    Hello...
    I was just wondering if anyone had an example of an ETL to move data between 2 databases.

    using the copy tables wizard I have created a Job to copy tables between Postgres and SQL Server successfully.
    However the generated job has a transformation per table processed in serial.


    What I would like to do is have it so the kettle script builds the list of tables at run time and a configurable number of trnasformations
    in parallel.

    Would anyone have an example of this please?


    Keep in mind I am a complete beginner with kettle and without an example I might have to resort to SSIS
    Last edited by Clarky; 12-17-2013 at 10:10 PM. Reason: removed part of question I solved mysel

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.