Question

Feature Class Import

  • 5 December 2017
  • 1 reply
  • 4 views
H
Badge

I need to import shape data into MS SQL spatial database from various file geodatabases. My workspace will be published on the FME server where .net service will call it.

The structure of the fgdb is always the same shape_length, shape area and AO number.

The feature class name is different in each fgdb. Is there a ways I can have global user parameter to read any feature class name from fgdb???

The other choice I would have is to receive the feature class name from the API service and pass as user param but I am not sure if this would work. Any suggestion??

@hcode

@takashi

1 reply

fmelizard
Rank
Userlevel 4
Badge +13

Hi @hcode

when adding the reader, if you set the 'Table List' as empty I would expect it to read all the tables in the File Geodatabse. Selecting 'Single Merged' like you have I think is the way to go here.

 

Let us know how it goes setting it like that.

 

Also be aware that because File Goedatabase is like a folder there can be some complications at times - you may need to stick it in a zip file before it is uploaded to FME Server

Reply


Community Stats

28,670
Posts
109,366
Replies
36,531
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.