Data Import

Dynasys is daily refreshed from BW and SalesForce.

A global and unique process (common to all instances of one company) allows to manage files provided by those two applications. The goal is to :

• select or exclude some csv files
• make data compatible with our Unicode Standard
• import csv files in the Datahub (TEMP tables)
• force basic data in those tables
• apply defined controls to strategic data tables, if necessary revert to a previous snapshot of data

Read files

• "Files creation dt" check

(data providing by Global Sales multi-provider)

• "File to exclude" check

Reworkd data

Dynamic data corresponds to the flows (historical and actual data : shipped history, invoiced history, demand history, open order data...through BW interface

(data providing by Global Sales multi-provider)

For Dynamic data, import is at D+1 (around 10-11 am - CET)

Apply integrity controls

Dynamic data corresponds to the flows (historical and actual data : shipped history, invoiced history, demand history, open order data...through BW interface

(data providing by Global Sales multi-provider)

For Dynamic data, import is at D+1 (around 10-11 am - CET)