Azure PostgreSQL Data Mapping¶
Data Mapping and Transformation is one of the powerful features of Connect iPaaS. When you create a workflow, certain data points of your Trigger application are available in the Action application for data mapping.
These Data Mapping can be mapped to the specific attributes of the Action application. This powerful capability not only allows field mapping but also the complex transformation using excel style functions with hundreds of formulas and operations. The choice of Excel-style function makes data mapping on Connect iPaaS a breeze for business users who are already well versed with Microsoft Excel formulas.
Example Scenario with ServiceNow Trigger¶
In the Figure 1 below, when a new incident is created on ServiceNow, a new record is created in Azure PostgreSQL database. The database has a table named
Incident which stores the
OpenedBy of the incident in respective columns. Here the columns are mapped to the corresponding attributes from ServiceNow.