Export topology into oracle database

[Anonymous]

Hi,

can someone help me to export topology into oracle spatial database like oraexport command but using visual studio c#. Thanks for help

[Anonymous]

Hi,

give us some details:

- what have you tried so far?

- what is background / purpose of your application? Why do you need to have an app at all?

- how familiar are you with Map / Oracle etc.?

- what kind of topology?

- do you want to transfer Map topology members to Oracle Spatial geometry or do you want to map Map topology to Oracle topology?

Rob

[Anonymous]

thanks for reply ron. I'm using autocad map 3d for and have routine to draw
some 2d parcel, clean in (as closed polyline), create topology to the
parcel layer (ex. layer parcel name is "020100"),
and then manually using command "_oraexport" to export into oracle spatial
database. The purpose is to do "_oraexport" command in background using new
command (like [CommandMethod("myoraexport")]) that create using objectarx
.NET using c#,
because i'm familiar with it language. i'm new with oracle spatial. i
create 2d topology with polygon option as topology type. any option like
transfer Map topology members to oracle spatial geometry or map Map
topology to Oracle topology is very useful. Thanks

[Anonymous · Accepted solution]

Hi,

so you know the API for creating/maintaining Map topologies but you don't know much about how to export to Oracle Spatial?

I don't have a solution just a hint - either you use

* Map API for connecting to Oracle and saving data back using Map API and FDO
--> there are samples available, also some written documentation by Autodesk and course material provided by ADN
http://adndevblog.typepad.com/infrastructure/2012/05/inserting-fdo-features-into-sql-server-using-ge...
\Map ObjectARX SDK 20XY\Map Samples\Platform

or

* connect to Oracle via .net / Oracle.net
--> documentation available as well

I assume in both cases you need to "translate" the topology into FDO or Spatial geometries yourself as I don't think Map API has a converter for that.

Rob

[Anonymous]

Hi ron. thanks for the suggestion. I'll try on it.