can we copy data from Oracle database to ADLS Gen2?

Kuldeep Jaimini 1 Reputation point
2022-01-27T12:32:33.067+00:00

Dear AZCommunity,
I was trying to copy data from oracle database to ADLS Gen2, I checked everything from my side, like SHIR, Access Control(IAM), but I didn’t succeed.
But when I tried to copy data from oracle database to Azure blob storage, it worked and I was successfully able to copy data.
As per the documentation on this page, in supported scenario for oracle, ADLS Gen2 is not mentioned for ADF v1. https://learn.microsoft.com/en-us/azure/data-factory/v1/data-factory-onprem-oracle-connector

I wanted to know if the supported scenarios are valid for ADF v2 as well, can we copy data from Oracle database to ADLS Gen2?

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,349 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,587 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 29,891 Reputation points MVP
    2022-01-27T13:46:06.2+00:00

    Hey,
    ADLS Gen 2 is supported as sink in ADF v2.
    learn.microsoft.com/en-us/azure/data-factory/connector-azure-data-lake-storage?tabs=data-factory
    learn.microsoft.com/en-us/azure/data-factory/load-azure-data-lake-storage-gen2

    So in your scenario: Oracle db would be source and ADLS Gen 2 would be sink

    1 person found this answer helpful.
    0 comments
  2. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2022-02-02T00:01:00.567+00:00

    Hello @Kuldeep Jaimini ,

    Thanks for the question and using MS Q&A platform.

    My understanding is that you are using Azure Data Factory V1 version and trying to copy data from Oracle database to ADLS gen2 and you got stuck in implementing a pipeline flow.

    In addition to @Nandan Hegde 's input, I want to add below info.

    1. Firstly ADLS Gen2 is not a supported data store in ADF V1, which is why you are not able to implement it successfully - Ref: Data Factory V1 supported data stores
    2. This is the reason why it is not listed in the public documentation - Supported scenarios 170278-image.png
    3. And yes, ADLS Gen2 is a supported data store in ADF V2 - Ref: ADF V2 supported data stores, and hence you can use ADF v2 to copy data from Oracle to ADLS Gen2 using the out of box connectors available.

    Hope this info will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments