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