Data Synchronization

Intellect 3.0 has data synchronization likely not found anywhere else. It's so good, it deserves its own page.

Data is stored in and needs to come from many sources in your organization; text files, work books, relational databases (Access, SQL Server, Oracle), historians, OPC and perhaps others.

This data is disconnected and needs to be synchronized, put onto some common basis so you can align materials, process conditions, quality results and other information for analysis.

Intellect has synchronization that includes:

JustMatch
Align rows where where there are exact matches in the two index fields being compared.

OneSided
Give all rows from the first data set, just matches on the 2nd data set.

AllFromBoth.
Interweave data sets, giving all rows with exact matches aligned (VERY POWERFUL, VERY GOOD, NORMAL DEFAULT).

AppendColumns
Just append the columns of both data sets (must have same number of rows).

The All from Both is a particularly useful and is the default method of synchronization that is not found elsewhere. It gives proper sequential alignment to your data, not missing any. Most databases JOINs use JustMatch and OneSided. You need more. We know. We've "been there" for 20 years.