Skip to main content
  • EN

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.

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


Community Stats

30,159
Posts
114,479
Replies
37,802
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.