Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Sunshine

Pages: 1 ... 32 33 [34] 35 36 ... 44
General Board / Re: Data Model - field value definitions
« on: June 29, 2011, 07:22:14 am »
For predefined data sets then use enumeration and add each value for the data set in the enumeration.
See an example here;

Alternatively you could put in the description some text like Backus Noir Form;

or you could use OCL in the constraint tab of the attribute

So there are some options. It all depends on how you want to use it.

Hope that helps  :)

General Board / Re: How to escape special characters in model sear
« on: June 14, 2011, 07:07:57 am »
If you have an EAP file then underneath its MS Access DB so use square brackets "[]". For instance searching for an Element named "MyElement?" you would enter "MyElement[?]" without the quotes into the search field.
It might be different with a SQL Server or Oracle DB repository. I Didn't have one at hand to try it out. Think it you might need to use a forward slash "\". Suggest you Google "SQL Server wildcard search" or whatever database you use to check.
Hope that helps.  :)

General Board / Re: Alternate to EA RTF generator
« on: June 10, 2011, 07:03:12 am »
As an alternative if you use SQL Server for a repository you could consider using SQL Server Reporting Services.  If you use SQL Server Express Edition is its free. :)

General Board / Re: Using Sparx to manage a Standards Information
« on: June 01, 2011, 11:40:42 am »
We have an SIB based on TOGAF in EA. We imported the information using CSV rather than typing it all in.
The trick is create a dummy standard first and then export to CSV file. Copy and paste the TOGAF fields into the relevant columns and import into an EA model. You will need to create the packages required to group the standards together for the TRM the move the Standards into the relevant package.
Hope that is the information you were after. :)

General Board / Re: EA 9 Beta
« on: March 08, 2011, 02:56:33 pm »
Great to see you testing out Version 9 Beta however is posting all the problems you find here the best place for Sparx Systems to deal with them or is there a better place?

Being picky I note the footer on your posts says
Using EA8.0 (864) on Windows XP SP3. Repositories in SQLServer2005 & Access2003/JET4.0
Isn't  quite right if you are testing V9.0 is it? 


General Board / Re: EA 9 Beta
« on: March 04, 2011, 12:04:41 pm »
Look again Graham, it mentions the following;
"Improved Document Template Design and the ability to output documentation to PDF. "

General Board / Re: "Copy" of SQL database to EAP file
« on: May 25, 2011, 07:02:54 am »
EAP files are really just MS Access Databases and it looks like your right on the limits of what it can do. The only things I can suggest at this stage are
a) create new SQL databases and transfer the data to them.
b) Use version control system such as subversion which is probably the better choice of the two.

Hope that helps :)

General Board / Re: EA 9 documentation?
« on: April 28, 2011, 06:08:38 am »
EA V9.0 is still in beta so you can install it in parallel with V8.0

Full release details and links to download files and resources can be found here:

If you want to look at the documentation then suggest installing the latest beta and looking through the on-line help.

General Board / Re: Document templates for every package
« on: May 20, 2011, 07:43:30 am »
I can only get a full report by using the "documentation button??" next to the master document.
I there a possibility to do this from elsewhere? just right-click on the project model and get the report?
[Another question: Is it possible to get only one package out of the complete build with the right template without giving the developers the possibility to change the template?
Try opening the documentation diagram and selecting one of the model documents then press key F8 and generate. You should get just that model document.
To stop others changing the generated document from MS Word you could
a) password protect it
b) Save as PDF

Not sure if you can stop people changing templates in the EA model however check out the security options under the menu  project>security. You can create a security group and restrict access to various functions. If you want them to have access to the model but not change it you could simply enable security and give them no rights to change anything. Alternatively generate an HTML version of the model
Well there are a few ideas - hope they help :)

General Board / Re: Document templates for every package
« on: May 19, 2011, 10:59:33 am »
Suggest you look at the help under virtual documents. There you'll find how to create a master document with model documents underneath. With the model document you can specify a template drag packages into it that you want to use that template. By creating a number of different model documents you can achieve your desired result.

General Board / Re: Import BPMN 2.0
« on: May 19, 2011, 11:08:32 am »
Only V9.0 supports BPMNV2.0 so you'll need that version first of all.
You don't say what file format you want import it from so you may not get the answer you are looking for.
Yes you can import via XMI file generated by other tools.

There is a visio plug-in you can use too but you'll have to import it as an activity diagram and then change types and stereo types to match BPMN V2.0.

General Board / Re: layered architecture diagram
« on: May 18, 2011, 07:26:39 am »
Use packages to represent the layers and put your classes in them. For instance you could create packages for
  • Presentation Layer
  • Business Layer
  • Data Access Layer
  • Data Layer
You may need several nested packages within these if you want to break them up further for a large system.
I haven't seen any whitepapers on how to do this in EA. The only one that comes close is by OAD Consulting but thats in the enterprise architecture space.

However if your looking for patterns of layers then if you in the Microsoft camp you may find the following useful

If your in the java camp

Alternatively if you are using another technology then just Google patterns or blueprints for the technology your using.

Hope that helps  :)

General Board / Re: Sharing my EA Shortcuts Reference Card
« on: May 05, 2011, 01:11:29 pm »
Good work Amenedo, found it really useful. :)

General Board / Re: Modelling attribute dependencies for an ETL pr
« on: May 02, 2011, 06:04:48 pm »
Another way to create relations between attributes is to use tagged values of type "RefGUID".


Interesting I didn't realise you could do that. Learn something everyday with EA. Upon further investigation you may wish to consider using RefGUIDList as some ETL mappings are not one to one but one to many or vice versa. For instance one attribute in a table in a database may go to many attributes in many tables in many other databases.

I prefer using the "link to element feature" with the trace relationship because it shows the data flows graphically between table and databases.

General Board / Re: Modelling attribute dependencies for an ETL pr
« on: May 02, 2011, 05:52:14 pm »

Nice, I didn't know that could be done. It's definately better than creating another set of "objects". In the diagram that relation is indeed visualizing source/attributes involved. But this information still doesn't appear in the HTML documentation - these relations appear in the "other links" section of the table documentation, but they don't show the source/target attributes etc.

Can I adapt the HTML templates so that these (flow/dependency) relations appear for example right with the attribute detail information, in the "attributes" section of the table documentation? (The HTML template editor scares me, to be honest...  :-[)

I don't see why you can't modify the HTML template to put in the information you want.  You have just got grab the bull by the horns and try it out. Remember backup your stuff regularly and you have those backups as a kind of parachute if anything goes wrong.
Before you start just think of answering the following question?
What information do I have to supply to whom and what format is best? If all you need to do is provide some document of the mappings from one database to another for an ETL developer to implement then consider a RTF document instead of HTML if it scares you.

As the SAS say "Who dares wins".
Or put another way by Chaucer "Nothing ventured, nothing gained".

Pages: 1 ... 32 33 [34] 35 36 ... 44