Skip to main content
Question

SDE30 Table prefix


Hi,

 

I want to access via FME Reader SDE30 to a table with a SDE_ prefix.

 

But i can't see this table in the table list of the reader.

 

Is that normal ?

 

 

Thanks

 

 

Julien

david_r
Evangelist
  • January 14, 2014
Hi,

 

 

are you trying to read the SDE metatables? If so, just use the appropriate non-spatial database reader, e.g. the "Oracle Non-spatial" (ORACLE8I_DB) reader.

 

 

The SDE30 and GEODATABASE_SDE readers will only show you the tables that have been registered with SDE, i.e. feature classes.

 

 

David

In fact, i have tried some tests like : creating a table named toto with arcgis. I can read this table withe an fme reader (sde30) but when i renamed this table in sde_toto : i can't see anymore this table in the table list.

 

 

So i figured that fme filters the table with an sde_ prefix ?

david_r
Evangelist
  • January 14, 2014
I guess it is either FME or ArcSDE that filters out the tables starting with "SDE_". I don't know which :-)

 

 

Is there a particular reason for wanting to read these tables with the SDE30 reader rather than a reader specific to the backend database?

 

 

David

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings