Messages

1

General Board / Re: EA on ORACLE Database

« on: November 05, 2007, 12:03:37 pm »

Thanks Glen,

were you running a local install of Oracle or was that a networked version?

My version is on the network and the DBA reckons the DB access only takes about 10 seconds, so the time is lost somewhere on the network and in the pre-prep and presentation...

Al

2

General Board / EA on ORACLE Database

« on: October 29, 2007, 06:36:49 pm »

Hi guys,

we have just begun testing EA using an ORACLE Database and my initial connection time following the upload of 42Mb of data was 3 minutes...

This is not really acceptable from a user perspective these days and I was wondering if this is usual or if our configuration could be tweaked in some way?

Any ideas?

Al

3

General Board / Reporting Object Details from Diagrams

« on: October 29, 2007, 02:45:02 pm »

Hi All,

have had a fair measure of success using the RTF generator, but would really like to be able to produce reports based on diagram content, not just object names, but object detail...

Is there anyway I can achieve this without moving the required objects into a package in the report?

Thanks

Al

4

General Board / DDL Transforms for ORACLE

« on: October 23, 2007, 08:41:49 pm »

Hi All,

Have been having an interesting time with EA trying to generate ORACLE compliant Table and Column names from our Enterprise Class Model... Eventually I had to write my own set of intermediary code to achieve this... Ideally I would like to abbreviate our class names with a standard list of abbreviations... I wanted to do this using a  single function for all Table / Column and foreign keys assignments... can anyone help me?

Al

5

General Board / Attribute Mapping

« on: October 01, 2007, 03:35:56 pm »

Hi guys,

I managed to come up with an obvious fudge (retrospectively) for attribute mapping and this consists of creating a 'Mapping Class" with traceability links between the Source Class/Table and the Target Class/Table.

Since EA supports both Attribute and Column definitions in the same Class - it is possible to drag both source and target attributes/columns into a seperate class and position them one after another in sequence,
eg:
source: SURNAME
Target: family name
Source: FIRST_NAMES
Target: given names
etc...

The beauty of this approach is the mapping is graphical and mapping ( and transformation) rules can be added to the class as operations/methods as required.

If you need any further detail on this, let me know....

regards

Al

6

General Board / Re: Attribute Constraints

« on: August 02, 2007, 12:41:22 pm »

Hi... I posted this a while back and have since recreated the reports and the problem seemed to go away... I was using a 'fudge' to trace multiple source column mappings to a target logical enterprise data model (for a NSW Education). I was using the constraints as a way of tracing the various sources, tables, column names & data types...

It was possible to do a high level trace diagrammatically at the Class/Table level using trace relationships...  but there was no way to trace and report at the attribute level...

So I am quite happy that I can now produce documents that give a complete report of each source column used to produce the integrated model.

My suggestion to you, is to create a new report and try again, sometimes the RTF generator, seems to get it's parameters in a knot...

not sure how though, everything looks OK on the surface, but under the covers, it seems to lose something...

And I'm not talking virginity here

hope this helps..

7

General Board / Attribute Constraints

« on: May 21, 2007, 01:11:20 pm »

Firstly, let me say that I really like this tool... I used to sell full life cycle CASE tools back in the early 90's (when they were the vogue) and have used many since (incl: Rational Rose & Systems Architect)... The past 10 years ERWIN has been my tool of choice for data modelling and amazingly it has stood the test of time despite being taken up by CA... understand they are putting some process modelling capability and maybe one day an 'undo' function....

I have hit a snag with EA in trying to produce an RTF document listing attributes with constraints... the constraint entries come up as {FeatConstraint.Name}, {FeatConstraint.Type} , {FeatConstraint.Notes} but the content fails to show in the report... can anyone help?

Al

8

General Board / Re: Relationships lost on package imports

« on: June 28, 2007, 12:37:30 pm »

Thanks Thomas...

9

General Board / Re: Relationships lost on package imports

« on: June 27, 2007, 02:07:49 pm »

Thanks for this, impressed to get a response within the hour... we just recently invested in 120 floating licences, so it would be good to use them effectively

Al

10

General Board / Relationships lost on package imports

« on: June 27, 2007, 01:36:20 pm »

We currently have multiple users of EA using their own repositories (Jet Engines)- This is not an ideal situation... Which I am trying to fix... In the meantime.

I have been exporting /importing content in XMI and mapping "Project Classes" to "Enterprise Classes" - up until now this has worked really well and allows me to produce traceability matrices and mapping reports...

Yesterday I had to re-import some "Project Classes" and found that although the classes were updated via their GUIDS... the traceability and indeed any relationships to classes outside of any within the imported package... disappear...

Is there any way I can ensure these 'links' are not lost... when importing existing packages?

Is their a patch for this.... problem?

Al

11

General Board / Re: Has ANYONE EVER been successful with EA?

« on: June 26, 2007, 09:29:14 pm »

HiKimball,

Am currently putting an Enterprise Data Model together for the Department of Education in NSW Australia and having used Rational Rose, System Architect, ARIS and a host of other EA type tools at other sites... all of which are painful when it comes to getting documentation out... My preference would have been ERWIN, but they are not prepared to wear the CA licence fees... So I began using EA 3 months ago and am very happy with what it can do... I spent a fair bit of time with the RTF generator and now produce some reasonable looking documents, which we save to MS Word for final formatting.... The way I see it, since most of our modelling should be objective at least 95% of the facts (The who, what, where, when and hows) can be represented in the model content... the real problem is the other subjective 5% of justification (the whys)... I found putting this text in packages and dragging them into the 'Model Document' Class... was a lot easier than trying to maintain a MS Word document from coddled diagrams and scripts whenever the model changes... If you would like a sample of the output or some more details on the approach drop me a line... Al

12

Bugs and Issues / GUID constraints

« on: April 16, 2009, 03:22:39 pm »

We run EA off an ORACLE repository and it has been working well since V7.1. Some of our users have started getting the following error when right clicking on a specific package...  
OraOLEDB [-2147217873]
ORA-00001: Unique Constratint (EADBA.IDX_GUID_OBJECT) violated

It is a consistent problem and looks like a unique index violation by a GUID..

I ran the Project Integrity Check on All GUIDS and recovered/cleaned but the problem remains....

any idea how I can fix it?

Regards

Al

13

Bugs and Issues / EA Transforms using Generalization Sets

« on: April 02, 2008, 11:22:42 am »

Hi...

I would like to transform some Generalization Sets - (groups of Subclasses) into type tables for a physical database model (and DDL)...

How can I obtain the 'GeneralizationSet' name so I can use it in a transform?


Al

14

Bugs and Issues / Re: Refresh of EA Elements on shared Oracle Reposi

« on: March 28, 2008, 09:34:35 am »

Hi Simon,

Have had problems downloading the upgrade, I have the user id and original password, but for some reason this no longer works.

The original documentation sent with the product read "Your user ID and password give you access to the registered user section of our website at http://www.sparxsystems.com.au/registered/reg_ea.htm. This area contains important information about latest releases, product updates and support.  

Please note: We reserve the right to change your password for security reasons (we will advise via email if this is to occur). "

Our User ID is "ea0507" and I had no problems downloading version 7.0 - can you send me the new password please to my official address at the DET in NSW.

I need to download the official corporate version - not the trial version. Once I attach the licence keys is there any difference between the public and official version?

In the meantime I will try and track down who originally purchased the product as they may be sitting on the new password update email.

thanks

Al

15

Bugs and Issues / Re: Refresh of EA Elements on shared Oracle Reposi

« on: March 28, 2008, 08:58:44 am »

Hi Simon,

we are using version 7.0 build 818 - but will download 7.1 today and give the ORACLE optimisation a fair go.... thanks for that...

Will let you know if there is much of an improvement - I know that our  ORACLE load time problem was caused mainly by CLOBS (Character large objects) - do you know if this is what the optimisation involvesd... Where can I get info on the optimisation?

thanks

Al