An easy and recommended approach, when building interfaces between ROB-EX and external systems like ERP, is to use an ETL tool (Exctract, Transform, Load). Using a tool reduces the learning curve required, enabling non-developers to create even complex interfaces.

There are several different tools on the market. We have internally in ROB-EX experience with using the Talend Open Studio for Data Integration. We have created the ROB-EX XML datamodel as meta data which you can import into Talend. This way you will get a head start on easily building interfaces between ROB-EX and virtually any system out there.

To get started using Talend, please follow this series of movies.

Video 1: Intro and getting started

The first movie in this series explaining and demonstrating best practice on how to get started building interfaces between ERP and the ROB-EX Scheduler, using the Talend Open Studio ETL tool. Covers how to download, install and getting started. Also explains how to import the ROB-EX metadata (the columns of the different ROB-EX entities like resource, production order, etc.)

Video 2: Importing resources + executing Talend jobs from ROB-EX Macro

The second movie in this series. A hands on tutorial how to read resource data from a CSV file and convert it to valid ROB-EX XML. The example also covers how to automate the execution of the Talend job from a ROB-EX client. I.e. how to compile, and use the Talend job within a ROB-EX macro.

Video 3: Importing master materials and inventory

The third movie in this series. A hands on tutorial how to import material master and material inventory (opening stock) information from a single CSV file – while generating two different XML output files. I.e. how to use the tMap component to produce two different outputs from a single input.

Also shows how to use the tFileList component to iterate on a file pattern.

Video 4: Importing purchase orders

Read purchase orders from a CSV file and output to ROB-EX XML.
Demonstrates error handling between Talend and ROB-EX using the tLogCatcher component.

Video 5: Importing orders and BOM

A full example demonstrating how to read production orders, operations and production order BOM from CSV into ROB-EX Scheduler XML.
During this we also demonstrate more advanced tMap features like “lookups” and using he Var” intermediate variables.
Finally this movie also demonstrate how to create multiple sub-jobs.


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment

Kiruthika Venkatesh wrote: Jul 22, 2019

Nice post. Thanks for sharing the valuable information. it’s really helpful. Who want to learn this blog most helpful. Keep sharing on updated posts…
MSBI Online Training