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/. You can type in any unspecified details in the comments box. It’s simply a secure way of getting sensitive info to us, rather than using e-mail. It's stored as free text in an encrypted database, so please don't worry too much about the formatting of the message.
If you have any questions, please do not hesitate to ask. We look forward to hearing from you.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article