Connecting Booking Data

Integrating booking data into the ENLYZE Manufacturing Data Platform unlocks powerful insights and automation for your production data, including:

• Automatic OEE calculation for each order

• Product-specific benchmarking and automatic golden run detection

How to Connect Booking Data to ENLYZE

Automatic Synchronization with Your Booking System

If your booking system tracks at least the required attributes for the ENLYZE data model, we can set up an automatic data synchronization.

This synchronization follows an ETL process to extract, transform, and load booking data into the ENLYZE data model. Updates occur regularly, typically every 1 to 5 minutes, depending on system constraints. Additionally, data from the last two weeks is reviewed for changes and updated accordingly, ensuring that modifications within this period are accurately reflected.

There are multiple ways to integrate your booking system with ENLYZE:

• API Access: If your booking system provides an API that allows querying the required attributes, we can establish a direct sync.

• Direct Database Access: If database access is available, we can retrieve data from one or multiple tables or views.

• CSV via email: As a fallback option, you can regularly send a CSV file via email for synchronization.

Supported Data Structures

We support two types of data structures for automatic synchronization, both requiring the mandatory attributes:

1. Order-Based Table: Each row represents a single order, covering the full production period.

order_code	product_code	start	end	machine_code
AB-12345	25-1002	2022-01-11 06:27:00+00:00	2022-01-11 11:37:00+00:00	M1
AB-67890	25-1002	2022-01-11 12:10:00+00:00	2022-01-11 17:37:56+00:00	M1

1. Event-Based Table: Each row records a timestamped event, including order, product, machine, and event type.

Timestamp	order_code	product_code	machine_code	event
2022-01-11 06:27:00+00:00	AB-12345	25-1002	M1	START
2022-01-11 08:23:55+00:00	AB-12345	25-1002	M1	END
2022-01-11 12:10:00+00:00	AB-67890	25-1002	M1	START
2022-01-11 17:37:56+00:00	AB-67890	25-1002	M1	END

Since each system is unique, every integration is tailored to its specific setup. If you’re interested in an automatic sync, we recommend scheduling a call with us and your system expert to assess the best approach.

Capturing Booking Data from Machine Variables

Some machines automatically register the current product and order being processed. If your machine provides these parameters, simply point us to them, and we will configure the integration for you.

Manual Booking via the ENLYZE App

If automatic synchronization is not an option, you can manually log booking data through the ENLYZE App. Contact us if you'd like this feature enabled.

Live Runs

A live run refers to an ongoing production order at the time of synchronization. Tracking live runs enables real-time, product-specific process monitoring. Some features, such as the Co-Pilot, require live run tracking. Not all integration methods support live runs:

✅ Supported: Machine variables, automatic synchronization (only if the booking system also tracks live runs)

⛔ Not supported: Manual booking via the ENLYZE App

Required and Optional Attributes

Each order in the ENLYZE data model consists of the following attributes:

Required Attributes

Attribute	Description
order_code	Unique identifier for the production order.
product_code	Identifier for the manufactured product, used for product-specific aggregations like golden runs and data sheets.
start	Start time of the order (timestamp).
end	End time of the order (timestamp).
machine_code	Machine on which the order was produced.

Optional Attributes

Attribute	Description
quantity_total	Total quantity of product produced.
quantity_good	Quantity of good products.
quantity_bad	Quantity of scrap products.

Customer-Specific Attributes

Additional attributes can be synchronized if your booking system provides API access. This feature is only available through the automatic synchronization method.