Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to migrate tables with foreign keys in Pentaho Kettle

  1. #1
    Join Date
    Apr 2012
    Posts
    1

    Default How to migrate tables with foreign keys in Pentaho Kettle

    I am trying to use Pentaho Keetle to do some data migration. I would like to create a transformation to accomplish the following:I have the following tables in the source:

    table 1
    id [PK]
    name varchar

    table 2
    id [PK]
    source_id [FK with table 1.id]
    state varchar

    I have the same structures in the destination server. Let's say i would like to migrate 10 rows from table 1 along with their relations from table 2 in the destination server.

    How would i do that with a Keetle transformation?
    Thanks

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

    Default

    You can make a transformation database transactional and populate both tables in the same transformation.

  3. #3
    Join Date
    Jul 2012
    Posts
    1

    Default is there no way in kettle to auto detect relationship between 2 tables.

    Quote Originally Posted by MattCasters View Post
    You can make a transformation database transactional and populate both tables in the same transformation.
    is there no way in kettle to auto detect relationship between 2 tables and import/export group data?

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.