Table-driven and data-driven method, and computer-implemented apparatus and usable program code for data integration system for heterogeneous data sources dependent upon the table-driven and data-driven method

摘要

A table-driven and data-driven method to map multiple enterprise systems' databases and a data integration system that uses this table-driven and data-driven method to supply the logic and business rules contained within the tables of its processing database to fully integrate any two heterogeneous data sources. The system can also use the table-driven and data-driven method to integrate multiple data sources to multiple other data sources. The system can detect any changed data structures in the data sources and automatically update the import and integration processes to accommodate those changes. The computer-implemented apparatus and usable program code also provides a graphical user interface to quickly create the data for the table-driven and data-driven method for a specific heterogeneous data source and destination pairing.