Question

Batch import routine of database tables

  • 25 October 2021
  • 1 reply
  • 2 views

I would like to import a select number of tables from Oracle Spatial Object into ESRI geodatabase_SDE (ArcSDE Geodb), where they are given a new table name.

I can do this one table at a time, but is there a method where I can batch or loop this process, as I have a large number of tables to process.

I have both the required input and 'renamed' output table names in an excel spreadsheet.

Please note - I do not want to import the whole database, only a select number of Oracle tables which are then given a new name in SQLserver.


1 reply

Userlevel 6
Badge +31

Not tested, but I would try:

  • Creator to initiate process
  • FeatureReader to read excel
  • FeatureReader to read oracle table, generic, based on excel input.
  • FeatureWriter to write sde table, dynamic. You probably need to do the renaming in both the data stream (fme_feature_type) and the schema stream (fme_feature_type_name).

Reply