Intégration de Microsoft Office et Enterprise Architect

Webinaire July 2015
Dans ce webinaire, vous apprendrez à:
  • Éléments d'importation de Word et documents d'Excel dans Enterprise Architect.
  • Synchronisez des changements et produisez automatiquement des diagrammes de documents de Office.
  • Publiez votre modèle aux présentations PowerPoint.

L'intégration MDG pour Microsoft Office permet aux équipes d'exploiter de façon transparente les informations écrites dans Microsoft Word & Excel dans Enterprise Architect.

Améliorez vos documents statiques existant dans des modèles traçables riches. Automatiquement sections de document de carte et tables à propriétés d'élément correspondantes et valeurs étiquetées dans Enterprise Architect. Utilisez votre modèle directement dans une présentation PowerPoint pour assurer que votre présentation reste à jour avec vos derniers changements de modèles.

Scott Hebbard
Scott Hebbard

Intégration de Microsoft Office et Enterprise Architect

Nous avons fourni l'exemple du modèle Enterprise Architect et des ressources Word, Excel et PowerPoint associées utilisées dans le webinaire.
Modèle d'Exemple: bookstore-example.eap Download the Enterprise Architect Example Bookstore Model
Word Document: system-requirements-simple-table.docx Download a simple table of requirements
Word Document: requirements-with-connectors.docx Download a series of requirements with connectors
Excel Document: usecase-excel.xlsx Download a simple Use Case example in Microsoft Excel
PowerPoint Document: srs-demo.pptx Download an SRS Presentation in Microsoft PowerPoint

Questions de l'auditoire

Cliquez sur une question pour voir la réponse.


Quelle version d'Enterprise Architect prend en charge cette intégration?

Enterprise Architect 12 (version 1212 et supérieure).

Quelle version d'Enterprise Architect a-t-elle été utilisée tout au long de la présentation?

Enterprise Architect 12, build 1215.

Is the MDG Integration for Microsoft Office included in the Ultimate Edition of Enterprise Architect?


What does the "MDG" acronym stand for?

MDG stands for Model Driven Generation.

Is this office import tool free?

No. The MDG Integration for Microsoft Office is not free. Please refer to the page below for pricing information:

Is Enterprise Architect 12 required to run the MDG Integration for Microsoft Office?

Yes. Enterprise Architect 12 (Build 1212 or higher)

Will the MDG Integration for Microsoft Office work with version 10 of Enterprise Architect?

No. Enterprise Architect 12 (Build 1212 or higher)

Which edition of Enterprise Architect has the office integration? It is not showing in my corporate edition.

For the Corporate Edition, The MDG Integration for Microsoft Office add-in must be purchased from Sparx Systems website.

We haven't upgraded to Enterprise Architect 12 yet.  On what versions is this extension supported?

Enterprise Architect 12 (Build 1212 or higher). Please use the link below to purchase the latest version of Enterprise Architect:

We use Enterprise Architect version 12. It is the Ultimate Edition. I do not see the Office Integration option under 'Extensions'.

You need to install the “MDG Integration for Microsoft Office” using the link below:

Could you show where this add-in is available for download and how to install it?

The MDG Integration for Microsoft Office add-In can be downloaded from this page:

The page includes system requirements and installation instructions.

I have the Ultimate edition and the MDG Technologies dialog can be opened, but it doesn't show any Microsoft Office Suite Products. How do I make them appear?

If the “MDG Integration for Microsoft Office” was installed on your machine then the add-in will be shown under Extensions | Microsoft Office.

With regards to the importation of connectors, how many layers of associations can be used? (i.e. chains of requirements, Parent-child-etc.)

The current release just supports single layer of parent-child association, however, for supporting multi-layer parent-child relationships, you can map multiple columns as connectors and each valid entry in the columns will be converted into connectors.

Can you specify that you want the requirements to be imported as SysML 1.3 requirements?

SysML requirements can be imported by mapping the data in Excel or Word to Requirements, setting the stereotype as ‘SysML1.3::requirement’. You can also map id and text tagged values (to the ID and Description in the Excel or Word document)

Can the tool import custom tagged values?

Yes. Custom tagged values can be imported. Refer to the‘Tagged Values’ section in the Help.

Support d'Office

Is Office 365 (2013) supported?


What version of MS Office is the minimum? What version of MS office does this integrate with?

All office products from Microsoft Office 2007 and above are currently supported.

Is there a way to export Enterprise Architect diagrams and use cases to Excel as a reverse process?

Using Excel exporter, you can export elements and element details including tagged values and diagram only objects.

Does the Enterprise Architect tab get installed in the Office Applications when you install the MDG Integration for Microsoft office add-in?

Yes. For 32 bit Office applications, install the MDG Integration for Microsoft Office installer from:

would enable Enterprise Architect Ribbon in the Office applications.

Will this work with earlier versions of Office? I am using a surface running windows 8. Where can I find how to make the profiles? Do you have Visio integration?

Office Integration supports Office 2007 and above. You can define profiles from Enterprise Architects’ ‘Extensions’ menu or from within the Word or Excel documents’ ‘Enterprise Architect’ ribbon.

Could you suggest how to create separate slides for each requirement in a package?

This is not possible at the moment, however this could be lodged as a feature request.

Where can the MDG Integration for Microsoft Office be downloaded?

The MDG Integration for office is available from the product page or registered download section. See the links below:

I don't see MS Office in the Extensions menu. How do I enable them?

The MDG Integration for Microsoft Office will only be visible if you have the MDG Add-In installed.The first step is to download the extension from the Sparx Systems website:

Once the product is installed, the Microsoft Office option will appear under the Extensions Menu.

I downloaded the plugin today, but the "ribbon" does not appear - I think this is down to my PC having a 64 bit version of office. Will there be a separate download for a 64bit office plugin?

For office 64 bit, an additional installer to enable Ribbons for 64 bit Office setup is under development.


Once you have imported from Word or Excel, are you able to import the same thing again to update what is in Enterprise Architect?  Or, is it a one-time thing.

You can enable synchronization while importing from Word and Excel documents and re-import documents to update the contents in the Enterprise Architect model.

If you import requirements and make links (realization links) between them and model elements (like a class) what happens when you change the base word document and reimport?

If the import is done with ‘Synchronization’ enabled, the MDG Integration for Microsoft Office will update the changes , and create any new connectors if required ( however if any connector information is removed, it will not be deleted)

Can we convert Word, PP, or Excel to PDF successfully without losing the synchronized data, like a regular document?  Is the MDG Integration for Microsoft Office not a part of the Universal Edition?

Converting documents to PDF is still possible, however the synchronization data may not be relevant as a PDF.

Does the add-on support sync with Enterprise Architect repository with users editing a Word document?

Yes, as long as the Word document is saved and available for the importer to read, it can import the document.


Is there a way to do the opposite - generate a document from the model with all the embedded links in Word, make changes in Word, and then re-import/re-synch into Enterprise Architect?

Enterprise Architect provides a comprehensive inbuilt documentation capability.

Working with MS Word, by inserting sections of model into document can be achieved by referring to the following link.The following webinar outlines document generation features in Enterprise Architect:

Is it possible to have built-in MS Word sections with the content of Enterprise Architect objects (name, notes, some attributes) in a list, separated by objects names as headers? Is this possible?

Yes, you have to map the headers as the respective Enterprise Architect Element and its associated metadata as its properties (either delimited values or inline tables). Refer to the BRD Document example from sample documents.

Visio et Sharepoint

The webinar looked at Word, Excel and Powerpoint. Is Visio Integration different from the import that has been around for a few years?

Visio integration allows users to import Visio diagrams into Enterprise Architect. Key diagrams such as BPMN and UML are converted to respective stereotypes in Enterprise Architect. The functionality is the same as the Visio Importer that was available previously, with some minor enhancements to improve mapping of stereotypes and properties.

Can you link to a file in SharePoint and use the Sync functionality?

SharePoint integration may be considered in a future release. However we cannot advise an indicative timeframe now.

Support d'Apple

Does this work with Enterprise Architect on Mac via Crossover? Does this also work for the Mac?

The MDG Integration for Microsoft Office add-in has not been tested on a Mac

Développement futur

I noticed that only standard UML connector types can be created. Will there be support for MDG Technology based connector types?

Yes, support for stereotypes during connector import is under development and will be available in upcoming builds.

Can you use track changes in Word and import them?

Not supported at the moment, but a feature request or suggestion would be helpful.