CODEWITHSUNDEEP
sql-serverazureoffice365azure-data-factory
Dnegelof
Dnegelof

Reputation: 1

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?

Upvotes: 0

Views: 60

Answers (2)

NiharikaMoola
NiharikaMoola

Reputation: 5074

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.

Upvotes: 1

Nandan
Nandan

Reputation: 4925

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

Upvotes: 0

Related Questions