Skynamo's integration with Syspro leverages a combination of direct database querying and API (Application Programming Interface) functionality to ensure seamless connectivity and data exchange between the two platforms.
To enable one-way integration from Syspro to Skynamo, we utilize a direct database querying application to extract data from the SQL database. This approach does not necessitate a Syspro user license; it simply requires an SQL user with read access to the SQL database.
For clients seeking the capability to push orders from Skynamo back into Syspro, we utilize the Syspro API. This method entails the client providing Skynamo with the details of a Syspro user who has access to push orders into Syspro using the SORTOI Business Object and Syspro API.
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 Syspro 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 Syspro server (TeamViewer, AnyDesk, or RDP)
- Windows username & password (of a Windows user with administrator rights to set up background tasks and services)
- Syspro database server IP/name
- Syspro database name
- SQL username & password
- Syspro company ID and password (for order integration only)
- Syspro username & password (for order integration only) - The user should have access to the Sales Orders Primary Posting Business Object
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