Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Compare 2 tables, Insert differences

  1. #1
    Join Date
    Feb 2014
    Posts
    6

    Default Compare 2 tables, Insert differences

    Hello everyone,

    I am making a one-way integration between MSSQL and MySQL datasources. Issue is, the MSSQL datasource doesn't have proper Date information (so as to compare rows by Last Modified or Created Dates). Luckily, the MSSQL database table is purely additive, meaning that as time goes on, records that have been inserted will not be modified.

    What I'd like to do is compare a data stream (which originated from the MSSQL datasource), and a table in MySQL. I'd like to find records that DO exist in MSSQL, but DO NOT exist in MySQL, and then insert those records into MySQL.

    This seems like something that is pretty simple to do, but I'm having trouble figuring out how to just do a straight comparison between tables using the filter transformations. Any suggestions?

    Thanks for any help!

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

    Default

    There are two steps: Merge Rows and the Table Compare step. Probably you want Merge Rows.

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.