I'm looking for a documentation regarding Data Factory Utility activities in SFMC and I can't find any description of its purpose. There's only how to set them up. Can anyone briefly explain it's usage? Is it possible to import data straight from SQL server using it?


They're used to load and transform data from the SQL Server based environment of the Email App to the Oracle/Netezza environment that underlies Discover and Audience Builder. Basically, don't touch. Nothing happening. Move on.

  • 2
    This has now become one of my favorite answers ever on SFSE. Oct 12 '17 at 14:35
  • 2
    Yes this was indeed a fun answer, but could you provide a bit more? I too am puzzled by what exactly they do, and the documentation is of absolutely no use!
    – garek007
    Aug 1 '18 at 14:21

Adding to @Macca's answer, when contact deletion jobs are started in contact builder, it creates automation and data factory utility based on the criteria that you select. For eg., I asked all the unsubscribed contacts to be deleted and a DFU is created with 'unsubscribe' selected in it.enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.