Standard ERP-integration
RS Production is often integrated with other systems. RS Production’s Integration Interface offers several different ways to do integrations.
Three types of ERP-integrations
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?
Required data for order and article import integration
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?
Required data for order and article import integration
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?
Required data for order and article import integration
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.