Many organizations already have or are in the process of building catalogs and inventories of key assets either in office productivity tools like Microsoft Visio® or Excel® or collaboration tools like Microsoft SharePoint®. Managing this contents in such informal tools is very difficult to exploit and maintain. Organizations need a comprehensive, integrated platform for making investment decisions based on a holistic view of the enterprise.

Watch this new video to understand how to build an Enterprise Business Intelligence Platform using APG ModelFlow and Sparx Enterprise Architect. Go from spreadsheet to full-fledged modeling in minutes!      

MDG Office Integration for excel supports the following

Import from Excel 

• Importing artifacts from MS Excel documents
• Synchronizing subsequent changes (additions, modifications) from the MS Excel document into EA 

Export to Excel

• Export Enterprise Architect contents into a (pre-formatted) Excel spreadsheet

Please follow the following steps to try synchronization

1. Import an Excel document using the profile defined for the respective worksheet
2. Check ‘Enable Synchronization’ in the Importer dialog

3. You will be prompted with the following dialog
   1. You can request EA to write sync data into the original file that is imported
   2. Or write the synch data to a backup file (which will then become your master copy in which subsequent changes must be done)
4. Once you choose the backup file path and synch settings, click Apply

5. Click Preview and Import in the Importer dialog
6. Upon successful completion of import, the synch data will be added to the output file

7. Make changes to the synchronization file (where the Synch information has been written)
8. The Synchronization file, which becomes your masterfile, must be reimported using the same steps as above to ensure the contents are synchronized.
9. You will notice that the EA artifacts are ‘Updated’ instead of ‘Added’

Hippo Software's recently extended workshops are designed to expand and enhance delegates' knowledge of Enterprise Architect:

•           EA Document Workshop – create custom document templates

•           EA Excel Data Transfer Workshop – easily share requirements or other data

•           EA Scripting Workshop – facilitate repetitive or complex tasks on models

•           EA Profiles Workshop – define custom diagrams, toolboxes, elements and relationships

For more information, please visit the Hippo Software website below:

http://www.hippo-software.co.uk/pages/EA.htm