The connection section allows you to store connections which you have previously created. This reduces the friction of connecting and authenticating (correctly) every time a new integration is required and allows easy to use features such as drag ‘n drop on lookups and option sets.
The source section on the left (Data Source A) defines what fields can be included when synchronizing to the destination.
As with the source, the destination (Data Source B) defines possible fields that than can be synchronized to.
This section defines what fields of the source records will map to the fields of the destination records.
When we map fields together DS3 uses this information to decide when to create, update or delete records. Defining a primary or unique key is very important to these decisions.
DS3 supports Lookups, Case Statements, Formulas including a significant portion of the Excel formula base and a fully featured .net development environment for advanced users.