question

MichaelB-7419 avatar image
0 Votes"
MichaelB-7419 asked ·

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

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
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered ·

@michaelb-7419 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.

· 2 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@michaelb-7419 Please let me know if you find above reply useful. If yes, do click on 'Mark as answer' link in above reply. This will help other community members facing similar query to refer to this solution. Thanks.

0 Votes 0 ·

@michaelb-7419 I have not heard back from you. Did my answer solve your issue? If so, please mark as accepted answer. If not, please let me know how I may better assist.

0 Votes 0 ·