This is one of 4343 IT projects that we have successfully completed with our customers.How can we support you?
ETL Interface System for Product Suppliers
Project duration: 1 year, 5 months
Brief description
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.
Overview
- Industries pharmaceutical industry
- Specialist tasks procurement, software development, supplier management
- DV tasks customised software new development
- System environment Client/Server, PC systems/networks
- Procedure model customer standard
- Databases MS SQL Server
- Development/ test tools MS Visual Studio .NET
Project period01.08.2016 - 31.12.2017
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
Service
Industries
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
