Welcome to this part of the product configuration manual explaining how to interface ROB-EX to external systems. This chapter is mainly targeted towards interface developers but is also helpful for IT architects and IT decision makers seeking to learn what interface options and features are available.
The following integration modules are all included in the ROB-EX Integration Core suite:
- CSV integration – text based integration
- Standard Excel Import using CSV – quick start setup and guide on how to import from Excel into ROB-EX
- XML integration
- SQL integration – database integration via intermediate GanttERP database
- REST Server – communicate directly with ROB-EX from REST, .NET or Workflow clients
- Direct SQL integration – import from the ERP system database directly into ROB-EX. Export from ROB-EX to ERP via intermediate database table. Out-of-the-box configuration are available for popular ERP systems like Microsoft Dynamics AX/NAV etc. These out of the box configurations are purchased separately.
The following integration modules are purchased separately and are not included in the Integration Core suite:
- Visma Business SOA integration for ROB-EX (⚠️ discontinued from v7.4.0 and forward)
Interfacing using an ETL tool
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.
Read this chapter explaining (with movies), how to interface with ROB-EX using the Talend Open Studio ETL tool.
What module should I use?
These modules enable interface developers to export data from an external system (e.g. ERP) to ROB-EX. Also the modules support export of changed data from ROB-EX back into the external system.
What technology to use for interfacing (CSV, XML, SQL or SOA) mainly depends on the development tools available for data export from the external system. CSV files are very easy to produce for almost any system, but have the draw back that they have limited encoding support and in some cases are also hard to later expand on.
XML is very flexible and easy to read and expand upon. Also XML has very good support for exchange of information created for different language locales. But unless tool support for XML is available in the external system it can be more difficult to generate and parse XML documents. The XML integration for ROB-EX is the integration with most functionality in terms of available entities and fields being supported.
SQL or database integration is a good solution if the external system has good tool support for executing and retrieving data using SQL. Another advantage of SQL integration compared to CSV and XML is that exchange of text documents are avoided, which in some situations causes extra working steps for users (e.g. having to export to a file from one system and then import that same file into the other system). Newer versions of ROB-EX however have very nice build in support for automating import of both CSV and XML files.
Finally with REST, like the SQL integration, the exchange of files is avoided since the ERP system communicates directly with ROB-EX over a network.
The following is an overview drawing of the ROB-EX Integration Core suite architecture:
Important things to note:
- Interfacing is something taking place on the Scheduler client. Generally interface developers do not have to care about if Scheduler is running single or multiuser mode.
- The SQL, Direct SQL and CSV 2/3 plugins, pipes all imported data through the XML import plugin and can thus take advantage of all the features of the XML import module
To learn more about the different options click on the different links at the top of this page.
For questions concerning Integration Core licensing and prices please contact ROB-EX A/S or your local ROB-EX dealer.
Post your comment on this topic.