Azure SQL Data Mapping¶
Data Mapping and Transformation is one of the powerful features of Connect iPaaS. When you create a workflow, certain attributes of your trigger application are available to the action application for data mapping while making API calls. These attributes can be mapped to the specific attributes of the action application.
This powerful capability not only allows field mapping but it also allows complex transformation using Excel-style functions to apply 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 MFT Trigger¶
In the example workflow, shown below, MFT is the trigger application. You can access the attributes of the MFT event in any of the application actions while designing your workflow.
In Figure 1 above, MFT is the trigger application, whenever a CSV file is added or updated in the SFTP server, corresponding to each filtered record, a record will be updated in your Azure SQL database. You can either type in values or can map the values from the headers of CSV file to filter out or update the record.