Table of Contents

ERP NOT-SAP INTEGRATION

Database configuration

CREATE USER frankeerp WITH PASSWORD 'FrankeERP';
GRANT ALL ON TABLE workorder TO frankeerp;
GRANT ALL ON TABLE workdata TO frankeerp;

FWK - Unterkulm Plant (KWC)

ERP proALPHA
share data type from file (XML)
server fkt20g.fa.franke.world (10.100.145.20)
path ~/frankeerp/FWK
credentials frankeerp:FrankeERP

FPL - Poland Plant

ERP JetCAM
share data type from file (FSM)
server fkt20g.fa.franke.world (10.100.145.20)
path ~/frankeerp/FPL
credentials frankeerp:FrankeERP
ERP PBS
share data type database
server 10.100.145.20
role frankeerp:FrankeERP
database andon_FPL
schemas workorder,workdata

FHP - Ruston Plant

ERP PBS
share data type database
server 10.60.1.21
role frankeerp:FrankeERP
database andon_FHP
schemas workorder,workdata

FNO - China Nokite Plant

ERP PBS
share data type database
server 10.164.1.88
role frankeerp:FrankeERP
database andon_FNO
schemas workorder,workdata

FPK - China Heshan Plant

ERP PBS
share data type database
server 10.164.1.88
role frankeerp:FrankeERP
database andon_FPK
schemas workorder,workdata

FSA - South Africa Plant

ERP SAGE
share data type database
server 10.184.1.36
role frankeerp:FrankeERP
database andon_FSA
schemas workorder,workdata

FFB - Argentina Plant

ERP Local
share data type database
server 10.60.1.21
role frankeerp:FrankeERP
database andon_FFB
schemas workorder,workdata

FKC - Canada Plant

ERP PBS
share data type database
server 10.60.1.21
role frankeerp:FrankeERP
database andon_FKC
schemas workorder,workdata