Search Crosser Knowledge Base

Enrich payload with data from external systems

In many use cases, data from different sources has to be enriched with information from other systems. As an example you might want to enrich data from your OPC UA server with asset-related specifications from a SQL database. To avoid querying the data source for every message going through your flow, you can use the Key/Value Store and set up a flow with two parts:

Part 1: On flow start and on Interval query asset-related specifications from SQL server and store them in the Key/Value Store. Make sure you have a key that you can use to look up the correct asset-related information.

Part 2: Subscribe to your OPC UA Server, look up the Key/Value Store for related information and add them to your Flow. Once added you merge the information via ie. Message Template or Property Mapper and send them to some external system.

Crosser Example

Note: This concept can be used for various use cases and systems and interfaces. You could do the same with an API instead of MsSQL and a SaaS application instead of OPC UA.

About the author

David Nienhaus | Senior Solution Engineer

David is a Senior Solution Engineer at Crosser. He has over 15 years experience working with software integration and digitization projects for critical infrastructure.
His engineering background gives him the understanding and focus needed to solve customer use cases in the most efficient and successful way.