This is one of 4620 IT projects that we have successfully completed with our customers.

How can we support you?

Weißes Quadrat mit umrandeten Seiten rechts oben

EDI data import of customer sales as bonus calculation basis

Project duration: 2 months

Brief description

To support sales, sales key figures that are delivered as EDI files from different customers (retail) are loaded into a data warehouse system and prepared. The data is made available to sales employees on the intranet as a bonus basis. PTA is responsible for the coordination and implementation of the ETL process (ETL = Extract, Transform and Load).

Supplement

The system is based on an SSIS package (SQL Server Integration Services), which loads different data and structures into an MS SQL database. The package is also hosted in the database and executed daily via a job. The system records several thousand data per day and is additionally enriched with internal data from the ERP system. A history of the data is guaranteed up to 5 years into the past. PTA designs and develops the ETL process for transaction-safe processing of import data.

Subject description

The sold-to party's sales department wants to aggregate and evaluate key sales figures for major customers (retailers, department stores) in various ways and as required. These key figures are necessary firstly to calculate the bonus payments correctly and secondly to prepare adequately for sales talks.

Overview

Project period28.03.2018 - 31.05.2018

Have we sparked your interest?

Portrait Herr Knudsen, Mann im Anzug

Ole Knudsen

Key Account Manager

Jetzt Kontakt aufnehmen

Zum Umgang mit den hier erhobenen Daten informieren wir in unserer Datenschutzerklärung.

Contact now

We provide information on the handling of the data collected here in our privacy policy.

Download file

We provide information on the handling of the data collected here in our privacy policy.