Differences

This shows you the differences between two versions of the page.

--- cli:franke:erp_integration_next [2018/01/26 16:13]
f.zoppini [FPL Plant]
+++ cli:franke:erp_integration_next [2019/09/27 10:55] (current)
f.zoppini [FFB - Argentina Plant]
@@ Line 1: / Line 1: @@
 ====== ERP NOT-SAP INTEGRATION ======
-===== FWK - KWC Plant =====
+===== Database configuration =====
+<code sql>
+CREATE USER frankeerp WITH PASSWORD 'FrankeERP';
+GRANT ALL ON TABLE workorder TO frankeerp;
+GRANT ALL ON TABLE workdata TO frankeerp;
+</code>
+===== FWK - Unterkulm Plant (KWC) =====
 ^ ERP | proALPHA |
 ^ share data type | from file (XML) |
@@ Line 18: / Line 24: @@
 ^ server | 10.100.145.20 |
 ^ role | frankeerp:FrankeERP |
+^ database | andon_FPL |
 ^ schemas | workorder,workdata |
-===== FHP Plant =====
+===== 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 |