Sage 500

Supported versions of Sage 500

Data Hub supports connections to any version of Sage 500 that has a SQL Server database.

Connecting to the data source

Specify the following connection settings need to be defined for a Sage 500-based data source:

  1. Server - The name of the SQL Server instance hosting the Sage 500 database you want to access. Just the server name may be entered if there is only one SQL Server instance on that server. If the server hosts multiple instances, use the syntax ServerName\InstanceName. Type in the instance name or choose from a list of instances on your local network using the drop-down.

  2. Authentication - You can provide credentials to authenticate to the SQL Server instance hosting the Sage 500 database (specified above) in two ways. The method used will depend on how your SQL Server instance is configured:

    1. Windows login - Enter a Windows user name and password.

    2. SQL Server login - Enter a SQL Server user name and password.

  3. User Name - Type a user name in the same form you use to log in directly to Windows or SQL Server (depending on which authentication method you chose above). This may be just a user name, or it may include the domain name in canonical form (domain\user) or UPN form (user@fully-qualified_domain_name), depending on your environment.

  4. Password - Type a password for the specified user name.

  5. Database - Type the Sage database name to use as the data source, or select the Sage 500 database from a drop-down list of databases found on the specified SQL Server instance.

Optional

Set advanced data source properties

One or more optional advanced connection settings can be added or modified for this data source using either:

  1. Advanced pane on the Connect screen when adding the data source.

  2. Properties pane when viewing an existing data source, under Advanced section.

In this section: