Data extraction

Hi All,

I have exadata box hosted in oracle cloud with approx 30 TB data in it and multiple tables.

There is requirement to extract the data in CSV and store them in ADLS gen2.

Similarly, there are multiple tables in hive metastore and have to do similar activity to extract data in csv and store in ADLS gen2.

My questions are as below

1) Apart from data factory what is the best solution to extract data from Exadata. Also what are the steps that can be followed for this extraction

2) Should I follow the similar approach for Hive metastore as well ?

Thanks & Regards

Sumeet Firodia