Devart SSIS Data Flow Components for QuickBooks allow you to integrate QuickBooks data with cloud applications and databases via SQL Server Integration Services (SSIS).
Devart SSIS Data Flow Components for QuickBooks include Source, Destination, and Lookup components along with Devart QuickBooks Connection Manager.
Devart QuickBooks Source
Devart QuickBooks 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 Source allows using SQL select statements to query data from QuickBooks even though QuickBooks does not support SQL natively. No need to study QuickBooks API to integrate your data.
Devart QuickBooks Lookup
Devart QuickBooks 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 Destination
Devart QuickBooks Destination support not only the standard Insert operations, but also Update, and Delete.