Skip to content
  • There are no suggestions because the search field is empty.

Sage 50 Data Connection Setup

Setting up a Sage 50 connection should only take 5-10 minutes.

 There may be fees associated with setting up a new data connection. Please contact your account team to confirm pricing.

Set Up a User in Sage 50

This user account will be used to authenticate the ODBC connection.
  1. Open Sage 50.
  2. Navigate to Maintain > Users > Set Up Security (label may vary by version).
  3. Add or modify a user.
  4. Ensure the user has permissions under the Data Access/Crystal Reports tab.
  5. Select “With the following login information”.
  6. The typical User Name (ID) for ODBC is Peachtree.
  7. Set and securely store the Password.
  8. Select Close.

Verifying ODBC Driver Version and Install Matching BUCS Agent

  1. Open the Start Menu, type ODBC, and select:
    • ODBC Data Sources (32-bit) or
    • ODBC Data Sources (64-bit), depending on your system architecture
  2. In the ODBC Data Source Administrator window, locate the Pervasive Client Interface ODBC driver.
  3. Confirm whether it's 32-bit or 64-bit.
  4. Install the BUCS Agent version (32-bit or 64-bit) that matches the ODBC bit version. You will need the BUCS Remote Agent installed on the machine where your Sage 50 data is located.  Remote Agent installation instructions can be accessed here.

Configure the ODBC Connection

  1. Open the ODBC Data Source Administrator via Control Panel > Administrative Tools > Data Sources (ODBC) or Search "ODBC Data Sources" in the Start menu.
  2. Click the System DSN tab, then click Add.
  3. Select the Sage 50 ODBC driver (or Pervasive ODBC Client Interface, if Sage 50 is not listed), then click Finish.
  4. In the data source configuration dialog enter a Data Source Name (DSN) for your Sage 50 company database. This can be BUCS.
  5. The server Name/IP will be default to Localhost. If the database is not on the local machine you need to enter in the IP Address of the Server where Sage50 DB is hosted.

    ℹ️ An option if the IP Address is not known is to Open Sage 50 and under the File Menu select Open New Company. This will log you out of the current company and provide a list of available companies and the drive path to that company file. Then in windows file explorer, navigate to that drive path and determine the server name/IP address of the connection.

  6. Next select “Get List” and a list of available companies will populate. Select the company you want to connect to.
  7. Click Test Connection to verify the setup. Use credentials established above to confirm connection.
  8. Click OK to save the DSN.

Connect to Sage 50 in the BUCS Connection Hub

  1. Log in to the BUCS Customer Portal. Navigate to Connection Management > Connection Hub.
  2. Search or scroll to locate Sage 50. Click Connect. 
  3. Enter a Name for your connection on the first page of the connection wizard and then click Next. The connection name should be descriptive and specific to the connection you want to establish.

  4. Provide the Sage 50 connection details.
    1. For Driver enter "Pervasive ODBC Client Interface"
    2. Enter the Server Name, Database, Username, and Password provided when you configured the ODBC Connection.

  5. If the connection was established successfully you will see a Connection Established message and data from Sage 50 will continuously sync to BUCS. If the connection was not successful, you will be asked to try again.

    NOTE: If you don't see your Sage 50 data appear in the BUCS platform in 24 hours, please contact your account team.