Implementation of a Central Traceability System

Implementation of a Central Traceability System

Transparency and Quality Secured

FRÄNKISCHE Industrial Pipes: Effective traceability along the entire process chain

Complete traceability? Thanks to a modern Azure data platform, FIP combines production, quality and master data in real time. That means: better quality assurance, more efficient processes and more trust in the supply chain!

Quick Facts About the Project

Map pin icon

Location & Sector: Germany, Manufacturing

Building icon

Company size: Medium-sized business

Clock icon

Project duration: 13-18 months

Folder icon

Project type: Implementation of a central traceability system

cog icon

Technology: Microsoft Azure

About the client

Initial Situation & Challenges

Establishment of a central system for tracing the origins of components was of crucial importance to Fränkische Industrial Pipes (FIP). The aim was to record the production process from raw materials to delivery in order to meet increasing requirements for transparency and at the same time proactively ensure product quality. Such a system must continuously link master, process, and quality data to each individual product to create a digital representation of that product.

A key challenge for FIP initially was to further develop existing processes so that they enabled telemetry and quality data to be linked to products. In addition to the internal change process, this required a technologically flexible solution that could also be used to implement other use cases and be made available to internal as well as external stakeholders.

Four key challenges in data integration and traceability: dependence on multiple departments, global connection of factories to the cloud platform, technical interpretation of data, and insufficient master data quality. Represented with icons for network, globe, lightbulb, and three-star rating.

About FRÄNKISCHE Industrial Pipes

FRÄNKISCHE Industrial Pipes (FIP) develops and produces customer-oriented, innovative solutions in the fields of fluid management and protection components, charging and storage applications, as well as battery and thermal management for the automotive sector and industry. As a wholly owned subsidiary of the owner-managed FRÄNKISCHE Group, FIP is a globally active partner to renowned customers with locations in Africa, Asia, Europe, and North America. The company is headquartered in Königsberg, Lower Franconia, Germany. Spun off from FRÄNKISCHE Rohrwerke in 2008, the company employs around 4,400 people worldwide.

Solution

The aim of the portal solution was to ensure effective traceability and digitize conventional production as part of the process chain. To this end, the focus was not only on establishing a robust cloud architecture but also on digitizing the various production processes.

System architecture for a traceability solution at FRÄNKISCHE Industrial Pipes: Data from the factory—covering production, labeling, assembly, and quality inspection—is collected, standardized, and stored centrally in the Azure Cloud. The cloud architecture includes modules for telemetry processing, orchestration, monitoring, and data science, using sources such as ERP, MES, SCM, QA, IoT, and manual data input. The system enables full tracking and visibility across the production process.

A flexible and highly scalable edge and cloud architecture enabled the smooth integration of data into the various production processes. In the cloud, telemetry data collected from the edge are now linked to ERP, MES, SCM, and quality data and made available in the traceability portal. A central element of the architecture is the Azure Data Explorer, which allows time-series data generated at globally distributed factories to be processed in near real-time and represented in the portal. In addition, it was important for the architecture to be flexible enough to process and store different data types.

Visualization of key data types used in a digital traceability system: time-series data from OPC-UA sources, quality images from production processes, quality management documents like 8D reports, and ERP, MES, and SCM data for materials, operations, and logistics. Each data type is represented with an icon and explanatory text.

The database generated in this way forms the basis for the presentation of different areas and for searches in the portal solution.

User interface screenshots of a traceability system at FRÄNKISCHE Industrial Pipes: includes central search functionality across individual components, articles, and batches, as well as detailed views of production steps and product-related information. Visuals show data tables, 3D models, and quality inspection images with OK marking.

Voices From the Project

Quote icon

b.telligent's traceability portal has sustainably optimized our production processes. Their customized portal solution is a great asset for our company, internally as well as externally. They are more than a supplier – they are our strategic partner for innovation and success.

Stefan Endorff

Director Digital Transformation at FRÄNKISCHE Industrial Pipes

The project has impressively shown that complete traceability is possible through the digital transformation of production processes and the connection of factories to the cloud when a resolution to embrace change meets a great team at Fränkische Industrial Pipes.

Florian Stein

Domain Lead Cloud Transformation & Data Infrastructure at b.telligent

b.telligent Services at a Glance

badge icon

Project Management

Project management for IoT connectivity and traceability solution

badge icon

Cloud Solution

Design and setup of a scalable cloud solution

badge icon

Cloud Engineering

Based on b.telligent's infrastructure-as-code framework

badge icon

Data Processing & Integration

Data processing and integration of external systems with the help of b.telligent's Metafactory

badge icon

Web Application

Development of a web application forming part of the traceability portal

badge icon

Data Science & Analytics

Data-based optimization of scrap, production speed and manufacturing capacities.

Implementation of a Central Traceability System

Results & Successes

check icon

Quality: Increasing the granularity of quality controls and their automation. Combination of 8D reports and sensor data.

check icon

Process Optimization: Data-based, automated evaluation for minimizing rejects as well as optimizing production capacities and speed.

check icon

Customer Satisfaction & Regulations: Fulfillment of contractual requirements. Interlinking of supply chains. Planning of subsequent production process. Supply-chain directive, grade A, process optimization guidelines, EU Data Act.

The successful completion of the project allowed us to ensure comprehensive coverage of the manufacturing processes. We successfully integrated all collected sensor and image data, including data from traditional sources such as ERP, MES, and SCM. As a result, the customers of Fränkische Industrial Pipes can now use a productive portal that enables them to operate efficiently and save time.

The Tech Behind the Success

Microsoft

Innovation and integration, as well as interoperability, are key factors of the Microsoft product development. Learn more about our collaboration!

read more
Mann unterhält sich lächelnd am Tisch mit einer Frau

Download the Full Story

Want a handy PDF version of our success story? Whether you need it for yourself or to introduce the project to your team, download it now and explore the full success story. Enjoy reading!

Klaus-Dieter Schulze

Klaus-Dieter Schulze

Managing Director

Inspired?

Did our success stories spark your interest? If you're facing similar challenges in data, analytics and AI and look for expert support, let’s talk. A brief call can reveal how we can help you move forward.