Layer2 Cloud Connector Dynamic Columns Feature - How does it work
Version 7 of the Layer2 Cloud Connector comes with a Dynamics Columns feature.
This feature allows users to define new data columns in addition to the ones
that are returned by a data entity. The values of these columns are calculated
at run-time via C# code, and can be based on the content of other columns. This
allows for customized calculations, conversions, translations, and formatting of
the data to be synchronized between 100+ systems and apps, e.g. Microsoft
SharePoint, Office 365, Dynamics, SQL, ERP/CRM and more.
To add a Dynamic Column to a data entity you have to open the Advanced Settings
section of the certain connected data entity. You will find +/- buttons to add
new or remove existing Dynamic Columns.
Fig.: Add or remove Dynamic Columns
to / from a connected data entity.
To edit a specific Dynamic Column you can double-click it in the list. The
Dynamic Column Editor pop-up will be shown in the Connection Manager to specify
the column name, select existing columns, and add your own C# code for
calculations, conversions, translations, transformations, or formatting.
Fig.: The Layer2 Cloud Connector
Dynamic Column Editor allows to add your own C# code.