Select to view content in your preferred language

Accessing data in Oracle tables

1204
6
11-02-2011 12:59 PM
HarryBoswell
Deactivated User
Can someone point me to books or tutorials that would cover the various ways of incorporating data in Oracle tables into ArcGIS applications?  I know that you can do things like create feature classes from Oracle tables, but I would really like to know and be able to utilize all the ways this could be done.  I'm an Oracle DBA with some training in ArcGIS, so I have some knowledge of the Arc world, but I need more concrete examples than what I've seen in classes.

Thanks,
Harry
0 Kudos
6 Replies
DerekLaw
Esri Esteemed Contributor
0 Kudos
HarryBoswell
Deactivated User
I know you could also register the tables, but I'm a little confused - there's registering the table with SDE, and registering the table with the geodatabase.  I'm not sure I understand the difference.

Harry
0 Kudos
VinceAngelo
Esri Esteemed Contributor
It is a bit confusing.  ArcSDE is both a product that lives in an SQL database and the API/protocol to
access that data.  ArcSDE registers tables in the TABLE_REGISTRY so that it can maintain metadata
about their status with respect to ArcSDE.  The geodatabase is the ArcObjects code accessing database
tables via the ArcSDE API.  It, too, has a registry, implemented in many (or a few, if you're running
ArcSDE 10.0 or higher) GDB_* tables (which in turn are registered with ArcSDE).

When you register a table with ArcSDE, it's still not available to participate in geodatabase behavior
(feature datasets, relationships,...).  ArcSDE-registered tables *are* avaiable for use as simple
feature classes in the geodatabase.  If you register a new table with the geodatabase, it will force
ArcSDE registration if that has not been yet accomplished.  No ArcSDE command can register a table
with the geodatabase (ArcSDE is not geodatabase-aware).

- V
0 Kudos
DerekLaw
Esri Esteemed Contributor
Hi Harry,

Just to add onto what Vince posted, please review this ArcUser technical article:

Enterprise Geodatabase 101

Hope this helps,
0 Kudos
HarryBoswell
Deactivated User
Hi Harry,

Just to add onto what Vince posted, please review this ArcUser technical article:

Enterprise Geodatabase 101

Hope this helps,


Thanks, Derek, that looks great!

Harry
0 Kudos
HarryBoswell
Deactivated User
Am I wrong in thinking that query layers are going to be the preferred way of including external database data in GIS apps?  They just seem like such a better way of incorporating database data.  Are there situations where they wouldn't be appropriate?

Thanks,
Harry
0 Kudos