Skip to main content
Question

SDE30 Table prefix

  • January 14, 2014
  • 3 replies
  • 22 views

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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

david_r
Celebrity
  • 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

  • Author
  • January 14, 2014
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
Celebrity
  • 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