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