Skip to main content

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

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