Skip to main content

Hello,

 

I'm trying to extract data from Oracle database with several thousand tables to CSV files.

Because of the number of tables, extracting each table to CSV file is not an option.

 

Is there an automated way to read the list of tables from Oracle DB (non-spacial) and extract each table to CSV files?

 

I haven't been able to find any articles or forum questions to do that.

 

Any help will be appreciated.

 

Thanks.

@colasamk​  Yes, you should be able too. Use dynamic workflows. The section Basics of Dynamics is probably all you need. You probably don't want to export all thousands of the tables in one go, so you can use the Feature Types to Read on the Oracle reader to export the selection of tables. If you have FME Server, then you can setup a workflow to run one job per table and then not have to think to much about which tables you need to select for export.


@Mark Stoakes​ I appreciate your quick response. I will definitely try that. I'm still new to FME and a lot to learn. Thanks again.


@Mark Stoakes​ I appreciate your quick response. I will definitely try that. I'm still new to FME and a lot to learn. Thanks again.

@colasamk​ just post back here if you have additional questions around this


Reply