Sign in
 
Home20132010Other VersionsLibraryForumsGallery
TechCenter >
> 
> 
Creating Database model diagram using tables from Oracle in MS-Visio 2010

Answered Creating Database model diagram using tables from Oracle in MS-Visio 2010

  • Wednesday, July 18, 2012 11:35 AM
     
     
    Sign In to Vote
    0

    Hi,

    I want to create the Database diagrams using MS-Visio for which i want to get table structures from oracle which resides on another machine.

    How can i connect to oracle database from MS-Visio?

    Any help would be very appreciated. :)

    Thanks,

    Mahesh

    Thanks, Mahesh

     

All Replies

  • Thursday, July 19, 2012 8:24 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi,

    You can try to connect Oracle data via ODBC or OLEDB.

    1. In Visio 2010, Click File -> New, under Template Categories, select Software and Database.
    2. Double-click Database Model Diagram.
    3. Click Data tab.
    4. In External data group, click Link Data to Shapes.
    5. In Data Selector dialog box, select Other OLEDB or ODBC data source, and click Next.
    6. In Data Connection Wizard dialog box, point to Microsoft Data Access - OLEDB Provide for Oracle, and click Next.

    Best regards.

    William Zhou

    TechNet Community Support


     
  • Thursday, July 19, 2012 8:45 AM
     
     
    Sign In to Vote
    0

    Hi William,

    Thanks for reply.

    I have tried steps given by you but i am getting following error.

    ORA:-12154:TNS:Could not resolve the connect identifier specified.

    Values i have inserted in fields are as

    Server Name:- i tried both TNS name and Oracle hostname

    User name and Password:- I given appropriate username and password.

    Are there any other steps to be followed before this or anything like that?

    Thanks,

    Mahesh

    Thanks, Mahesh


     
  • Thursday, July 19, 2012 9:18 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

    Please check following links for error "ORA-12154", hope this helps:

    http://ora-12154.ora-code.com/

    http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/06/30/ora-12154-tns-could-not-resolve-the-connect-identifier-specified-error-while-creating-a-linked-server-to-oracle.aspx


    Best regards.

    William Zhou

    TechNet Community Support