Integration of CAQ, PPS and PMT data into the data warehouse

By seamlessly connecting operational systems, jovoco ensures consistent data models, reliable KPIs and efficient BI processes.

Customer

Customer benefits

Technology stack

"The collaboration with jovoco was a complete success! Thanks to the professional and targeted support, our customer's data warehouse has been equipped with a powerful and flexible solution that now enables up-to-date analyses and detailed reporting. jovoco has taken data management and reporting to a new level."

Marcel Dietz

Senior Solution Architect & Teamlead IT Solutions, Novazoon GmbH

Challenges of the customer

Novazoon GmbH’s customer management needed key performance indicators (KPIs) that are consistent across systems and can be evaluated centrally. For this purpose, several source systems should be integrated into the data warehouse, the data refined and modeled in order to use uniform and cross-system reporting. The company divisions and systems to be integrated were Quality Management with the Computer-Aided Quality Assurance System (CAQ), Production Planning with the Production Planning System (PPS) and Controlling and Project Management Office with the Project Management Tool (PMT).

Our approach

The deep integration of the Power Platform with SharePoint allows simple and structured access to data in SharePoint. A custom connector is used to forward the data prepared for the mobile layout to the social intranet. By incorporating Power BI, it was also possible to display complex SharePoint functionalities such as linking pages (including authorization management, e.g. blacklists of links) completely within the social intranet. This means that employees no longer have to leave the app.

Requirements gathering and analysis

At the beginning of the project, a detailed functional and technical analysis of the requirements was carried out. The metric definitions were specified and the relevant data sources identified. Workshops with the project team helped to determine the objectives and define the necessary process adjustments in the data maintenance of the operational systems.

Integration of CAQ, PPS and PMT data

The data from the various systems was integrated using SQL scripts and OData interfaces, which transferred the data to the data warehouse. The CAQ data was integrated into the data warehouse from an MS SQL Server database, the PMT data via OData interfaces and the PPS data via an ODBC connection.

Data modeling and ETL

The data was harmonized and optimized in the various stages of the data warehouse. The data modeling was carried out in Data Vault Design to ensure a future-proof solution. ETL transformations were performed by T-SQL, and the data was provided for reporting in data mart views and SSAS.

Testing and optimization

Before the final rollout, a test phase was carried out to ensure the highest quality and user-friendliness. In addition to functionality, this included availability and performance criteria. Optimizations were made based on the feedback. The handover took place via training courses and with training documents for the BI, support and DWH teams.

Results for the customer

New data records are integrated daily and prepared for BI analyses

0 .000+

Regular users from the areas of QM, production and controlling

0 +

Further results:

Do you have a specific project in mind?

Your decision would be the same as that of renowned companies:

Similar case studies

Case studies Switzerland, Data analytics, Process automation

Central event and survey platform: automated processes, live data and maximum efficiency

Inconsistent tools, manual exports and limited survey functions slow companies down. With an integrated event and survey platform, jovoco creates automated workflows, flexible logics and real-time data for more efficient event management.

Case studies Switzerland, Data analytics

Centralized logging with Kafka – transparency, efficiency and fewer outages

Distributed log files delay troubleshooting and increase downtime. With a central logging system based on Apache Kafka, jovoco creates transparency, accelerates analyses and reduces development and operating costs.

Case studies Karlsruhe, Process automation

Digital tendering platform with Microsoft 365 – automated processes for secure contract awards

Optimization of tendering processes with an individually developed solution based on SharePoint, Power Automate and Power Apps - secure, transparent and fully integrated into Microsoft 365.