Azure Data Factory Possible to Copy O365 dataset to SQL Server dataset?

Michael B 1 Reputation point
2021-02-23T21:25:04.057+00:00

Hi, I'm new to Data Factory and it's been a little frustrating so far to say the least.

I have two datasets that are both working correctly. One is an O365 Graph connector. The other is a table on a SQL VM.

What I want to do is copy user data from O365 to the SQL data table. However, when I set the O365 dataset as the source I don't get an option to select the SQL dataset as the Sync. Is there a step I could be missing?

I can set the SQL table as both the source and the sync, which doesn't make any sense.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,535 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Saurabh Sharma 23,676 Reputation points Microsoft Employee
    2021-02-25T01:06:45.45+00:00

    @Michael B Thanks for using Microsoft Q&A !!
    Sorry for your trouble. Unfortunately you can only copy data from Office 365 into Azure Blob Storage, Azure Data Lake Storage Gen1, and Azure Data Lake Storage Gen2 in JSON format (type setOfObjects). Please refer to the documentation . Also, as mentioned in the document if you want to load Office 365 into other types of data stores or in other formats, you can chain the first copy activity with a subsequent copy activity to further load data into any of the supported ADF destination stores. Please let me know if this helps.

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.