Patent ID: 7747563

Claim:
A method of data migration and integration in an automated, computer-implemented system comprising the steps of: extracting the data from a named source by remote queries; mapping the data from the source to a destination by mapping inbound source fields from the source to outbound fields of the destination; providing supplemental transformations to inbound data for data renaming, null scrubbing and data polishing; filtering extraneous data that has accumulated during prior steps or that has originated from the source; compressing the data to consolidate any fragmented balances to provide a set table signature that provides a replica of the destination fact table format, data types and column order; validating data line by line to provide referential integrity of the inbound data flow against the named destination system; routing data that does not pass referential validation to a kickout area of the data process controller; comparing the inbound data flow to the data in the named destination to determine how to synchronize the data to limit it to certain fields; and deploying the data connection transformation process to the destination.