Question

SDE30 Table prefix

  • 14 January 2014
  • 3 replies
  • 1 view
J
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

3 replies

david_r
Rank
Userlevel 4
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
J
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
Rank
Userlevel 4
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

Reply


Community Stats

28,729
Posts
109,527
Replies
36,565
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.