Transform data in ADF with Azure Cognitive Services
Published May 06 2022 08:15 PM 7,320 Views

We’ve added two new templates to the Template Gallery to help you easily perform complex transformations on your data with Azure Cognitive Services.


  1. PII detection and masking

With Azure Cognitive Services, you can now detect and mask PII in your data. Learn more here.




This template calls the Cognitive Services API using the external call transformation in a dataflow. The data flow includes transformations to create the appropriate request body before masking PII data row-by-row with the external call transformation.


Instructions on how to use the template can be found here.


  1. Extract data from PDF source

With Azure Form Recognizer, you can easily extract tables and text from many document sources using prebuilt or custom models.  Learn more here.



This template calls the Azure Form Recognizer API to extract data from a PDF source using a web activity. Then, using mapping data flow transformations, the extracted data is consolidated into a readable form that lands in a sink of your choice. You also have the option to reuse the dataflow logic by selecting the transformations and creating a new flowlet.

Instructions on how to use the template can be found here.



We are always open for feedback! You can provide suggestions or vote via our Ideas forum Data factory · Community (

Version history
Last update:
‎Aug 09 2022 02:54 PM
Updated by: