labs.DWH - Data Warehouse
Do you have a global overview of your heterogeneous and distributed data? The quality of data in a business can only be ensured if the data are consistent, transparent and centrally located. labs offers a data warehousing facility for the timely provision of reliable, up-to-date information. With a data model specially developed for SimCorp Dimension, the optimal data warehouse solution enables both internal and external data sources to be integrated. It is based on our multiple years of experience as a SimCorp Dimension user.
The convenient import functions allow all external data sources (e.g. flat files, SAP, access to other DBMS) to be integrated into labs. DWH. For ease of use, the solution boasts a web-based user interface. labs.DWH contains its own MS SQL Server management database as well as a flexible ETL engine that allows existing systems to be integrated rapidly into the data warehouse. This has the advantage that the solution can be adapted to meet customer requirements at little cost.
The solution includes automated and configurable workflows for all data transformation processes. All transformation processes are logged for subsequent tracking, while a portal enables convenient management.
Historisation is essential for every provider of financial services and is ensured by labs.DWH. Only the data that customers actually need for their decision processes are supplied – and in exactly the form required. labs.DWH also provides interfaces for reporting solutions. OLAP cubes can be generated from the data stock of the data warehouse.
The user interface and the data model can be adapted to the needs of the customer. A configurable application and data-based authorisation concept is available and can be tailored to suit the individual customer.
As specialist IT service providers, we offer the whole spectrum of experience required for the realisation of a data warehouse solution, all based on current and scalable technologies such as MS.NET and MS SQL Server. A one-stop shop – from analysis to delivery of the turnkey solution.
- Single source of truth
- Data harmonization
- Sign-off functionality
- Multi GAAP
- Multi Entity
- Data History
- Easy preparation of up-to-date reports and data extracts
- Configurable data transformation processes
- Standardisation of the workflow
- Easy adaption of the system to existing systems and processes
- Flexible data models
- Access control through application and data related authorisation model
- Technical and application specific documentation