Oracle Blob to Azure Blob Using Azure Data Factory

Awes Khan 0 Reputation points
2023-12-21T08:08:51.6366667+00:00

i have oracle table with blob datatype column, i want to store oracle blob column value into the azure blob storage or ADLS Using Azure Data Factory.

Please help me,
Thanks.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator
    2023-12-21T21:20:11.5233333+00:00

    Hello @Awes Khan

    Thanks for the ask and welcome to Microsoft Q&A.

    If the value of the blob is in an Oracle table and just want to copy that value to an azure blob storage or ADLS , I think you can use the copy activity and use Oracle as the sink and ADLS as source. You may need a query to pull the blob data on the Oracle side.
    Please do read more about the same here : https://learn.microsoft.com/en-us/azure/data-factory/connector-oracle?tabs=data-factory

    Thanks
    Himanshu

    0 comments No 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.