Overview
Dynamics GP Source Component is SSIS Data Flow Component for consuming data from Dynamics GP Service. The configuration parameters are provided in the standard Data Flow Component dialogs. A separate output is setup for the main object and each related composite object.
Parameters
Configuration
Use the parameters below to configure the component.
Select an existing Dynamics GP connection manager.
Related Topics: Dynamics GP Connection Manager
Select Dynamics GP object.
Specify criteria XML. The criteria should be the same XML format used to serialize Dynamics GP restrictions. For example to retrieve all employees from the sales department, use the following criteria:
<EmployeeCriteria> <DepartmentId xmlns="http://schemas.microsoft.com/dynamics/gp/2006/01"> <EqualValue>SALE</EqualValue> </DepartmentId> </EmployeeCriteria>Specify whether object summary or complete object is returned. This property has the options listed in the following table.
Value Description True Only object summary properties are retrieved. Default. Using this option will improve reading performance significantly. False All object properties are retrieved.
Knowledge Base
What's New
- Fixed: Component returned only first 1000 records (Thank you, Patricia).
- New: Redesigned for better support of composite data.
- 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.
