Version 25.3.9396

• Prerequisites
• Add the Sage 50 UK Connector
• Authenticate to Sage 50 UK
  • Basic
  • Digest
  • None
• Complete Your Connection
• More Information

You can use the Sage 50 UK connector from the CData Sync application to capture data from Sage 50 UK and move it to any supported destination. To do so, you need to add the connector, authenticate to the connector, and complete your connection.

Prerequisites

For Sage 50 UK v28 and later, you must install the Sdata adapter before you use the Sage 50 UK driver. See the Sage SData-2.0 documentation for information about how to install the adapter.

The Sync application connects to Sage 50 UK data via the SData REST API, which is included with the Sage 50 UK installation. SData provides access to both local company datasets and those stored on network drives.

Before you establish a connection, ensure the Sage SData service is properly configured. Then, follow these steps to obtain the dataset URL and connect:

1. Open the Sage 50 UK software and select Tools > Internet Options.

2. Click the SData Settings tab.

3. Click Details next to the Sage 50 UK application to which you want to connect. This action opens a window that displays a list of company names along with the addresses to their corresponding datasets.

4. Set the URL property in the “Authenticate to Sage 50 UK” section below to the value in the address field next to the company that you want to use.

Add the Sage 50 UK Connector

To enable Sync to use data from Sage 50 UK, you first must add the connector, as follows:

1. Open the Connections page of the Sync dashboard.

2. Click Add Connection to open the Select Connectors page.

3. Click the Sources tab and locate the Sage 50 UK row.

4. Click the Configure Connection icon at the end of that row to open the New Connection page. If the Configure Connection icon is not available, click the Download Connector icon to install the Sage 50 UK connector. For more information about installing new connectors, see Connections.

Authenticate to Sage 50 UK

After you add the connector, you need to set the required properties.

• Connection Name - Enter a connection name of your choice.

• URL - Enter the URL for company data set that you want.

CData Sync supports authenticating to Sage 50 UK in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

• Basic (default)
• Digest
• None

Basic

To connect with your user credentials, set the following properties:

• Auth Scheme: Select Basic.

• User: Enter the username that you use to authenticate to your Sage 50 UK account.

• Password: Enter the password that you use to authenticate to your Sage 50 UK account.

Digest

To connect with your user credentials, set the following properties:

• Auth Scheme: Select Digest.

• User - Enter the username that you use to authenticate to your Sage 50 UK account.

• Password - Enter the password that you use to authenticate to your Sage 50 UK account.

None

To connect without authentication, select None for Auth Scheme. No additional properties are required.

Complete Your Connection

To complete your connection:

1. Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)

2. Click Create & Test to create your connection.

More Information

For more information about interactions between CData Sync and Sage 50 UK, see Sage 50 UK Connector for CData Sync.