Connecting Booking Data
Last updated
Last updated
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
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 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.
We support two types of data structures for automatic synchronization, both requiring the mandatory attributes:
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
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.
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.
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.
✅ Supported: Machine variables, automatic synchronization (only if the booking system also tracks live runs)
⛔ Not supported: Manual booking via the ENLYZE App
Each order in the ENLYZE data model consists of the following 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.
Attribute
Description
quantity_total
Total quantity of product produced.
quantity_good
Quantity of good products.
quantity_bad
Quantity of scrap products.
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, require live run tracking. Not all integration methods support live runs: