Devart SSIS Data Flow Components for QuickBooks Online allow you to integrate QuickBooks Online data with cloud applications and databases via SQL Server Integration Services (SSIS).Devart SSIS Data Flow Components for QuickBooks Online include Source, Destination, and Lookup components along with Devart QuickBooks Online Connection Manager.
Devart QuickBooks Online Source
Devart QuickBooks Online Source provides convenient editor which allow you to quickly create a query to the data source. It displays data source metadata and variables list, and allow previewing the queried data. Devart QuickBooks Online Source allows using SQL select statements to query data from QuickBooks Online even though QuickBooks Online does not support SQL natively. No need to study QuickBooks Online API to integrate your data.
Devart QuickBooks Online Lookup
Devart QuickBooks Online Lookup component offer advanced two-level performance optimizations. They check incoming rows for matches in batches and cache the data returned from a lookup object in order to provide the highest possible performance.
Devart QuickBooks Online Destination
Devart QuickBooks Online Destination support not only the standard Insert operations, but also Update, and Delete.
