Hi,
We have an Oracle 12c database in our vendor Data center. We are trying to fetch/SELECT data from the DB and move it to ADLS using data factory. The vendor has already installed SHIR on their data center and we have verified that the SHIR is online.
However, the vendor has not provided direct access to the table or view. They have asked us to execute a stored procedure to fetch the data. What is the best way to execute a stored procedure on an Oracle DB to SELECT a bunch of data using ADF? It doesn't seem to works the same way as MS SQL.
Regards,
Anupam