ORCO datawarehousing
Customer
Technologies
The aim of this solution was to create a new datawarehouse for ORCO. This datawarehouse is based on MS SQL Server. The original task was to create specified structure of the database tables and to load them with data from three accounting systems, mainly with accounting transactions.
You will be able to imagine a complexity of the created datawarehouse if you look at next image (due to understandable reasons, a schema with readable items isn’t shown here):
During working on this task, new requirements have arisen:
-
development of attendance system;
-
possibility of reporting;
-
integration of the outputs from Axapta.
Last requirement is crucial because Axapta will become a main company accounting system.
[
Back to the list of case studies]