Messages

1

General Board / Re: How to compress diagram?

« on: February 28, 2013, 09:13:58 am »

Truly splendid.  Thank you!

2

General Board / How to compress diagram?

« on: February 28, 2013, 08:48:59 am »

I have a diagram that's organized in a circle layout (see image).  It has a center focused element.  Is there an option somewhere to condense the circle so that the objects on the outside of the circle are closer to the hub?  I'm guessing there is, it would be tedious to do this manually.

See image here:
http://home.comcast.net/~bjw122/images/circle.jpg

You can't see the objects on the end of each line, but they're there -- out of view.  I want to draw them in close to the hub.

Thank you

3

General Board / Re: Trouble Connecting to Oracle Database via ODBC

« on: February 07, 2013, 01:48:52 am »

Thank you.

EA Support contacted me and said:

Thanks for the note.
 
That the Oracle ODBC driver does not appear in EA's ODBC Data Sources suggests the 32-bit client is not installed.
 
EA requires 32-bit drivers.
 
Please refer to the Notes section on page...
http://www.sparxsystems.com/enterprise_architect_user_guide/9.3/database_engineering/importdatabaseschemafromod.html
 
 
Please uninstall the 64-bit client and install the 32-bit client. We recommend ODTwithODAC1110720 - available here ...
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html




This resolved my issue.

4

General Board / Trouble Connecting to Oracle Database via ODBC

« on: February 04, 2013, 11:19:29 pm »

I'm evaluating the trial version of EA 10 as a Database Engineering tool before potentially making a purchase.

I'd like to use the "Database Engineering" --> "Import DB From ODBC..." option against my Oracle 11gR2 database.

I'm on Windows 7 x64 so I installed the "Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64)" software so that the correct ODBC drivers get installed.  After that I started the "Windows ODBC Data Source Administrator" application by running "C:\Windows\SysWOW64\odbcad32.exe" and created a data source.  When I use the option to test my connection, the test completes successfully.

See image here:
http://home.comcast.net/~bjw122/images/1.jpg

Now I start up EA 10.0 and go to "Import DB From ODBC...".  I select the "Machine Data Source" that I had defined, and I immediately get an error "Unable To Obtain Table Information".

See images here:
http://home.comcast.net/~bjw122/images/2.jpg
http://home.comcast.net/~bjw122/images/3.jpg

Oddly enough, if I go to create a new Data Source using the EA screens, I don't see my Oracle Driver listed so that could be an indication of where the underlying problem is.  See images here:
http://home.comcast.net/~bjw122/images/4.jpg

Thank you for your assistance.

5

General Board / Re: Merge Classes From Multiple Packages

« on: December 09, 2010, 02:22:06 am »

If I just drag and drop all of the classes into a new project the associations are maintained in the new diagram for the project, however I would need to re-organize the classes in the diagram because their arrangement gets all messed up.  This would take considerable time because there are a lot of associations.  Do you know of a way to copy objects from a diagram to another diagram and have the organization of the objects maintained?

I've discovered that if I create a new project, then click on one of the diagrams that I want to copy into the new project I can do "Copy Diagram" --> "Paste Diagram" and choose the "Deep (duplicate ALL elements)" option and that maintains the organization of the classes in the diagram.  Now, I want to copy the second schema into the same (new) diagram, but I can't figure out how to copy a diagram and paste into an EXISTING diagram (which would do a diagram merge).  Any ideas?

6

General Board / Re: Merge Classes From Multiple Packages

« on: December 09, 2010, 01:51:50 am »

Hi Geert -

Thanks for your help.

I want to have all of the tables represented on one diagram because I've reached a point in my data modeling where I need to create relationships between tables that currently appear in separate schemas, one schema per EA project.  FK relationships between schemas are supported in Oracle (cross schema FK constraints).

If I use the OWNER attribute in EA I can assign each table to a schema, but all of the schemas can be represented in one physical data model.  That's nice because then I can create cross-schema FK constraints right in EA, whereas if the objects I want to connect via a FK constraint exist in separate projects (schemas) EA won't allow me to form an association between the tables.

If I just drag and drop all of the classes into a new project the associations are maintained in the new diagram for the project, however I would need to re-organize the classes in the diagram because their arrangement gets all messed up.  This would take considerable time because there are a lot of associations.  Do you know of a way to copy objects from a diagram to another diagram and have the organization of the objects maintained?

7

General Board / Merge Classes From Multiple Packages

« on: December 08, 2010, 05:37:43 am »

I have several packages in my EA project, wherein each package contains one physical data model diagram and the classes (tables) that are used in that diagram.

I would like to create a new project that has a single data model diagram in it that contains all of the classes from each other project.  Furthermore, I would like the new data model diagram to include all of the classes.

So, basically, I'm asking if there's a way to merge several packages into one new package, and have the data model diagrams be merged too.  I want to avoid having to re-create the associations (FK relationships) between the classes during the merge.

I tried this process:
1.] Created a new package, "Merged Physical Data Model"
2.] Exported one of the packages, "Core Schema", using the "Export Package to XMI file" option.  The Export completes successfully.
3.] Click on the "Merged Physical Data Model" package and selected "Import Package from XMI file", setting "Treat Import Datatypes" to  "DDL:Oracle", but I got this error:

Error:  Root import package already exists in another location.
Conflict is with existing package: 'Core Schema'.

So, even though I'm importing into a different project (Merged Physical Data Model) I'm getting an error about a conflict with a package in another package (Core Schema).

My hope was that I could use Export/Import to export all of the objects from their separate projects and import them into a single new project.

Any ideas on how to accomplish what I'm trying to do?  Again, I'm really trying to avoid having to re-draw the data model diagrams, I simply want to merge the diagrams into one large diagram.

8

Bugs and Issues / Re: Help Showing Attribute Notes in Project Browse

« on: August 11, 2009, 03:50:20 am »

That did the trick!  Thank you!

 

9

Bugs and Issues / Re: Help Showing Attribute Notes in Project Browse

« on: August 10, 2009, 10:37:22 pm »

I've got the Notes and Project Browser windows open, both floating instead of docked.  Then I stack the Project Browser window on top of the Notes window so that both are visable.  This is okay but not the solution I was looking for.

I feel certain that the Notes window used to appear within the Project Browser window (at the bottom) - so that the two windows didn't need to be stacked.  Maybe there is a view that allows for this?  I see a View --> Model Views window but no views defined.

Thank you

10

Bugs and Issues / Help Showing Attribute Notes in Project Browser

« on: August 04, 2009, 05:32:53 am »

I'm running EA 7.5.845 and earlier today I did something that resulted in my ability to edit attribute notes from directly within the project browser to disappear.  In other words, the notes window used to show up under my list of classes, now it shows up as a separate tab in the project browser.  Any idea what I need to do to get it back the way it was?

11

Automation Interface, Add-Ins and Tools / Re: Oracle ODBC Driver's Required for Reverse Engi

« on: August 02, 2007, 02:26:07 am »

Got it, thanks.

12

Automation Interface, Add-Ins and Tools / Oracle ODBC Driver's Required for Reverse Engineer

« on: August 01, 2007, 07:26:23 am »

If I want to use the reverse engineering feature against an Oracle 10gR2 database are the Oracle ODBC drivers a required installation?
I'm using EA Corporate Edition.
In the EA Help, under "Setting Up a Database Repository", "Setting Up an ODBC Driver" sub-section it states that:
"Setting up an ODBC driver is only necessary for MySQL, PostgreSQL and Adaptive Server Anywhere. The other supported databases connect using OLE DB, so this stage can be skipped."

However, I'm not setting up a database repository, I'm trying to use the reverse engineering feature.

Thanks.