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 300 Database connection string
Create the Sage 300 Database connection string using info from your initial ERP setup. Insert the appropriate values into each field below, separated by semicolons (no spaces).
Driver=Timberline Data (This may be different if you customized your Sage 300 install.)
DBQ=[the path to the Sage 300 company data folder, which is first shown when you log into Sage 300 and select your company directory]
UID=XChangeServiceUser (Reminder: This user name must exactly match the Sage application user you set up in step 3a of this guide.)
PWD=[the password created for XChangeServiceUser]
Add this text at the end of your connection string; it never changes: codepage=1252;dictionarymode=0;standardmode=1;maxcolsupport=1536;shortenames=0;databasetype=1;
For example, Driver=Timberline Data; DBQ=\\SERVERNAME\Timberline Office\Data\COMPANY\; UID=XChangeServiceUser; PWD=Ch@rl!e1978; codepage=1252;dictionarymode=0;standardmode=1;maxcolsupport=1536;shortenames=0;databasetype=1;
Xml Messaging Configuration
Enter values in the following fields:
AddressBookKey
8826C49B-20E0-44f9-A797-0BE8C4226E1F
ServiceManagementKey
C7FC4D2C-BBC3-4a0b-B58A-ED2A9CBDF07F
JobCostTransactionServiceKey
4DEB77A7-D9CD-4560-A52D-088AF3020D9A
DataConnectionUrl
Enter the data folder path for your company. This should match your DBQ above.
GeneralLedgerKey
71948BDB-E50B-49ce-9893-B4E33460A8D5
GlDataConnectionUrl
Enter the data folder path for your company. This should match your DBQ above.
GlTargetsUrl
Enter the data folder path for your company’s GLMessaging.xml file. This is typically either \\SERVERNAME\TIMBERLINE OFFICE\9.5\Shared\Config\RoutingCatalogs\GL\GLMessaging.xml or C:\ProgramData\Sage\SERVERNAME\Timberline Office\9.5\Shared\GLMessaging.xml.
AccountsPayableKey
3BC2F783-5D10-480d-8F2D-C66C4B730937
AddressBookMessageTargets
Enter the data folder path for your company’s ABMessageTargets.xml file. This is typically either \\SERVERNAME\TIMBERLINE OFFICE\9.5\Shared\Config\RoutingCatalogs\AB\ABMessageTargets.xml or C:\ProgramData\Sage\SERVERNAME\Timberline Office\9.5\Shared\ABMessageTargets.xml.
ApDataConnectionUrl
Enter the data folder path for your company. This should match your DBQ above.
ApTargetsUrl
Enter the data folder path for your company’s apMessaging.xml file. This is typically either \\SERVERNAME\TIMBERLINE OFFICE\9.5\Shared\Config\RoutingCatalogs\AP\apMessaging.xml or C:\ProgramData\Sage\SERVERNAME\Timberline Office\9.5\Shared\apMessaging.xml.
User
XChangeServiceUser (Reminder: This user name must exactly match the Sage application user you set up in step 3a of this guide.)
Password
Enter the password created for XChangeServiceUser.
SystemInterfaceConfig
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.
Connector Endpoints
To see the API calls and endpoints in the Sage 300 connector, view the OpenAPI documentation by module, found here: