Differences

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

--- cli:franke:erp_integration_next [2018/02/06 16:12]
f.zoppini [FHP - Ruston 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 ======
+===== 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 |
@@ Line 18: / Line 24: @@
 ^ server | 10.100.145.20 |
 ^ role | frankeerp:FrankeERP |
+^ database | andon_FPL |
 ^ schemas | workorder,workdata |
@@ Line 25: / Line 32: @@
 ^ server | 10.60.1.21 |
 ^ role | frankeerp:FrankeERP |
+^ database | andon_FHP |
 ^ schemas | workorder,workdata |
@@ Line 32: / Line 40: @@
 ^ 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 |