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

Guide to MES integrations.pdf

  • 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

RS HTTP JSON API.pdf

  • PDF with technical guides on how to use the Webservice API

Articles.json

  • 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.