During 2017-2018 Vartas Oy provided Oral Hammaslääkärit with a Data Warehouse to serve the company’s growing business. The main idea was to break down old point-to-point integrations and offer uniform and semantic data for use in software, analytics and external integration. The result was a Data Warehouse that each day processes 100-200 million lines of data with the power from over 100 ETL-processes from four different sources(databases, cloud services, API interfaces). The whole system is fully automatic. Data is gathered, cleaned and saved in parallel processes during specified time frames. The Data Warehouse informs the programs and integrations when the data is ready for use. Automatic servicing takes care of the warehouses optimal working conditions. The process can be inspected from three different levels of dashboards regardless of time and place.
The project was made in collaboration with Vincit Oy. The architecture was planned together. Vartas was in charge of implementing the dashboards, databases, integration the inputs and a big part of the ETL-processes, leaving Vincit to handle the health data on a low level.
Oral Hammaslääkärit have integrated the Data Warehouse during 2018 to be a part of Dynamics CRM , QlikView and SBM.
Technologies: Microsoft SQL Server, Azure SQL, Integration Services, Reporting Services, Klipfolio, C#, SQL, Liquibase, PowerShell