Configuration

These additional connector settings must be configured in App Xchange.

Connection Details

  • 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 the recorded information from the above steps. 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 username must exactly match that of the Sage SQL server user you previously recorded.)

    • Password=[the password created for API-User you previously recorded]

    • Initial Catalog=[the company name that API-User is assigned to, 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.