Sage 200 UK - Access Requirements

Skynamo's integration with Sage 200 UK leverages a combination of direct database querying and SDK (Software Development Kit) functionality to ensure seamless connectivity and data exchange between the two platforms.

To enable one-way integration from Sage 200 UK to Skynamo, we utilise a direct database querying application to extract data from the SQL database. This approach simply requires an SQL user with read access to the SQL database.

For clients seeking the capability to push orders, quotes, and credit requests from Skynamo back into Sage 200 UK, we utilise the Sage 200 UK SDK. This method entails the client setting up a Windows User for Skynamo with access to the Sage 200 UK company we will be integrating with.

Due to the complexity of the setup, we typically handle the server-side setup ourselves using remote access through TeamViewer, AnyDesk, or RDP. If we are provided with the necessary remote access credentials, we will:

• Install our Sage 200 UK Integration tool, which includes a file transfer mechanism.
• Configure the integration tool.
• Set up Windows Tasks or a Service to run scheduled imports and exports in the background.

For a quick installation, we need the following credentials:

• Remote access details to your Sage server (TeamViewer, AnyDesk, or RDP)
• Windows username & password (of a Windows user with administrator rights to set up background tasks and services) - if you have opted for order integration, this user needs access to the relevant Sage Company
• Sage database server IP/name
• Sage database name
• SQL username & password

This information is sensitive and should not be sent via email. Please submit these details through our secure messaging portal here: https://services.skynamo.com/messenger/. Please contact our support team to get the secret key required to use this messenger.