Devart SSIS Data Flow Components for Cin7 Core 2026: Benefits, Features & Pricing

The Devart SSIS Data Flow Components for DEAR Inventory allow users to integrate DEAR Inventory data with other cloud applications and databases using SQL Server Integration Services (SSIS). This product includes DEAR Inventory Source, DEAR Inventory Destination, and DEAR Inventory Lookup components, as well as a DEAR Inventory Connection Manager.

With these components, users can build SSIS-based integration solutions for DEAR Inventory, automating the integration process via SSIS Data Flow tasks. The product supports importing and exporting CSV files to DEAR Inventory, and enables the synchronization of DEAR Inventory data with SQL Server or other data sources. The DEAR Inventory Source component has an editor that displays DEAR Inventory objects and fields, allowing users to build queries by drag-and-drop.

The DEAR Inventory Lookup component uses optimization techniques to provide high performance, checking multiple rows at once and caching returned results to reduce round-trips to the server. The DEAR Inventory Destination component allows users to quickly load data into DEAR Inventory, supporting DML operations such as Insert, Update, and Delete.