Interface analysis and migration in the central order management system
Project duration: 10 months
Brief description
Analysis, adjustment and migration of interfaces for the exchange of data between the central order management system, to a client information system, SAP HR and SAP FI/CO/MM.
Supplement
The interfaces compare customer and order data, personal data, and invoice and payment information between the participating systems. DTS packages (future SSIS packages) form the basis for data exchange to the interfaces, and called StoredProcedures to the individual tasks of the DTS packages.
Subject description
The basis for the project is a version upgrade of the central order management system (OMS) Empire Time. Based on numerous structural changes in the database scheme and logical and functional changes within the database logic it is necessary to perform an analysis of all interfaces from the previous system to the OMS and from the OMS to SAP and to implement all required adjustments. As all SQL servers are to be implemented on SQL Server version 2012, all interfaces created as DTS packages must be migrated to SSIS packages.