Release Date: March 10, 2021.

Use Case

Connect+ aims to address the following use cases of data integrations to and from Capillary.

Dataflow from FTP to Capillary

Connect+ can be used where CSV files uploaded on an FTP location need to be ingested to Capillary using Capillary APIs. This happens when Loyalty or DVS is enabled for the brand. Import Framework cannot be used in these cases, as it does not invoke Loyalty or DVS evaluation. Please note that for historical data migration to Capillary or FTP integrations that do not require API calls, Import Framework should be used. 

Connect+ does not replace Import Framework but complements it by addressing the integration use cases which require API calls and cannot be achieved through Data Import. For example, Connect+ can be used to create a dataflow that can read transaction data from the input CSV file, transform the input file to API JSON format and send the data using transaction APIs as per a schedule.

In future, it will support more use cases around dataflows from and to Capillary such as S3 to Capillary and Data Reconciliation.

Dataflow from Capillary to FTP

Connect+ can be used to join and transform the CSV files generated from Capillary Data Export to a format required by the brand. These operations are required when multiple files are generated using different Data Export templates that need to be joined together, or when additional columns need to be added to the files. 

Connect+ does not replace Data Export but extends it by addressing the last mile operations that cannot be achieved through Data Export. For example, Connect+ can be used to create a dataflow that can unzip and read three CSV files exported from Data Export (say from Member, Slab Change Log and Profiles templates), join the files to create a single member file, add new headers to the file, transform data in the file and send it to an FTP location.


Benefits

  • Create integrations without any code.
  • No infra management.
  • Pre-built templates for integrations, which will continue to be added.
  • Reliable (many monitoring and troubleshooting capabilities such as comprehensive errors logs, dashboard, error alerts are underway to ensure a reliable data integration).