Match & Merge Data

Overview | Screen Shots | Performance | Match & Merge Data

UnityJDBC supports a unique set of features which allow the user to match data, find differences among sources, or determine the provenance of the data. This is useful when building comparison shopping sites or any site that needs to relate data from many sources.

In the example below, the user has integrated data from two employee tables in different databases. In the integrated result, they have decided to keep the id, name, and age from database named mydb. For the salary field, they asked the driver to find differences and track the source of the data. Note that the salary for Steve Batner is different in the two tables. The user or programmer can now determine how they want to handle this inconsistency.