11
May
09

Using Map 3D 2010 with Oracle? Better use 10G client!

Hi All, here’s one that stumped me (I should have read the documentation!).

If you want to connect AutoCAD Map 3D 2010 to Oracle with FDO, remember to use the 10G client and not the 9i one. Even if you are connecting to a 9i database.

That one stumped me for a while.

gordon

Advertisements

16 Responses to “Using Map 3D 2010 with Oracle? Better use 10G client!”


  1. 1 nadirah
    August 26, 2009 at 7:52 am

    hi..
    i want to ask you one question.
    did you know how to link Oracle database with Autodesk Map 3D?

  2. August 27, 2009 at 12:02 am

    Certainly. I do this all the time. You can use FDO (either the Autodesk one or the SL KING).

  3. 3 nadirah
    October 12, 2009 at 8:11 am

    can oracle XE connected with autodesk map3d 2010?
    could you give me the manual

  4. November 5, 2009 at 8:19 pm

    Sure,
    just create a new datastore – log into oracle
    create new datastore
    Create a new datastore – with coordainte system and extents

    Then save it, do not bother adding tables and features yet

    Then drag and drop your data (i.e. SHP files into AutoCAD Map) and then Bulk Copy into Oracle
    bulk copy

  5. 5 shilpa
    March 24, 2010 at 12:47 pm

    Hi,
    i did the same procedure for exporting shape file from autocad 3d 2010 to oracle 10g Express edition…..

    but how can i view the exported data in oracle spatial?iam unable to view this data as a table…
    how this data will be stored in oracle 10g express edition?what is the query for seeing this data??

  6. March 24, 2010 at 1:11 pm

    In Oracle (or Oracle Express), you can view the data in either Map 3D or MapGuide. Just use the FDO Connector (see above)

    Also, if install SQL Developer from Oracle (http://www.oracle.com/technology/software/products/sql/index.html)
    And install GeoRaptor (http://sites.google.com/site/mygeoraptor/installation)

    you can view the data…

  7. 7 shilpa
    March 25, 2010 at 4:38 am

    Hi Gordon,
    Thanks for your reply.yes,iam able to view the data in mapguide.but i want to query the data in oracle…by using oracle query….

    i mean by querying select * from is there any possiblity to see the exported data…

    how the data will be stored in oracle (table? or view??).
    because i have exported shp file data from map3d to oracle 10g XE

    by typing the query
    select * from tab; in oracle iam unable to view the datastore name given in map3d….

  8. March 25, 2010 at 3:57 pm

    Try logging into oracle with the Datastore name and password you used when you set it up. That is the schema that the data is now in.

    You can view the data with GeoRaptor..

    regards
    gordon

  9. 9 shilpa
    March 29, 2010 at 3:52 am

    Hi,
    after exporting the shape file from map3d 2010 to oracle spaatial 10 g Express Edition,iam unable to select the data on mapguide ajax viewer ..
    is there any specific oracle settings are there to select feature on mgos?

  10. March 29, 2010 at 1:54 pm

    Yes, you will have to make sure that there is a Primary Key set on the table. Other than that, check your settings in Maetro or Studio…

  11. 11 shilpa
    April 5, 2010 at 12:10 pm

    Hi,
    Thanks for your reply.yes i just want to set the primary key to my table.is it possible without sql developer??
    i mean you are saying that

    Try logging into oracle with the Datastore name and password in the previous reply.
    How it will happen?where i have to type (sql command) for this??please send me thesql command..

  12. April 5, 2010 at 1:06 pm

    try
    ALTER TABLE PARCELS
    add CONSTRAINT constraint_name PRIMARY KEY (PARCEL_ID)

    for example…

  13. 13 shilpa
    April 6, 2010 at 7:27 am

    Hi,
    Thanks for your reply.
    i know oracle command for setting primary key to a table
    waht iam asking is by Exporting data(from map3d 2010 to oracle 10g XE)its storing as a datastore not a table.
    the problem is iam unable to get the table

    for example
    while typing select * from tab;
    the PARCELS table doesn’ exist..
    in which format the exported data will be stored in oracle (table or datastore)
    please tell me command to retrieve the datastore

  14. April 19, 2010 at 1:38 pm

    A datastore is just a user in Oracle. You have to use select * from datastore.PARCELS to get the data.

  15. 15 shilpa
    April 23, 2010 at 12:31 pm

    Hi,
    Thanks for ur reply.But iam unable to select the oracle data on mapguide Ajax viewer after checking the option layer is selectable also.

    Please help me in this regard.

  16. April 23, 2010 at 1:09 pm

    You just need to an Primary Key..other than that, I would recommend asking the MapGuide OpenSource Community at:
    http://osgeo-org.1803224.n2.nabble.com/MapGuide-Users-f1803227.html

    regards


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: