'Azure Data Factory - Copy Offce data to SQL Server

Goal is to extract data from Offce 365 via Azure Data Factory into a SQL Server. It seems like that it is only possible to sink the data from an Office source into the following technologies:

Azure Copy Object:

Azure Copy Object

Sinks für Offce Source:

Sinks für Offce Source

How is that possible?

sql-serverazureoffice365azure-data-factory


Solution 1:[1]

Currently, you can only copy data from Office 365 to Azure Blob Storage, Azure Data Lake Storage Gen1, and Azure Data Lake Storage Gen2 in JSON format.

You can copy data to blob storage using a copy activity first and then connect it to another copy activity to copy from storage to the SQL server.

Solution 2:[2]

Based on my understanding you need to select dataset as binary format when configuring source and sink. So the sink presents with the Binary format sources:

enter image description here

So 1st step would be to copy the data into blob as a file and then copy from file into SQL

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 NiharikaMoola-MT
Solution 2 Nandan

Related Questions