Syspro - Access Requirements

Modified on Wed, 12 Jun at 4:58 PM

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: Please contact our support team to get the secret key required to use this messenger.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article