Before you can configure the Sage 100 connector, you must install the Xchange Agent on your server and complete the steps outlined in this guide. Review the following fields and enter values where necessary.
Connector Configuration
Real-time Action Processing
This feature should always be enabled for optimal performance. Only disable it if you are advised to do so by support.
Sage 100 Database connection string
Create the Sage 100 Database connection string using info from your initial ERP setup. Insert the appropriate values into each field below, then enter these fields separated by semicolons (no spaces):
Data Source=[the name of the Sage 100 server name where the Xchange Agent is installed followed by \SAGE100CON]
User=API-User (Reminder: This user name must exactly match the Sage application user you set up in step 3 of this guide)
Password=[the password created for API-User]
Initial Catalog=[the company name that API-User is assigned to, which is found at the bottom-left of Sage 100]
For example, Data Source=charlieserver\SAGE100CON;User=API-User;Password=Ch@rl!e1978;Initial Catalog=Charlie Construction
System Interface Configuration
Base Url of the Ryvit AppNetwork Environment
Partner Api Key
This field is pre-populated with a unique API key issued to you by App Xchange.
Attachment Base Directory
Enter the base directory in Sage 100 where attachments are stored. For example, C:\Sage100Con\Company\<company_name>\Files\.
Connector Endpoints
To see the API calls and endpoints in the Sage 100 connector, view the OpenAPI documentation by module, found here: