Skip to Content

Sage 50 UK Connector

Summary

The Jitterbit Harmony Sage 50 UK Connector establishes access to Sage 50 UK.

The Sage 50 UK connector provides an interface for creating a Sage 50 UK connection, the foundation used for generating instances of Sage 50 UK activities. Activities interact with Sage 50 UK through the connection and are intended to be used as sources (to provide data in an operation) or targets (to consume data in an operation).

The Sage 50 UK connector is accessed from the design component palette's Connectivity tab (see Connectors in Design Component Palette).

Note

This connector can be used only with Private Agents.

Connection Documentation

See Jitterbit's comprehensive Sage 50 UK connection documentation, which is provided at a dedicated website. Configuration details such as these are included:

  • Getting Started: Initial steps for establishing a connection.
  • Advanced Features: User-defined views and SSL configuration.
  • Data Model: The data model that the connector uses to represent the endpoint.
  • Connection String Options: Properties that can be defined to configure the connection for both basic and advanced configurations.

Activity Documentation

Together, a specific Sage 50 UK connection and its activities are referred to as a Sage 50 UK endpoint:

Sage 50 UK activity types

  • Query: Retrieves records from a table at Sage 50 UK and is intended to be used as a source in an operation. (Generically documented in Query Activities.)

  • Create: Inserts a record into a table at Sage 50 UK and is intended to be used as a target in an operation. (Generically documented in Create Activities.)

  • Update: Updates a record in a table at Sage 50 UK and is intended to be used as a target in an operation. (Generically documented in Update Activities.)

  • Delete: Deletes a record from a table at Sage 50 UK and is intended to be used as a target in an operation. (Generically documented in Delete Activities.)

Prerequisites and Supported API Versions

The Sage 50 UK connector requires the use of an agent version 10.1 or later. These agent versions automatically download the latest version of the connector when required.

This connector requires the use of a Private Agent.

Refer to the documentation for information on the schema nodes and fields.

Verbose Logging

Verbose logging can be enabled for this connector. See Verbose Logging for Connectors for details.

Invoke verbose logging for this connector using this configuration entry:

<logger name="org.jitterbit.connector.verbose.logging.Sage50UK" level="TRACE"/>