Share via

Obfusticate Data in Dynamics 365 using Data Factory

Simon Morris 1 Reputation point
2022-02-03T20:08:36.33+00:00

Hi,

I'm hoping to use Data Factory to anonymise data in a Dynamics 365 instance. I've been trawling the forums and articles and still can't work out how to make it work. So basically:-

  1. The source and sink are the same Dynamics instance
  2. I need to pull personal data from the contacts entity such as firstname, lastname, birthday, email address and phone number
  3. randomise this data
  4. Write them back into the same Dynamics instance.

Would appreciate any guidance this group can give.

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.


1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,631 Reputation points Microsoft Employee Moderator
    2022-02-07T07:31:57.557+00:00

    Hi @Simon Morris ,

    Thank you for posting query in Microsoft Q&A Platform.

    Dynamics 365 Connector can be used to perform data copy. Click here to know more about this connector.

    It seems as per your requirement you need to do some transformations as well on your source data before loading it to Sink. IF yes, Consider using data flows instead of copy activity.

    Click here to know about Dynamics connector Copy activity properties.
    Click here to know about Dynamic connector Data flow properties.

    Hope this will help. Please let us know if any further queries.

    ----------

    Please consider hitting Accept Answer. Accepted answers helps community as well.

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.