ADF Output need as JSON response

Kumar 41 Reputation points
2022-09-23T11:26:23.563+00:00

Hi Experts,

@Nandan Hegde - Please see this scenario and share your thoughts/view how to achieve this below scenario.

I have a requirement to showcase the ADF output as response JSON format when ADF is invoked or called by external programming called Perl script.

Source is Oracle (on-premise) and Target we no need to create any file or load data into Azure cloud database table.

We have a Perl team who will call/Invoke the ADF pipeline but they need this ADF Pipeline output as response in JSON format.

I used Script Activity in ADF Pipleline and under Settings tab - Used Custom SQL Query to read data from On-premise Oracle table - I can able to see the output in JSON format when i run the pipeline but need help how the Perl team will get this result when they Invoke/read this ADF Pipeline.

Do we need to configure anything from ADF side or is there a way the Perl team need to follow to read this pipeline data - Please advise.

Regards,
Kumar P.

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,947 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 37,971 Reputation points Microsoft Employee
    2022-09-26T09:16:45.747+00:00

    Hi @Kumar ,

    Thank you for posting query in Microsoft Q&A Platform.

    You want to load data from Oracle to Some cloud database table? If yes, then there is something called copy activity inside azure data factory which we have to use.
    Not sure why, you want to take data from script activity to outside. It should like use copy activity and under source tab use Oracle dataset and under sink tab use your destination database table. Thats it. With that your job done.

    Please note, ADF is ETL service. It helps to perform data movement and transformations.

    Once your pipeline created you can schedule it with triggers.

    Please check below copy activity video to understand it better.
    https://www.youtube.com/watch?v=XOJeyRBXBos

    Hope this helps. Please let me know how it goes.