Sage Source

SQL Server 2005, 2008, 2008R2, 2012, 2014

SQL Server 2005, 2008, 2008R2, 2012, 2014

All Downloads ----- Questions?

Overview

Sage Source Component is SSIS Data Flow Component for consuming data from Sage SData Service. The configuration options are provided in the standard data flow source component dialog. A separate output is setup for the main entity and each related composite entity.


Setup

Use the options below to setup the component.

Options

SAGE

Select an existing Sage connection manager.

Related Topics: Sage Connection Manager

BatchSize

Specify the number of rows to be retrieved as a batch.

Entity

Select Sage entity.

QueryParameters

Specify SData query parameters. Multiple parameters are separated with newline. For example to retrieve account entity records where names start with the letter M and include related Addresses information specify the following parameters:

where=AccountName like 'M%'
include=Addresses

Composite entity data

The composite entity output contains not only properties from the composite entity, but also the parent entities. The output will be populated with sets of records, one set for each parent record. Each set of records is separated with blank row (all NULLs).

How to modify query parameters dynamically at runtime?

The source entity and query parameters are available in the data flow properties list. Follow these steps to setup expression:

  • Right-click on data flow canvas and select Properties menu.
  • Scroll-down and find property named like [Sage].[QueryParameters]. This is the property containing the query parameters.
  • Scroll-down and find Expressions property. Setup expression to modify the criteria dynamically.