none
Stage Data from Oracle Database to Azure Data Lake Store using ADF

    Question

  • Can you please send me the steps to accomplish the following Use Case :

    Stage Data from Oracle Database to Azure Data Lake Store using Azure Data Factory

    Wednesday, October 25, 2017 12:34 PM

All replies

  • Perhaps the easiest path for you to start with this would be to use the Copy Wizard in V1 ADF pipeline: https://docs.microsoft.com/en-us/azure/data-factory/v1/data-factory-copy-data-wizard-tutorial.

    If you require a bit more control over steps in your pipeline such as IF conditions or Branching, then try a V2 ADF pipeline using the Copy Activity: https://docs.microsoft.com/en-us/azure/data-factory/tutorial-bulk-copy

    Wednesday, October 25, 2017 5:36 PM
  • Hi msmali,

    You basically want to create a pipeline with a single copy activity with Oracle DB as your source and ADLS as your sink in the copy activity.

    Here's documentation on setting up a copy pipeline with Oracle as your source: https://docs.microsoft.com/en-us/azure/data-factory/connector-oracle#copy-activity-properties

    Documentation on setting up a copy pipeline with ADLS as your sink: https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-data-lake-store#copy-activity-properties

    Let me know if you're still having issues building the pipeline!

    Thursday, October 26, 2017 1:17 AM