This document shows how communication between Moss and the Exact Globe system is established and what network configuration changes are required to enable the communication. Questions related to data protection are not subject of this document.
Background
Exact Globe is an on-premise solution running on a dedicated server. There’s no online API that can be used to communicate with Exact Globe. In order to establish a connection between Moss and Exact Globe, certain configuration changes should be applied to the network where Exact Globe is running.
Below is the overview of the connection setup, list of the necessary changes and the list of items sent to/received from Exact Globe.
Connection overview
High-level diagram
Network configuration changes
The following setup for the network configuration is required to make the data transfer available between Moss and Exact Globe:
Whitelist 8020 to Moss IP address in your firewall(s).
Assign DNS to the IP address used by Exact Globe server
Whitelist permanent Moss IP address for the connection: 34.89.228.228
Connection specific details
Moss system is running in a secured private network on a Google Cloud Platform.
There’s a permanent IP address that can be whitelisted.
Only port 8020 to be allowed to connect, all other ports are restricted.
Data transmitted between Moss and Exact Globe is SSL encrypted.
Moss uses the standard API Exact provides for access to the data and not direct access to the database.
The Exact Globe user, who is configured for Moss, may be restricted to only see the data specified in the section below.
Data interchanged between Moss and Exact Globe
Exact Globe > Moss (Moss reads only data without applying any changes)
List of VAT codes/names
List of Suppliers (names, IBANs, BICs)
Chart of G/L’s accounts (codes and names of accounts)
List of Cost centers (names and codes)
List of Cost Units (names and codes)
Moss > Exact Globe (Moss writes and updates data)
Purchase journal entries or Memorial journal entries
Incl.: tax, supplier, expense account, cost center and cost carrier information
Bank journal entries
Incl.: tax, expense account, cost center and cost carrier information
Suppliers (only created if not existed in Exact Globe before, no supplier update is possible)
Incl.: names, IBANs