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 4842 IT projects that we have successfully completed with our customers.How can we support you?
Migration of an ETL line to determine CO2 emissions in CEP logistics
Project duration: 2 months
Brief description
The goal of the project is the conversion of an ETL line (extraction, transformation, loading) to determine CO2 emissions on the basis of the Oracle Data Integrator and the PTV xServer (xRoute). The replacement of the old system considers the following aspects: Improvement of the accuracy of the CO2 emission calculation by using the HBEFA 3.1 standard and current vehicle profiles on the basis of the Euro 6 emission standard; encapsulation of the business logic in procedures; conversion to the asynchronous, RESTful API of the PTV xServer; runtime optimization of the ETL route by parallelization of the API requests.
Subject description
The Handbook Emission Factors for Road Transport (HBEFA) provides emission factors for all current vehicle categories (PC, LDV, HGV, urban buses, coaches and motor cycles), each divided into different categories, for a wide variety of traffic situations. Emission factors for all regulated and the most important non-regulated pollutants as well as fuel consumption and CO2 are included. (Source: http://www.hbefa.net/e/index.html)
IT project data
- Industries Logistics
- Specialist tasks business intelligence, data warehouse, environmental engineering, environmental protection, Retail logistics
- DP tasks Data Warehouse
- System environments Business Intelligence
- Procedure model iterative procedure
- Databases Oracle Data Integrator
- Development and test tool Aqua Data Studio
- Middleware and frameworks PTV xServer
Project period01.04.2018 - 31.05.2018
Customers who trust us
Have we sparked your interest ?
