GeoMedia Oracle Databse to shared with ArcDeskop via ArcSDE

[AbdulRauf]

I am recently working on Geomedia and oracle at backend as database..Now a new department has been merged into ours and they are using ESRI Products. Now the problem is that they are going to share our database into their studies.

So what steps are to be taken further as I've installed ArcDestop at client side and ArcSDE at server. They have connected to database and can see the tables but not as feature classes.
What changes should be done to view the tables as feature classes.

Regards...

[BruceHarold]

Hi Rabdul

This is quite a big topic.  At the simplest level, Oracle Spatial (SDO) geometry is directly readable by ArcGIS 10 as Query Layers, subject to you being able to make a query that satisfies query layer dependencies:  http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00s500000027000000.htm

If you need to continue managing your data with Geomedia but also support write access from ArcGIS, the Data Interoperability extension will enable write access to Oracle Spatial tables.

If you will be migrating data management tasks to ArcGIS then installing SDE is required, plus registering your existing tables in the resulting geodatabase.  It is recommended you engage an experienced ESRI user for this process, and it sounds like you may have internal staff able to help.

Regards

[AbdulRauf]

Thanks for the reply.

I've tried connecting ArcDesktop to Geomedia oracle database using Interoperability Connection --> Reader as Oracle spatial 8i.

Connection is made and i can see the geomedia layers in the database but once added in Desktop no features are visible. There attribute table can be viewed but with a problem, Arabic characters appear as garbage.

Second Edit session says the layer cannot be edited.

Now the questions are how to make the features visible and how to get write access via interoperability connection.

[BruceHarold]

Hi Abdul

An interoperability connection is read only.  To write into your Oracle Spatial database you need to use either the Quick Export tool in the Data Interoperability tools or a Spatial ETL tool.  Please see here:  http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Creating_a_spatial_ETL_tool/004m000000...

You cannot use interoperability connections as editable layers.

If you cannot see spatial data in an interoperability connection it may be because the table you are viewing does not have an SDO geometry column.  Please verify this with your database administrator.  The scrambling of the Arabic characters may be an issue with the client or DBMS.  Try making an OLE DB connection to Oracle from ArcCatalog and see how the tables display.  Check your locale ID in the connection is correct:  http://msdn.microsoft.com/en-us/library/0h88fahh

If you cannot get the OLE DB connection displaying correctly please log a support call with your distributor.

Regards