Hi Oracle Community.
I was wondering whether it was possible–and if so, how–to have your Autonomous Databases (I'm on the Oracle Academic Cloud) fetch data from a internet source (precise URL with an authenticating token as parameter) where a CSV file is deposited. The CSV should then be imported as-is as table.
Going even further, on a different address a list of sources is listed. It would be even more nice if that could be regularly fetched, and if a difference is recognized, the new file is fetched and a table created as described.
Background: I want to build a Data Warehouse that is taking data a Learning Management System is providing and then store and deliver it.
I'm glad for every hint.
TIA!
Luca