Integration Interface
This is a selection of typical integrations in a RS Production solution using both standard and custom integrations. Note that it is also possible to add the Addon Machine Data Interface to integrate with machines
Introduction
Gives access to several ways to integrate data between RS Production and other softwares.
MS SQL-table middle layer
Webservice API (REST API)
Both interfaces offers standard connections to RS Production that enables it for anyone to make write an integration to any other system.
Also, the Addon Integration Interface enables a RS Production Solution Partner to make custom integrations.
The CSV-file import is available even without this Addon Integration Interface.
Overview of integration possibilities
Slide 1 Selection of typical integrations in a RS Production system using both standard and custom integrations.
Slide 2 Different integration interfaces in RS Production.
Slide 3 Common integrations
Data security
Starting at this page RS Production cloud service and data sequrity , you’ll find details about data security related to data integration.
Examples of systems integrated with RS Production
Integration platforms
Biztalk
iCore
ERP-Systems
Enterprise Resource Planning systems
Formula Industri
IBS
IFS
Infor Movex, M3
Jeeves
Microsoft Axapta, AX, D365 Finance & Operation, Navision, NAV, D365 Business Central
Monitor G4, G5
Pyramid
SAP
APS-systems
Advanced Planning systems
Robex
BI-systems
Business Intelligence systems
Power BI
Qlik View, Qlik Sense
EAM-systems
Enterprise Asset Management systems
Api Pro
Idus
IFS
Infor EAM
MaintMaster (Tekla, T7)
Maximo
Ultimo
MES-systems
Manufacturing Execution Systems
Aveva (Wonderware)
Digital Lean Boards
Boards on Fire
Mevisio
MS SQL-table middle layer (one way, or two ways)
What data is integrated like this?
standard interface for 2-way integration of production plan and related data.
What systems are typically connected like this?
ERP, MPR, APS, and more …
What data can be read?
Production orders, order queue (with prio), Articles (products) and their properties
What data can be written?
Order/operation status, Produced/scrapped/approved/reworked amount, Amount ready for stock, Machining time, Changeover time, Cycle times, Time per approved unit
How to connect?
A standard SQL-table is set up on MS SQL Server close to your master data. A RS Production integration client (with Edge capabilities) is handling the reading/writing between the SQL table and RS Production.
Technical documentation
How to work with the standard SQL-table integration.pdf
Standard integration table structure
Webservice API (REST API) (one way, or two ways)
RS Production has a HTTP API that exposes the RS Production “in memory database”. The API calls are made over HTTP with standard Get / Put and Post methods, the data can be serialized in either XML or JSON format.
What systems are typically connected like this?
ERP, MPR, APS, EAM, BI, and more …
What data can be read?
Production orders, order queue (with prio), Articles (products) and their properties
What data can be written?
Order/operation status, Produced/scrapped/approved/reworked amount, Amount ready for stock, Machining time, Changeover time, Cycle times, Time per approved unit
How to connect?
A standard SQL-table is set up on MS SQL Server close to your master data. A RS Production integration client (with Edge capabilities) is handling the reading/writing between the SQL table and RS Production.
Technical documentation
PDF with technical guides on how to use the Webservice API
Example of data
SFTP-interface
Used to transfer data to RS Production cloud service.
What systems are typically connected like this?
ERP, MPR, APS, EAM, BI, and more …
What data can be read?
Production orders, order queue (with prio), Articles (products) and their properties
What data can be written?
Order/operation status, Produced/scrapped/approved/reworked amount, Amount ready for stock, Machining time, Changeover time, Cycle times, Time per approved unit
How to connect?
The SFTP service is running on the RS Production cloud (port 22). Login using SSH. Each user has their own directory to ensure no data is mixed.
Examples of custom integrations
Addon Integration Interface also opens up interface for RS Production Solution Partners to make customized integrations. Note that a support/maintenance agreement fee can be added customizations.
Order sniff
[To be added]
CSV-file import (one way) (Addon Integration Interface not needed)
What data is integrated like this?
Mainly used to for one time import of article/product data, often at system setup. At the moment, there are no standard CSV-file structures ready to be imported. But any RS Production delivery consultant can set up any type of import needed.
What data can be imported?
Most common is articles (products) and their properties, but any part of the RS Production data model can be imported this way.
How to connect?
Contact your RS Production delivery consultant to help you set this up.