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 source component dialog. A separate output is setup for the main entity and each related composite entity.
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
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.
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).
Ready to give it a try?
COZYROC SSIS+ Component Suite is free for testing in your development environment.