Integration Types
Updated
In Sprinklr's Data Connector, Integration Types define how data is managed and transfered between Sprinklr and external systems. Each Integration Type serves a specific purpose to handle data creation, updates or synchronization, effectively. This guide is a walkthrough on key integration types used in Data Connectors.
Note: Before you begin choosing the entites and the various integration types, refer the following URLs to gain insight on installing the Connector and the different kinds of entities that Sprinklr supports:
Selecting the Custom and Standard Entities
After selecting Install Connector in the Record Manager, you are presented with the Entity Selection screen. Select Standard or Custom entity from the dropdown.
Click Next to go to the Entity Specific Setings screen.
Selecting Integration Type
In Sprinklr's data connector platform, integration types like Upsert, Patch, Sync, and Update are methods to manage data movement between Sprinklr and other systems. Here's a breakdown of these terms:
Insert: Inserts new entities from the source while ignoring any entries that already exist in the system (the ID provided in the source for that entity is used to determine whether to check).
Sync: Sync the source and destination such that the destination has exactly the same entries as the source. Entities that were previously present in the destination but not in the source would be removed.
Update: Updates the existing entities in the destination from the data coming from the source system. No new entity is added.
Upsert: This is a combination of insert and update.
If the data already exists(based on a unique identifier), it updates the existing record.
If the data does not exist, it creates (inserts) a new record.
Patch: This method only affects the columns which are present in the uploaded file or obtained from the SQL query and does not affect the rest of the c. For example, if there are 10 columns mapped in the connector but only 4 out of these 10 are provided in the file while running the connector, then only data corresponding to those 4 columns will be edited and the other 6 will not be affected.
Insert or Patch: This method either patches or inserts the data for the chosen entity.
