Sage 50 UK Connection

See the Connector Marketplace topic. Please request your administrator to start a trial or subscribe to the Premium Sage 50 UK connector.

Sage 50 UK is a tailored accounting and business management software designed for small businesses in the UK.

This topic describes how to authenticate to Sage 50 UK and configure any necessary connection properties in the Sage 50 UK connection connector.

Prerequisites

The URL property should be set to the address of the company dataset desired.

To obtain the address, do the following:

  1. If you have not already done so, open the Sage 50 UK software.

  2. Select Tools > Internet Options.

  3. Select the Sdatasettings tab.

  4. Click Details next to the Sage 50 software application you want to connect to. A window opens containing a list of company names along with the addresses to their corresponding datasets.

  5. Set the URL property to the value in the address field next to the company desired.

Authenticating to Sage 50 UK

The User and Password properties must be set to valid Sage 50 UK user credentials. These values are the same values used to log in to the Sage 50 UK software. To authenticate with HTTP digest to the SData service, set AuthScheme to Digest. Otherwise, Basic AuthScheme will be used.

Note: If the dataset you want to connect to is not displayed, the permissions on the Sage 50 UK folder location may not be correct. If you are connecting to a dataset on a networked drive, ensure:

  • You are using UNC paths to the folder on the machine you are using as your SData provider.

  • You set the SData service login rights to a user who has full rights over the network share or map drive.

Connection Configuration

Each connection property available in the Sage 50 UK connector is explained below.

Connection Name

The name of the connection to be created should be provided. This is the name that will display on the list of available connections.

Auth Scheme

The scheme used for authentication. Accepted entries are Basic or Digest.

Together with Password and User, this field is used to authenticate against the Sage 50 UK Accounts service. Basic is the default option.

  • Basic: Set this to use HTTP Basic authentication.

  • Digest: Set this to use HTTP Digest authentication.

URL

URL to the Sage 50 UK SData service.

Example: http://MySite:5493/sdata/accounts50/GCRM/MyDatasetId/.

The URL can be obtained directly from your Sage 50 UK Accounts software by navigating to Tools > Internet Options > SData Settings > Details (Next to Sage 50 UK Accounts).

The address can then be copied for the company dataset desired.

User

The Sage 50 UK user account used to authenticate.

Password

The password used to authenticate the user.

Enable SSL

Option for creating the connection with SSL enabled.

Upload Keystore File

Option to upload keystore file.

Add Configuration: Additional properties can be added using this option as key-value pairs.

After entering all the details, click on the TEST button.

If the connection service identification and authentication details are provided correctly, a success message stating “connection available” is generated.

Click on the CREATE button to save the changes.

If the details are incorrect or the server is down, you will get a message “Connection unavailable”.

If you have any feedback on Gathr documentation, please email us!

← Redshift ETL Target
Sage 50 UK Ingestion Source →