Client:
Retail
Country:
Europe
Employment:
2000
Number of databases:
400
Database Name:
Oracle, SQL Server
Starting situation
A renowned chain of automotive parts stores, conducting its sales activity in Poland and in 16 European countries, has decided to implementation of the project of the central reporting system. The system was to serve the entire organization and a network of business partners.
Business Expectations
- Providing up-to-date information on current sales, stock levels and other business data (customer data, delivery addresses, etc.).
- Data available centrally, updated in real time.
problem
- Delay in reporting key business data, such as sales or stock (data update every 24 hours).
- Lack of consistency of reports from individual markets.
- Limited ability to make replacements in reports — need to coordinate implementation with all local IT departments.
Architecture
- Data processed at night, in each of the 16 local databases.
- Transferring the data extract to a central location.
- Each of the markets served by a locally hosted ERP system.
