Overview
Sage Source Component is SSIS Data Flow Component for consuming data from Sage SData Service. The configuration parameters are provided in the standard Data Flow Component dialogs. A separate output is setup for the main entity and each related composite entity.
Parameters
Configuration
Use the parameters below to configure the component.
Select an existing Sage connection manager.
Related Topics: Sage Connection Manager
Specify the number of rows to be retrieved as a batch.
Select Sage entity.
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
Knowledge Base
- Where can I find the documentation for the Sage Source?
- How to modify query parameters dynamically at runtime
- How to work with composite records handling in a Sage source component.
What's New
- New: Introduced component.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.