Messages

1

General Board / How to hide Work In Progress in a shared model

« on: October 30, 2008, 07:56:36 pm »

I am working on trying to introduce EA into my organisation where we will have up to 200 analysts and designers working on various models - not all concurrently - approx 40 concurrent. I'd like to get some views on the proposed options - pitfalls etc.

The 2 options currently being considered for the deployment are

1) a shared model approach using SQL server + version control
2) a local model approach using EAP file + version control (in effect using the version control system as the master repository). Each user then gets the bit of the model (and its dependencies!) that they are interested in into their own locla workspace/model.

Any thoughts on the best option?

In terms of the models these will be representative of business processes and applications that support those processes. Over time various projects will come and go and be updating the models to move the business and its applications forward.

Before deciding on the most appropriate approach I have a specific question.

Specific questions:

1) Is there any way when using a shared model to hide work in progress from other users? This would mean we could get the benefits of managing, comparing and securing a shared model in SQL (local models seem a bit flaky at times) and allow users to work on the models before committing to the 'master'.

I realise I could export the packages I am interested in to a local EAP file but that seems like quite an overhead and then means each analyst is responsible for backup etc.

2) If we went down the shared model route what is a good configuration. All models in a single SQL database? - are there known size limits / issues etc.? There will be cross dependencies between model packages, typically at the service interfaces.


3) Does anyone have an example of code (C#/java)that uses the automation interface to export packages as XMI?

Thanks.

Andy

2

General Board / local editing in central repository model

« on: October 07, 2008, 04:16:48 am »

Is there a way to work locally (check out locally) whilst using a shared sql server repository i.e. can you have a local "workspace" within the central model, allowing uncommited changes to be kept separate from other users' view of the model?

Example v3 has a caption "capture cheque detail" this version has been checked out locally by user 1 and caption changed to "capture CHQ detail". Changes have been saved but not checked in. Wehne user 2 looks at the model element they see "capture CHQ detail" and not v3. How can we configure EA to enable user 2 to continue to see v3?

Andy

3

General Board / Re: SQL permissions

« on: October 01, 2008, 08:53:22 pm »

Hi Andy,

Did you do a project transfer to 'seed' the project data?

If not, create an empty (or non-empty, but with your basic structure set the way you want) project in an EAP file. Then open EA - you don't need to open a project - and from the main menu choose Tools | Data Management | Data Transfer. On the dialog, choose the .EAP to DBMS option button, then use the browse (i.e. "...") buttons to select you .EAP file and your new repository. Note that you will erase the target project. Then run the transfer.

Once that is done, try opening your repository.

David

David - did what you suggested and worked - thanks

Andy.

4

General Board / SQL permissions

« on: September 29, 2008, 11:51:16 pm »

Have just created a MS SQL database on a SQL server and followed the instructions to attach from EA. When I open the project EA just seems to sit there doing nothing. I have previously installed and used a locla SQL database on my laptop without any problems. Is it likely to be a permissions problem? If so what pwemisssions need to be set?

Any help appreciated.

Andy.

5

Automation Interface, Add-Ins and Tools / Re: UML Profile - Archimate

« on: November 04, 2008, 09:08:30 am »

Bob, let me know when you have it working - cheers Andy

6

Automation Interface, Add-Ins and Tools / Re: UML Profile - Archimate

« on: November 04, 2008, 06:46:36 am »

@ Segun: I saw your suggestion in an old Forum entry about Archimate and placed a feature request before I added this Forum entry. However, I hope I might be able to get something up and running using UML Profiles before Sparx adds support.

If you think you can help please let me know, as you seem to have an interest in getting Archimate support. Thanks,   :bob

Bob if you do manage to get a UML profile working would you be prepared to share it - I am interested in getting Archimate use inside EA. I'll post a request for the feature too.

Andy

7

Automation Interface, Add-Ins and Tools / Re: Example of API use in C# for SQL access

« on: November 05, 2008, 07:58:26 am »

thanks - that has done it

8

Automation Interface, Add-Ins and Tools / Example of API use in C# for SQL access

« on: November 03, 2008, 10:56:52 pm »

Hi

Does anyone have an example of how to connect to an EA repository implemented in SQL server via C#? I can connect to an EAP (via OpenFile) but can't seem to find the equivalent syntax to connect to the SQL repo.

Thanks.

9

Automation Interface, Add-Ins and Tools / Setting Package Security

« on: November 04, 2008, 12:12:35 am »

Is it possible to prgramatically set the package security and if so anyone got an example? Need to do this on a regular basis to apply the same security settings to packages that are added to a model. If you can't do it programatically then the only other option seems to be for someone to manually re-apply security settings when a new package is added - that is a bit limiting!

If you can set the security in this way is there a way to suppress the security and VC system login prompt as I would want this to be run on a schedule in the background not by a user needing to login as thta woudl defeta the object i.e. if a user had to login then they coudl manually set the security anyway.

Any help appreciated - ta

Andy