If there is a need to scale to large data volumes and number of tables, BICC (Oracle BI Cloud Connector) works better for bulk data exports into files from Fusion. Then use Autoloader to ingest and Declarative Pipelines /DLT to streamline the ingestion.