Extraction of supplier data from SAP SLC , transformation and loading into the staging area of the Procurement Contact Finder.
Supplement
The application is the interface between the supplier data enriched in the SAP SLC system and the Procurement Contact Finder application. The extraction of the data takes place with the SAP adapter from Theobald Software integrated in the SQL Server Integration System (SSIS). The transformation of SLC data types to TSQL data types is performed in SSIS.
Subject description
In detail, the data are prepared in advance in the SLC and then the data load from the SLC via the LocalCreditorNumber. After loading into the staging area of the Procurement Contact Finder, the data is further processed using procedures. The interface is subject to the specifications of an operation support plan. The interface application is programmed and developed using MS Visual Studio & SSIS and the SQL Server Management Tool.