Home » Other » General » Oracle Database linking to Visio 2003
Oracle Database linking to Visio 2003 [message #350094] Wed, 24 September 2008 02:16 Go to next message
cziera
Messages: 11
Registered: September 2008
Location: Dasmariñas Cavite
Junior Member

Hi guyz!
Have a great day!
Is there's a possibility to connect oracle database to Microsoft Visio 2003. I just need in creating an ERD and DFD in Visio 2003.
Could someone help me?
Thanks in advance...
Godspeed!
Re: Oracle Database linking to Visio 2003 [message #350105 is a reply to message #350094] Wed, 24 September 2008 02:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Can Visio see MS Access? IF so, then it can probably see an Oracle database via ODBC.

David
Re: Oracle Database linking to Visio 2003 [message #350118 is a reply to message #350105] Wed, 24 September 2008 02:50 Go to previous messageGo to next message
cziera
Messages: 11
Registered: September 2008
Location: Dasmariñas Cavite
Junior Member

Tnx...
I already found an Oracle server in visio driver but the data sources selection are only dbase files, excel files, MS Access database, Visio Database sample, Visual FoxPro database and Visual FoxPro table.
I dont know what data sources will be needed for an Oracle database.
Another question, is there's a way that if i had modified the ERD (tables), the changes will also reflect on the oracle dbase?
tnx a lot...
Smile
Re: Oracle Database linking to Visio 2003 [message #350119 is a reply to message #350118] Wed, 24 September 2008 02:54 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do you have an Oracle database installed on your PC? What version of Oracle database is of interest to you?

Concerning changing the table structures, can Visio 2003 change the table structure in an MS Access database?

David
Re: Oracle Database linking to Visio 2003 [message #350233 is a reply to message #350119] Wed, 24 September 2008 08:17 Go to previous messageGo to next message
rleishman
Messages: 3700
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Visio Professional Edition 2003 can Reverse Engineer (ie. Import) a database model from an Oracle database. You need to have the Oracle Network Client installed on your PC and your TNSNAMES properly populated if the database is remote. You also have to set up an ODBC connection.

Visio for Enterprise Architects (part of Visual Studio) can also Forward Engineer an Oracle database. ie. It can build tables and indexes from the Visio model.

Visio Enterprise Edition 2000 (before Microsoft bought it and crippled it) can also export a Visio 2000/2002 data model into ERwin ERX format. I use this feature in my current project to convert a vendor's Visio Professional 2007 data model: save as 2002, open in Visio Enterprise 2000, export to ERX, import into ERwin.

Visio Enterprise is available on EBay for under US$100. I got mine for about US$70.

Ross Leishman
Re: Oracle Database linking to Visio 2003 [message #350375 is a reply to message #350233] Wed, 24 September 2008 20:18 Go to previous messageGo to next message
cziera
Messages: 11
Registered: September 2008
Location: Dasmariñas Cavite
Junior Member

How can I set up an ODBC connection? What are the things needed?
tnx...
Re: Oracle Database linking to Visio 2003 [message #350381 is a reply to message #350375] Wed, 24 September 2008 20:45 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at this thread http://www.orafaq.com/forum/m/286342/72104/?srch=heterogeneous#msg_286342

David
Re: Oracle Database linking to Visio 2003 [message #350516 is a reply to message #350381] Thu, 25 September 2008 04:47 Go to previous messageGo to next message
cziera
Messages: 11
Registered: September 2008
Location: Dasmariñas Cavite
Junior Member

Thanks for the link...
I'm just confused about HSODBC and ODBC.
A matter of help to me if I could set an ODBC connection linking to an oracle database as a data source.
Most articles I had read gives an example of .mdb files.
Could someone help me?
Thanks a lot..
Re: Oracle Database linking to Visio 2003 [message #350531 is a reply to message #350516] Thu, 25 September 2008 05:35 Go to previous messageGo to next message
rleishman
Messages: 3700
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Heterogeneous services allows Oracle to connect to another database, but don't you just want Visio to connect to Oracle?

In Windows XP, Srart->Control Panel->Administrative Tools->Data Sources (ODBC)

Add a new System DSN choosing Oracle as the connection type and supplying your Oracle credentials in username / password / connection string.

Note that you must have already installed the Oracle client on your PC and set up a TNSNAMES file.

Ross Leishman
Re: Oracle Database linking to Visio 2003 [message #350676 is a reply to message #350531] Thu, 25 September 2008 21:28 Go to previous messageGo to next message
cziera
Messages: 11
Registered: September 2008
Location: Dasmariñas Cavite
Junior Member

Thanks for that. you get what I mean...
Smile
Could the changes in Visio reflects also on the Oracle Dbase?
tnx..
Re: Oracle Database linking to Visio 2003 [message #350695 is a reply to message #350676] Thu, 25 September 2008 22:57 Go to previous messageGo to next message
rleishman
Messages: 3700
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You want to FORWARD ENGINEER the database from Visio. ie. Create tables and indexes based on your Visio ERD.

This functionality is available in Visio for Enterprise Architects, and in Visio 2000 Enterprise Edition (see post above).

Ross Leishman
Re: Oracle Database linking to Visio 2003 [message #350697 is a reply to message #350695] Thu, 25 September 2008 23:05 Go to previous messageGo to next message
cziera
Messages: 11
Registered: September 2008
Location: Dasmariñas Cavite
Junior Member

How about if there's an existing?
How can I do it?
tnx
Re: Oracle Database linking to Visio 2003 [message #350764 is a reply to message #350697] Fri, 26 September 2008 04:48 Go to previous messageGo to next message
rleishman
Messages: 3700
Registered: October 2005
Location: Melbourne, Australia
Senior Member
If it is pre-existing, you need to Reverse Engineer from Oracle before you Forward Engineer.

I don't know how good Visio is at generating ALTER TABLE statement when you make changes to the model.

In truth, Visio is much more a diagramming tool than it is a CASE tool. If I were you, I would get a real CASE tool like ERwin. I have also seen Oracle Designer work, although I am not a fan of it.

Ross Leishman
Re: Oracle Database linking to Visio 2003 [message #443542 is a reply to message #350094] Tue, 16 February 2010 03:14 Go to previous messageGo to next message
Bettycarson
Messages: 1
Registered: February 2010
Location: Portland
Junior Member
Am not sure about Oracle, but there are many Add-Ons that you can interlinking to your Microsoft Visio shapes. This will help you to learn to protect shapes, create and modify Shape Masters and convert an image into a Shape Master. Also, Exercise more control over your charts and graphs with Visio and discover how to create exciting marketing templates.
Re: Oracle Database linking to Visio 2003 [message #565061 is a reply to message #443542] Thu, 30 August 2012 04:56 Go to previous messageGo to next message
Tomokofreer
Messages: 3
Registered: August 2012
Junior Member
I dont know what data sources will be needed for an Oracle database.
Re: Oracle Database linking to Visio 2003 [message #565087 is a reply to message #565061] Thu, 30 August 2012 08:12 Go to previous message
BlackSwan
Messages: 22786
Registered: January 2009
Senior Member
>I dont know what data sources will be needed for an Oracle database.
Neither do we

Please do not highjack other people's thread that are 2+ years old.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Previous Topic: To be a Oracle Apps DBA is it mandatory one should be core DBA professional
Next Topic: Documentation
Goto Forum:
  


Current Time: Wed Sep 17 11:16:25 CDT 2014

Total time taken to generate the page: 0.06450 seconds