Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There is a <a href="http://www.sparxsystems.com/enterprise_architect_user_guide/9.2/automation/the_scripter_window.html">scripting</a> interface in EA. You might be able to automate the import using that. I've not used it but its probably quite good.</p> <p>I'm not sure I fully understand your working environment, but I have some general points that may be of interest. It might be that if you use EA in a different way (especially my first point below), the need to batch import might go away.</p> <p><strong>Multiworker</strong></p> <p>First, multiple people can work on the same EAP file at a time. The EAP file is nothing more than an Access database file, and EA uses locking to stop multiple people editing the same package at the same time. But you can comfortably have multiple people editing different packages in one EAP file at the same time. Putting the EAP file on a file share somewhere is a good way of doing it.</p> <p><strong>Inbuilt Revision Control</strong></p> <p>Secondly, EA can interact directly with SVN (and other revision control systems). See <a href="http://www.sparxsystems.com/enterprise_architect_user_guide/projects_and_teams/applying_version_control_to_en.html">this</a>. In short, you can setup your EAP file so that individual packages (and everything below them) is SVN controlled. You can then check out an individual package, edit it, check it back in. Or indeed you can check out the whole branch below a package (including sub packages that are themselves SVN controlled). </p> <p>Underneath the hood EA is importing and exporting XMI files and checking them in and out of SVN, whilst the EAP file is always the head revision. Just like what you're doing by hand, but automated. It makes sense given that you can all use the one single EAP file. You do have to be a bit careful rolling back - links originating from objects in older versions of one package might be pointing at objects that no longer exist (but you can look at the import log errors to see if this is the case). It takes a bit of getting used to, but it works pretty well.</p> <p>There's also the built in package baselining functionality - that might be all you need anyway, and works quite well especially if you're all using the same EAP file.</p> <p><strong>Bigger Database Engine</strong></p> <p>Thirdly, you don't have to have an EAP file at all. The model's database can be in any suitable database system (MySQL, SQL Server, Oracle, etc). So that gives you all sorts of options for scaling up how its used, what its like over a WAN/Internet, etc. </p> <p>In short Sparx have been quite sensible about how EA can be used in a multi-worker environment, and its worth exploiting that.</p>
    singulars
    1. This table or related slice is empty.
    1. POEfficient Way to do batch import XMI in Enterprise Architect
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USbazza
    1. USbazza
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POEfficient Way to do batch import XMI in Enterprise Architect
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COOkay, let me check the scripting and Inbuilt Revision Control
      singulars
      1. PO
      1. USDavid
    2. COThe Inbuilt Revision Control is similar to what we have been doing right now. There is no issue to check-in the package to SVN and to get the XMI export. The problem is in the first import of the XMI because each team member uses his own EAP file. For scripting, I saw only few examples and explanations :(
      singulars
      1. PO
      1. USDavid
    3. COIs each team member's EAP file nominally identical? If so, you could just pick the one that's completely up to date (or make one so), stick it on a file share, and then everyone can abandon their own and start using that one. You can then setup that single EAP file to integrate itself with SVN. You will lose continuity in your revision history. In short I'm suggesting a one-off effort to get a single EAP file and then use EA's inbuilt automated SVN integration from now on.
      singulars
      1. PO
      1. USbazza
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload