Messages

1

Automation Interface, Add-Ins and Tools / Re: No values using reporttemplate

« on: July 08, 2025, 05:38:34 pm »

The solutions didn't work. I added it between child elements >Element.Name, Element.Type, etc. < Child elements

After that I could see it, but only if I placed the pools and other BPMN elements at the same hierarchy level as the BPMN_BusinessProcess stereotype. But this is not exactly what I want. I want them one hierarchy level under the BPMN_BusinessProcess stereotype 

2

Automation Interface, Add-Ins and Tools / Re: No values using reporttemplate

« on: July 03, 2025, 11:48:13 pm »

Are there any other suggestions?

3

Automation Interface, Add-Ins and Tools / Re: No values using reporttemplate

« on: June 30, 2025, 09:31:17 pm »

Thank you for your reaction!

It looks like that is not the problem. There are no filters active on the template

4

Automation Interface, Add-Ins and Tools / No values using reporttemplate

« on: June 30, 2025, 06:51:04 pm »

Hello Everyone,

I have an issue. I made a reporttemplate for a procesmodel (see below). It works for a model in BPMN. But the problem is that someone else wanted to use this reporttemplate but the value of the element fields are not seen in his report. So, you can see the values of the diagram fields but not of the element fields. The model without values is made with a personilized MDG that extends BPMN. Doe anyone has an idea on how to fix this?

Reporttemplate:
package >


diagram >
{Diagram.Name} diagram

Author: {Diagram.Author}   version: {Diagram.Version}   Last update: {Diagram.DateModifiedShort}

Description:

{Diagram.Notes}


{Diagram.DiagramImg}
{Diagram.Name}

element >
Description per element:
Proces step           Type                    Role                          Description
{Element.Name}   {Element.Type}   {Element.Owner}   {Element.Notes}
< element


< diagram
child packages >
< child packages
element >
embedded elements >
< embedded elements
diagram >
< diagram
child elements >
< child elements
< element
< package

5

Automation Interface, Add-Ins and Tools / Importing CSV Columns into EAUML::table Stereotype Tables

« on: May 27, 2025, 11:23:52 pm »

Hi everyone,

I have tables modeled using the EAUML::table stereotype in Enterprise Architect, and I have a CSV export from an Oracle database with columns like:

Column_Name

Mandatory

Computed

Formula

Check_Constraint_Name

Default_Value

Use_Domain_Constraint

Uses_Default

Engineer

Table_Name

PK_Flag

FK_Flag

Native_Type

Sequence

I understand that you can customize the CSV import specification in EA, but what I don’t know is which exact values should be used in the CSV to correctly map fields to the stereotypes and attributes in the tables. For example, how should I represent a primary key checkbox (PK_Flag), or other flags like FK_Flag, Mandatory, etc., so that EA correctly interprets them as stereotypes or tagged values?

I want to import the columns into the correct tables based on the Table_Name field and have these attributes correctly set in EA.

If anyone has experience with this, or can share the correct way to format these values in the CSV for EA to recognize and map them properly, that would be a huge help!

Thanks in advance for any tips or examples.

6

Automation Interface, Add-Ins and Tools / Re: Connecting BPMN lanes to Activities in Reports

« on: May 27, 2025, 09:41:50 pm »

It worked, thanks!!

7

Automation Interface, Add-Ins and Tools / Connecting BPMN lanes to Activities in Reports

« on: May 27, 2025, 07:29:58 pm »

Hi all,

I'm working on a custom document generation template in Sparx Enterprise Architect to export BPMN process diagrams. The current template outputs a list of activities with their name, type, and description (from the Notes field).

Is it possible to also include the Lane (role) in which each BPMN activity is placed, shown as an extra column in the report.

Here is a simplified version of the template we are currently using:

package >

diagram >
{Diagram.Name} diagram

Author: {Diagram.Author}    Version: {Diagram.Version}    Last modified: {Diagram.DateModifiedShort}

Description of the process diagram:

{Diagram.Notes}

{Diagram.Name}

element >
Description of process diagram elements:
Process Step    Type    Lane    Description
{Element.Name}  {Element.Type}     {Element.Notes}
< element

< diagram
< package

I am looking for a way to populate the "Lane" column with the name of the lane (or pool) in which the activity resides.

From what I understand, there is no direct property on the Activity element that links it to its lane, as the lane is just a visual container.

Does anyone know how to extract this relationship.

Any guidance or example templates would be greatly appreciated!

8

Automation Interface, Add-Ins and Tools / Automatically generating a logical data model from a physical data model in Spar

« on: February 18, 2025, 12:12:33 am »

Hello everyone,

I am working with Sparx Enterprise Architect version 16.1 and I’m wondering if it’s possible to automatically generate a logical data model based on an existing physical data model. I have already created the physical data model, but I would like to know if there is a way to automate the conversion to a logical data model within the software, or if I need to do this manually.

Has anyone had experience with this functionality, or can anyone provide tips or tricks to make this process easier?

Thanks in advance!

9

Automation Interface, Add-Ins and Tools / Automating the ETL Process via Sparx Enterprise Architect

« on: February 18, 2025, 12:04:57 am »

Hello everyone,

I’m looking for advice and best practices for automating the ETL process within our Enterprise Data Warehouse (EDWH), which is build in SAS. Our team currently uses Sparx Enterprise Architect for modeling and design purposes, but we want to explore whether we can leverage this platform to automate the ETL process, or at least support the design and orchestration of it.

The challenge:
We’re looking for ways to automate the extraction, transformation, and loading process using EA, or use EA as a supporting tool to streamline the process.
We also want to know if there are any integrations between SAS and Sparx Enterprise Architect that can help us with this automation.

Specific questions:

• Can Sparx Enterprise Architect itself execute the ETL process? Or is it mainly focused on modeling and documenting the process, requiring other tools for the actual execution?
• How can we integrate Sparx Enterprise Architect with SAS to support data extraction, transformation, and loading processes? Are there any specific add-ins or APIs that make this integration possible?
• Can we design workflows and process models for the ETL process in EA and then link them to the ETL tools within SAS?
• Is there a possibility to automate the ETL process via scripting in EA, such as extracting data from a model or preparing transformations?
• What tools or techniques do you recommend to optimize the collaboration between EA and SAS for ETL automation?

Thanks in advance for your help!