Share via

How to transfer data from SQL Server to Elastic Cloud Storage S3 using ADF

Vijayvargiya, Divyank 6 Reputation points
2023-02-10T09:30:29.0333333+00:00

We have a requirement where we need to get data from SQL Server in Parquet Format and publish it to ECS S3. What all Activity we can leverage in Azure Data Factory to perform this task.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,345 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bhargava-MSFT 31,216 Reputation points Microsoft Employee
    2023-02-16T17:38:47.06+00:00

    Hello @Vijayvargiya, Divyank,

    Welcome to the MS Q&A platform.

    Unfortunately, ADF does not support ECS S3 as a sink.

    As a workaround, you can use Azure functions to write to ECS S3.

    Reference: How to copy data from Azure to S3 programmatically

    I hope this helps. Please let me know if you have any further questions.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.