For many Sparx Systems users, Enterprise Architect is already a trusted platform for capturing architecture, design, process, system, requirement, technology, and dependency information in a structured and governed way. Kernaro AI from Sparx Systems introduces natural language AI assistance to this modelling experience, helping users interact with Enterprise Architect model knowledge more easily and effectively. Rather than relying only on manual navigation, searches, diagrams, reports, and repository structure, users can ask questions, request explanations, explore relationships, summarize model content, and receive assistance in creating or refining architecture information through simple prompts. Kernaro AI is not intended to replace architects, modellers, or established modelling practices. Its purpose is to support them by making model knowledge easier to access, interpret, apply, and extend.

Natural Language Access to Model Knowledge

• Enterprise Architect repositories often become rich sources of organizational knowledge. They may contain information about business capabilities, processes, applications, interfaces, requirements, technologies, risks, dependencies, and transformation plans.
• As repositories grow, locating the right information and understanding how different elements relate to each other can require significant time and model familiarity.
• Kernaro AI helps simplify this experience by allowing users to ask questions directly against model content. Users can explore what exists in a repository, understand relationships, identify dependencies, and request clearer explanations of specific areas of the model.
• This makes Enterprise Architect model knowledge more accessible not only to experienced modellers, but also to business users and stakeholders who may not work directly inside Enterprise Architect every day.

Supporting Architects and Modellers

• For architects and modellers, Kernaro AI helps reduce the effort involved in exploring, reviewing, explaining, and working with model content.
• It can assist with summarizing model areas, tracing relationships, understanding dependencies, and preparing information for architecture discussions. This enables modellers to spend less time searching for information and more time focusing on model quality, architectural decisions, governance, and stakeholder alignment.
• Kernaro Assist extends this support directly inside Enterprise Architect. It helps architects and modellers create, refine, and improve architecture content while keeping them fully in control of the modelling process.
• Using natural language prompts, modellers can receive support for turning ideas, notes, diagrams, documents, or existing information into structured architecture content. Kernaro Assist can also help improve descriptions, clarify model information, and support more consistent documentation across the repository.

Helping Business Users Understand Architecture

• Business users often need answers from architecture models, but they may not know where the information is located, how the repository is structured, or which diagrams and relationships are relevant to their question.
• Kernaro AI helps make architecture knowledge more approachable by allowing business users to ask questions in familiar language and receive responses based on the information captured in the Enterprise Architect model.
• For example, they may want to understand which applications support a business capability, which processes depend on a system, or what areas may be affected by a proposed change.
• By making model knowledge easier to consume, Kernaro AI helps business users participate more effectively in architecture, transformation, governance, and planning discussions.

Bridging Model Creation and Model Consumption

• A model delivers the greatest value when it is both well-structured and widely understood.
• Architects and modellers need to create and maintain accurate, governed, and reusable model content. Business users and stakeholders need to understand what that model means and how it supports decisions.
• Kernaro AI helps bridge these needs. It allows modelling teams to continue working with the structure and discipline of Enterprise Architect, while providing stakeholders with a more conversational way to access and understand the same source of knowledge.
• This supports clearer communication and stronger collaboration between architecture teams, technology teams, business stakeholders, and decision-makers.

Making Impact Analysis More Practical

• Impact analysis is one of the most valuable uses of architecture model knowledge.
• When a change is proposed, teams often need to understand what may be affected across applications, processes, interfaces, requirements, technologies, data, and business capabilities.
• Kernaro AI helps users explore these relationships more efficiently by using the connections already captured in the Enterprise Architect repository. This can support faster analysis, earlier risk identification, and more informed decision-making.
• For modellers, it helps surface relevant connected information more quickly. For business users, it helps explain the possible impact of change in a way that is easier to understand and discuss.

Getting More Value from Existing Models

• Many organizations have already invested significant time and effort in building Enterprise Architect repositories. The challenge is not always creating more information, but making the existing model knowledge easier to access, understand, and apply.
• Kernaro AI helps unlock more value from these repositories by making model knowledge more conversational, discoverable, and actionable.
• Kernaro Assist supports architects and modellers in creating and improving architecture content more efficiently inside Enterprise Architect.
• Together, Kernaro AI and Kernaro Assist support both sides of the architecture journey: building better models and making those models more useful for business and technology decision-making.

Whether you are a modeller building and maintaining Enterprise Architect repositories or a business user seeking clearer access to architecture knowledge,  Kernaro AI helps make model content more accessible, conversational, and actionable.

Learn More About Kernaro AI

To learn more, watch product walkthroughs, or follow the latest updates, visit us through the links below:

Website: https://kernaro.sparxsystems.com
LinkedIn: https://www.linkedin.com/company/sparxsystemskernaroai
YouTube: https://www.youtube.com/playlist?list=PLsiYAecFNMTx_lVSauYmLK_TYQ9czJaaV

In the most recent release of MDG Office Integrations (v1.4.40), an exciting enhancement known as the "BPMN Visualizer" has been introduced, offering an excellent utility for BPMN users. This feature facilitates the seamless transfer of BPMN Components between Microsoft Excel documents and Sparx Enterprise Architect Models.

The key feature of 'BPMN Visualizer' in MDG Office Integration

• Simplified Approach that eliminates the necessity for Profile Creation during import and export for mapping items. This drastically minimizes user time and the possibility of manual errors.
• Through a single click of "Excel to EA" menu, users can quickly synchronize BPMN Components, seamlessly updating and aligning data between Excel and the Enterprise Architect model.
• The visual representation of diagrams from the Enterprise Architect model, as well as the related preconfigured mapping table, can be displayed within Excel.
• The capability to incorporate multiple diagrams is supported when a package is selected. This involves displaying all diagrams in the selected packages along with their corresponding predefined mapping tables on separate sheets.

BPMN Components on Microsoft Excel

MDG Integration for Microsoft Office provides seamless integration within Microsoft Excel (Version 2007 and above). A newly introduced feature named ‘BPMN Visualizer’ now resides in the ‘Feature’ dropdown of the Enterprise Architect ribbon in Excel. This feature facilitates the seamless transfer of ‘BPMN Components' between an Excel document and Enterprise Architect, allowing for bi-directional data exchange.

To import BPMN Components into Enterprise Architect from Excel

	The Feature dropdown offers the following selection options: ‘Export to EA’: Export the elements to Enterprise Architect using Profiles ‘SysML Requirement Manager’: Import SysML requirements from Enterprise Architect and Export SysML requirements and their connectors to Enterprise Architect. ‘BPMN Visualizer’:  Import BPMN Components from Enterprise Architect and export BPMN Components to Enterprise Architect.
	Allows one to select a *.eap or *.eapx or *.feap or *.qea or *.qeax or *.eadb through local project, server connection, or cloud connection. Local Project: To connect the Local Enterprise Architect model. Server Connection: To connect to an Enterprise Architect repository through a database Cloud Connection: To connect to an Enterprise Architect repository through the Pro Cloud Server
	Allows users to select a Package or BPMN Diagram to Load from the Enterprise Architect Model to Excel with the respective diagram image.

Select a package

• This window will be displayed when the Package Icon is clicked.
• It displays all the models and packages from the selected Enterprise Architect model, with BPMN Components being imported specifically.

Select a BPMN Diagram

• This window will be displayed when the Diagram button is clicked.
• It provides a hierarchical overview of all diagrams within the packages of the model. Users have the ability to choose a specific BPMN diagram from this view.

Note: The ‘Ok’ button will only enable when the selection type is BPMN Diagram

Utilizing Excel for BPMN Components

• The selected diagram is imported to an Excel sheet along with its predefined mapping table.
• The Excel sheets are named in the format of Diagram Name with Diagram ID.

Excel column definition

Creation of element from Excel to Enterprise Architect model

• To create a new element, enter a name in the ‘Action Name’ column (mandatory).
• By default, the ‘Action Type’ is ‘Activity’. Users can change the type using the drop-down list.
• Mapping the parent element for the newly created element is also achievable using the ‘Parent’ column.

Note: Supported Element types are Activity, Gateway, StartEvent, IntermediateEvent, EndEvent, DataStore, DataObject, BusinessProcess, BPELProcess, GlobalTask, Pool, and Lane.

Establishing connectors for the newly created element in Excel

‘Next Action ID’ creates a connector between two BPMN elements. Choose the appropriate ‘Action ID’ in the checklist box of ‘Next Action ID’ to connect. By default, the connector type is ‘Sequence Flow’

Note: Supported connector types are SequenceFlow, MessageFlow, Conversation Link, DataAssociation, and Association.

To update the changes from the mapping table in Excel to the Enterprise Architect model utilize the ‘Excel to EA’ Icon available in the Excel Ribbon; The preview form is presented to the user to ensure that the intended changes are ready for export. Once you click the ‘Export’ button, synchronization is initiated between the Enterprise Architect Model and Excel, causing the changes to be updated in Excel as well.

As depicted in the image below, you can observe that the recently generated ‘Process goods’ element has been incorporated into the Excel diagram. This element establishes a connection with the ‘Gateway5’ element, as indicated in the mapping table. Likewise, this synchronization is also reflected in the Enterprise Architect model.

The ‘EA to Excel’ icon enables users to revert the produced items back to their original state as Enterprise Architect Models, providing an opportunity to undo changes made in Excel. Additionally, it facilitates the synchronization of changes made from Enterprise Architect to Excel.

BPMN Components from Enterprise Architect to Microsoft Excel

Through the ‘BPMN to Excel’ menu, users can export data pertaining to BPMN Components, which have been accumulated within Enterprise Architect, into the Predefined mapping tables along with diagrams in separate sheets within Excel.

After selecting the package or BPMN Diagram, the Enterprise Architect will begin exporting data to an Excel sheet and proceed with Refer "Utilizing Excel for BPMN Components"

Check out the BPMN on Excel and Enterprise Architect video here

To know more or to request a demo, please reach out to This email address is being protected from spambots. You need JavaScript enabled to view it.

"SysML Requirements on Excel" is a new MDG Office Integration feature that allows users to author SysML requirements using Excel. Users can seamlessly integrate SysML requirements between MS Excel and Enterprise Architect.

Key features

• Import and export SysML requirements data from Excel into Enterprise Architect.
• Ability to create SysML Compliant requirements with inter-dependencies

SysML Requirements in Enterprise Architect

Using the “SysML Requirements on Excel” menu, users can connect an Enterprise Architect Model with an Excel spreadsheet.

This will create an Excel Document with required templates to let users create SysML requirements. This will also copy any existing Enterprise Architect requirements and the derived relationships to the Excel spreadsheet, to let users update or modify these contents.

Working with Excel to author Requirements

The Excel template for SysML requirements authoring will have two spreadsheets,

1. Requirements – The requirements sheet is used to create and update SysML compliant requirements, including Id and text, the sheet also displays any derived requirements (interconnected requirement)

The Requirement Sheet has two parts: "SysML Requirements" and "Derived SysML Requirements".

SysML Requirements – It contains Name, Notes, Status, Version and Id, Text (Mandatory tags for SysML)

Derived SysML Requirements – It also contains Name, Notes, Status, Version of Derived Requirement for each SysML requirement. This part is completely non-editable.

2. Requirement Matrix – This worksheet will present all requirements in a matrix format to let users easily create derivation inter-dependencies between them.

• This sheet will be automatically updated when new requirements are added in the ‘Requirements’ worksheet
• New relationships created in this spreadsheet will also be automatically updated in the ‘Requirements’ worksheet

Insert Elements and Connectors

Insert the element in the Name Column of the Requirement Sheet (with Notes, Status, Version, ID, and text, but the Name column is mandatory). And create a connector between the newly created element and the existing element in the ‘Requirement Matrix’ sheet.

Newly created connector details are updated in the ‘Requirement’ sheet.

To sync or update the modifications to the Enterprise Architect Model, use the Excel to EA icon. The changes reflected in the Enterprise Architect Model will be shown in the preview form. To update into an Enterprise Architect Model, select Export.

New elements are created under the chosen package.

The EA to Excel icon is used to restore the produced items to their original state as in the Enterprise Architect Model.

Prior to ‘EA to Excel’

Post ‘EA to Excel’

SysML Requirements on Excel (from Excel)

MDG Integration for Microsoft Office offers integration within Microsoft Excel (Office 2007 and above), and a new feature called SysML Requirement Manager is added to the feature dropdown of the Enterprise Architect ribbon. Using this, users can easily push the contents of SysML requirements from an Excel document to an Enterprise Architect or vice versa.

To import SysML requirement data into Enterprise Architect from Excel

	Dropdown list to choose the Export to Enterprise Architect Model or the SysML Requirement Manager for the document. ‘Export to EA’: Export the elements to Enterprise Architect using Profiles ‘SysML Requirement Manager’: Import SysML Requirements from Enterprise Architect and Export SysML Requirements and their connections to Enterprise Architect.
	Allows one to select a *.eap or *.eapx or *.feap or *.qea or *.qeax or *.eadb through Local project, server Connection, or cloud connection. Local Project - To Connect Local Enterprise Architect model. Server Connection - To Connect to an Enterprise Architect repository through a database Cloud Connection - To Connect to an Enterprise Architect repository through Pro Cloud Server

Select a package

• This screen will be displayed when the Package button is clicked.
• It displays all the models and packages from the selected Enterprise Architect model, with SysML Requirement items being imported specifically.

After selecting the package and clicking ‘OK, ‘Enterprise Architect will begin exporting information to an Excel sheet and proceed with Refer "Working with Excel to author Requirements"

Check out the SysML Requirements in the Enterprise Architect video here

To know more or to request a demo, please reach out to This email address is being protected from spambots. You need JavaScript enabled to view it.

We are delighted to inform you that the 3rd edition of the EA Global Summit 2022 is happening on September 14 & 15 in 2022.

Register now: EA Global Summit 2022

With 1200+ Registrations already, this could be a very good opportunity to meet and collaborate with fellow EA community.
An incredible lineup of speakers is keen to join their expertise, experience, and best practices related to Sparx Systems products including Enterprise Architect, Pro Cloud Server, EA SaaS, and Prolaborate.