TECHNICAL FIELD

The present invention relates to the field of data management and, more particularly to, electronic methods and complex processing systems for migrating source data from a source business system (e.g., Enterprise Resource Planning (ERP) systems) to a target business system (e.g., Oracle Cloud Applications).

BACKGROUND

Companies may need to migrate data from an existing business system (such as, Enterprise Resource Planning (ERP), Financial System, Human Resource Information System (HRIS)) to a new or updated business system. The company administrators need to perform migration of a tremendous amount of data (items, customers, suppliers, account balances, personnel, etc.) from legacy business systems to the new business system. The companies often choose to clean or reorganize the business data at the time of migration. Sometimes, the business data of the legacy business system may include unwanted errors in it. As the starting point for every company is different (different prior systems, different data structures, etc.), the current approach is manual and bespoke for each company. These approaches require mapping of each source to a destination and building custom scripts or programs for each data migration. Further, the business data in the legacy business systems never exactly match the fields, elements, formats, etc. of the new business system, therefore, the business data must be mapped, transformed, and manipulated to be fed into the new business system.

Therefore, there is a need for techniques to overcome one or more limitations stated above in addition to providing other technical advantages.

SUMMARY

Various embodiments of the present disclosure provide methods and systems for migrating business data from a source business system to a target business system.

In an embodiment, a computer-implemented method is disclosed. The computer-implemented method performed by a server system includes receiving a request from a user device to migrate source data from a source business system to a target business system, and accessing source metadata associated with the source business system and target metadata associated with the target business system. The method includes generating one or more source staging tables based, at least in part, on the source metadata. The one or more source staging tables include information of a plurality of source columns that is to be mapped. The method includes creating mapping sets for mapping the source data to the target metadata and transforming the source data stored in the one or more source staging tables into a target data structure based, at least in part, on the target metadata. The method further includes loading, by the server system, a target staging table associated with the target business system based, at least in part, on the transforming step.

