This article tells you everything you need to know about how Sage 50 integrates with iCompleat using our secure connector.
Our Sage 50 connector is installed locally on your LAN via an MSI installer.
It’s then configured using a secure PIN number unique to your iCompleat account, which the iCompleat Administrator in your company can access via the iCompleat web front-end.
During configuration, local connection details are applied to the connector, which are used to communicate with Sage 50 using the SDO and ODBC integration capabilities supported by Sage.
These connection details will include a Sage username and password. We recommend that you set up an integration account in Sage 50 specifically for this purpose. This information is only ever stored in the locally-installed files, and will never leave your LAN.
Establishing a connection
The connection is established outbound from your network, meaning no firewall rules need to be put in place (unless you have the most restrictive corporate firewalls in place, and outbound communications may have been blocked).
Communicating with iCompleat
Once the connector is running, it communicates with Sage 50 using SDO and ODBC on the LAN. For communicating back to iCompleat on the cloud, the connector opens up a persistent outbound connection to iCompleat.
iCompleat and the connector can communicate bidirectionally to exchange information. All data exchanged on this communication is secured and encrypted using TLS.
The connector also periodically calls API endpoints in iCompleat, primarily for initial registration and heartbeats. These are HTTPS API calls, encrypted using TLS 1.2.
iCompleat will never attempt establish an inbound connection to your LAN.