This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4822 IT projects that we have successfully completed with our customers.How can we support you?
Support and maintenance of the ETL Interface System for Inventory Optimization
Project duration: 3 years
Brief description
Extraction of extensive warehouse data from SAP BI and transformation and loading into the Supply Chain Management Staging Area of the Voyager Inventory Optimization Platform.
Supplement
The application is the interface between the warehouse data enriched in the BI system and the Inventory Optimization Platform from Logility. Data extraction is performed using the Xtract IS adapter from Theobald Software integrated in the SQL Server Integration System (SSIS). The transformation of BI data types to TSQL data types is performed in SSIS.
Subject description
The application is the interface between the warehouse data enriched in the BI system and the Inventory Optimization Platform from Logility. Data extraction is performed using the Xtract IS adapter from Theobald Software integrated in the SQL Server Integration System (SSIS). The transformation of BI data types to TSQL data types is performed in SSIS.
IT project data
- Industries pharmaceutical industry
- Specialist tasks ALM, ETL, inventory management, inventory planning, Support
- DP tasks customised software support
- System environments Business Intelligence, Client/Server, PC systems/networks
- Procedure model customer standard
- Databases MS SQL Server
- Middleware and frameworks MS SQL Server Integration Services (SSIS), Xtract IS
Project period01.01.2018 - 31.12.2020
Customers who trust us
