Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Comparing from 2 database

  1. #1

    Default Comparing from 2 database

    hi!
    i wanted to synchronise the 2 databases that i have.

    the first database is the transaction database where records will be added or deleted anytime.

    i would like the 2nd database to be able to maintain the same records as the first database after every update.

    the method i am thinking of is to use "filter rows" steps to compare the primary key of the 2 databases and if its not in 2nd database, delete the records in 2nd database using "execute SQL script".

    however, it dont seems to work.
    anyone has any idea whats steps can be use to achieve this?

    Thanks
    Choon Boon

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    There are better tools out there than PDI to "just" synchronize 2 databases. Haven't found any good one open source, but most of these run around a couple of hundred USDs.

    Regards,
    Sven

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.