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)