1 Prolaborate Architecture

2 Prerequisites

2.1 App Server Specifications

The following are the minimum requirements for Prolaborate’s smooth running. The deployment will depend on usage and other environmental factors.

Memory	8.0GB
CPU	2.4 GHz x 4
Disk Space	20 GB

If concurrent users exceed 100, the recommended memory and CPU are 16.0 GB and ‘2.4GHz x 8’, respectively.

2.2 Database Server Specifications

The following are the minimum database server specifications.

Memory	8.0 GB
CPU	2.4 GHz x 4
Disk Space	20 GB

2.3 Supported Operating Systems

• Windows Server 2012
• Windows Server 2012 R2
• Windows Server 2016
• Windows Server 2019
• Windows Server 2022
• Windows Server 2025
• Windows 7 – SP1 Required
• Windows 8 +
• Windows 10
• Window 11

Note:

1. A user with admin privileges is needed
2. Windows Server is recommended for larger organizations

2.4 Supported Enterprise Architect Databases

Prolaborate allows you add repositories from the following Enterprise Architect database servers.

Database Type	Prolaborate 5.5	Prolaborate 4.0 to 5.4
MySQL Server	8.0 and above	5.6 – 5.7  8.0 and above
MSSQL Server	2016 and above	2008 R2 and above
PostgreSQL Sever	13 and above	8.4 and above
Oracle Server	12c Release 2 (12.2) and above	12c Release 2 (12.2) and above
MariaDB Server	10.5.28 and above	10.5.28 and above
SQLite	Generated from EA 16 and 17	Generated from EA 16 and 17

Note:

1. An EA user with appropriate permissions should be present for each EA database. Note that Active Directory credentials cannot be used.
2. Support for SQLite database is included from Prolaborate V5.2.0.
3. If you are using Postgres database, run the following query in all the repositories:
   create extension hstore
4. Enterprise Architect database of type Firebird is currently not supported.

2.5 EA Database Drivers

If you are using an ODBC or OLEDB connection to connect with the database, please refer to the links below. 

• SQL database (Read More)
• MySQL databases (Read More) 
• PostgreSQL databases (Read More) 
• Oracle databases (Read More) 
• MariaDB (Read More) 

From Pro Cloud Server V5 and above, you can use Open Server Connections – Native Connection to connect with the EA database. 

• SQL database (Read More) 
• MySQL databases (Read More) 
• PostgreSQL databases (Read More) 
• Oracle databases (Read More) 
• MariaDB (Read More) 

2.6 Pro Cloud Server Configuration

Use the following Pro Cloud Server version based on your current Prolaborate version. 

• V6.0 from Prolaborate 5.3.0 and above
• V5.1.28 from Prolaborate 4.5.0 to 5.2.0
• V4.2.66 from Prolaborate 3.5.0 to 4.4.2

For upgrade instructions, click here.

2.7 Supported Prolaborate Databases

• SQL Server 2016 and above
• SQL Server Express 2016 and above
• MySQL Server 8.0 and above

Note:

1. From Prolaborate v4.4.1 onwards, collation type of database should be mandatorily set as “utf8mb4_general_ci” in MySQL as shown in the image below. This change is applicable only for MySQL Prolaborate database. 
2. Check your max_allowed_packet size value in MySQL configuration. If it is less than 100, update it to 1024 or higher. Unit of max_allowed_packet is bytes
3. Check your sql-mode or sql_mode value in MySQL configuration. If it contains ONLY_FULL_GROUP_BY, remove it. ONLY_FULL_GROUP_BY introduced in MySQL v8 which causes an issue in running custom query in Prolaborate to retrieve data from EA Model DB. Removing it will fix the issue that occurred in running the custom query and will not pose any issues for EA repositories.

This change is applicable only for the MySQL Prolaborate database.

The following details of the Prolaborate database should be readily available before the installation:

• Server Name/IP Address
• Database name
• Username
• Password

‘SQL Server Authentication’ mode is preferred. Active Directory logins are not supported.

Refer to the Appendix to learn about setting up SQL or MySQL servers.

2.8 Firewall / Port Requirements

The following ports should be open:

• Port of EA database(s): Pro Cloud Server (PCS) should be able to access the EA database(s).
• Port of PCS: The Prolaborate and Enterprise Architect should be able to connect to PCS. The default port (HTTP) is 1804.
• Port of Prolaborate database: The Prolaborate application should be able to connect to its database.
• Port of Prolaborate application: End-users should be able to access the Prolaborate website. You will be asked to open a port during the installation of Prolaborate.
• Port of WebSocket application: End-users should be able to receive real-time in-app notifications from the Prolaborate application. You will be asked to open the port during the installation of Prolaborate.

Note:

• Make sure the specified ports are opened in the firewall. To know how to make a port accessible refer to the Appendix.

2.9 Supported Browsers

Prolaborate is compatible with following browsers:

• Chrome 44 or above (recommended)
• Firefox 38 or above
• Safari 9 or above ( from Prolaborate V4.2 onwards)
• Microsoft Edge 75 or above

A minimum screen resolution of 1280×720 is required for the best use of Prolaborate.

2.10 Optional Requirements

• Enable HTTPS in Prolaborate. (Read more)
• Active Directory (AD): The AD server should be accessible from Prolaborate. The AD port should be opened. (Read more)
• Mailer Configuration (SMTP/MS Graph): The SMTP or MS Graph server should be accessible from Prolaborate. For SMTP, the port should be opened. (Read more)
• Confluence Integration: The Prolaborate application should be accessible from Confluence, i.e., whitelisted in your security policies. (Read more)
• Jira Integration: The Prolaborate application should be able to connect with Jira, i.e, it should be whitelisted in your security policies. (Read more)

2.11 Prolaborate Version

For a smooth transition from Prolaborate V3, it is recommended to upgrade your current installation of Prolaborate to a base version of 3.7 and proceed with the upgrade to latest version of Prolaborate.

Looking for cloud options to eliminate infrastructure woes? Learn more here.

3 Setup – Install and Configure Pro Cloud Server

3.1 Install Pro Cloud Server

The Pro Cloud Server installer is a standard Microsoft Installer. Double click on it to start the installation and follow the onscreen steps. Click here to get the Pro Cloud Server installer.

3.2 Create License Request

Follow these steps to configure the Pro Cloud Server:

1. Open Pro Cloud Config Client. The application shortcut can be found on the desktop.
2. Enter the Server Address as “localhost:1803” and Password as “pcsadm1n” (default password) and click on OK.
3. Click on Licensing.
4. Click on Create Request and fill in the details using this link. Click on OK and save the license request file.
5. Send the ‘License Request’ file to our Sales Team at sales[at]sparxsystems[dot]com

3.3 Install License

1. Our Sales Team will sign your request and return a License Certificate
2. Open Pro Cloud Config Client and go to Licensing window
3. Click on Add
4. Select and Open the License Certificate and the license will be added. Ensure the details are fine

3.4 Configure EA Models in Pro Cloud Server

1. Open Pro Cloud Config Client.
2. Click on Addin the window and choose Native or ODBC Connection. 

3. For Native Connection, select the EA database type and enter the required database details to complete the configuration. For an ODBC Connection, click the Browse icon near the Connection String to open the Data Link Properties window. Select an option based on the EA database type and complete the configuration. (Refer to the Appendix to read more about the configuration)

4. In the Add Database Manager window, give an Alias to the database you just configured (Enter an appropriate name). You will need this Alias to connect to this EA database from EA and Prolaborate.

5. Click on Test to check if the connection with the database can be established based on the details entered.

6. If the connection is successful, a success pop-up appears. Click on OK to close the pop-up.

7. Click on OK to add the database.

8. Click on the Database Manager just created and then click Edit

9. Enable the checkbox Enabled and Enable Pro Features in the Configure Database Manager

10. Enable Require a secure and authenticated connection if SSL is enabled for your EA models. Leave it unchecked if not. Click on OK.

.pfx file from your SSL certificate provider with its password and OpenSSL utility

3.5 Connect with EA Models over HTTPS

To connect to your models over secured HTTPS connection, do the following:

1. Place .pfx file in the bin folder (Typically located at C:\OpenSSL-Win32\bin\)
2. From the same bin folder, run OpenSSL.exe with administrative privileges and execute the following command:
   pkcs12 -in [certificate].pfx -out server.pem -nodes
   [certificate] refers to the name of your .pfx file.
3. Enter the password of the .pfx file when prompted
4. server.pem will be generated in the same folder location
5. Copy the server.pem file and paste it in this folder
   C:\Program Files (x86)\Sparx Systems\Pro Cloud Server\Service
6. Open SSProCloud.config file from the above mentioned path with edit privileges and update the second occurrence of SERVER_PORT from 805 to 443 (Standard port number of HTTPS connection) and REQUIRE_SSL to 1. If you want to disable HTTP connections, comment the first occurrence of SERVER_PORT by adding # at the start of the line
7. Restart the Sparx Systems Professional Cloud service from the Task manager

4 Install Prolaborate

4.1 Fresh Installation

In this, will look at the at the steps involved in setting up Prolaborate version 5.2 in a fresh environment.

4.1.1 Prerequisites

Ensure the previous prerequisites are met and the Prolaborate installation file is downloaded.

4.1.2 Run the Installer

Once the file is downloaded, extract it contents in a folder. Run the Setup.exe as administrator.

Click on Next.

4.1.3 Accept EULA

Check the box to accept the terms and click Next

4.1.4 Select Installation Path

Select a file path to install Prolaborate.

4.1.5 Select Database Server

Choose the Database server (MySQL or MSSQL) in which the Prolaborate database is hosted and then choose Run Schema.

Skip this step option should not be used for fresh installations.

4.1.6 Provide Database Details

Fill in the Prolaborate database details in the given fields.

4.1.7 Configure Prolaborate

Enter the Prolaborate server details in the given fields.

Field	Description
Host	Enter Domain Name or IP Address (E.g., localhost)
Port Number	Enter a Port Number that is not used. The port should be opened in the Firewall. Click here to know more.
Email ID of an Admin	Enter an Email ID. This user will be made the Super Admin of Prolaborate

4.1.8 Configure Push Notification

Enter the details in the given fields to configure Push Notification in Prolaborate.

Field	Description
IP Address / Host Name	The Domain Name or IP Address entered in the previous step is displayed automatically
Port Number	Enter a Port Number that is not used. The port should be opened in the Firewall. The default port number is 8080.

4.1.9 Install Prolaborate

Review the information in the previous steps and click Install to begin the installation process.

Note:

1. Write down the credentials or take a screenshot of this page for future reference.

A command prompt will appear once the setup is complete, like the one in the figure below. The command window will close automatically.  

Click Finish once the installation is completed successfully.

4.1.10 Protocol Update

If you want to change the domain name and protocol details.

Follow the mentioned steps from this link.

4.1.11 How to access Prolaborate 

Launch your preferred web browser (e.g., Google Chrome, Mozilla Firefox, Microsoft Edge). 

Enter the Protocol: In your browser’s address bar, enter the HTTP or HTTPS protocol specified in your Prolaborate management settings.

Example:
If Prolaborate is configured to use HTTPS, type “https://” followed by the domain name. 

Enter the Domain or IP Address: Enter the correct domain name or IP address configured for Prolaborate access. It should match the domain or IP address in Prolaborate management. 

Example:
If your Prolaborate domain name is “prolaborate,” enter ” https:// prolaborate” after the protocol.  

Specify the Port Number: Specify the port number as specified in your Prolaborate management settings. 

Example:  
If the port number is 443, add ” https:// prolaborate:443″ after the domain name. 

After entering the correct URL and pressing Enter, your web browser will load the Prolaborate application interface. You will be prompted to log in using your credentials. 

Upon successful login, you will be redirected to the license page. Click here to learn more about license management. 

After uploading a valid license, you will gain access to explore the full features and functionalities of Prolaborate based on your license type, permissions, and user role. If you encounter any issues or have questions about specific features, refer to the Prolaborate documentation. 

4.2 Parallel Installation

In this, we will look at the steps in setting up the latest version of Prolaborate as a parallel installation to your current version 3.x installation. This will help you check and try out the new features without impacting your current usage.

If you want to upgrade your current installation of Prolaborate V3 to the latest version, check out this Upgrade guide.

4.2.1 Prerequisites

Ensure the previous prerequisites are met and the Prolaborate installation file is downloaded.

4.2.2 Create New Database

Create a new database for Prolaborate V5.

4.2.3 Copy Database

Export the contents of the existing Prolaborate database and import it in the newly created database.

4.2.4 Run the Installer

Download the Prolaborate Installer file. Once the file is downloaded, extract it contents in a folder.

Run Setup.exe as an administrator.

Click on Next

4.2.5 Accept EULA

Check the box to accept the terms and click Next.

4.2.6 Select Installation Path

Select a file path to install Prolaborate.

4.2.7 Select Database Server

Choose the Database server (MySQL or MSSQL) in which the Prolaborate database is hosted, then choose Run Schema.

4.2.8 Provide Database Details

Fill in the Prolaborate database details in the given fields.

4.2.9 Prolaborate Database Backup

Ensure the database is taken as a backup. Enable the checkbox and click Next to continue the installation process.

4.2.10 Configure Prolaborate

Enter the Prolaborate server details in the given fields.

Field	Description
Host	Enter Domain Name or IP Address (E.g., localhost).
Port Number	Enter a Port Number that is not used. The port should be opened in the Firewall.
Email ID of an Admin	Enter an Email ID. This user will be made the Super Admin of Prolaborate.

4.2.11 Configure Push Notification

Enter the details in the given fields to configure Push Notification in Prolaborate.

Field	Description
IP Address / Host Name	Enter the details in the given fields to configure Push Notification in Prolaborate.
Port Number	Enter a Port Number that is not used. The port should be opened in the Firewall. The default port number is 8080.

4.2.12 Install Prolaborate

Review the information in the previous steps and click Install to begin the installation process.

Note:

• Write down the credentials or take a screenshot of this page for future reference.

Click Finish once the installation is completed successfully.

4.2.13 Run Data Migrator

Data Migrator helps migrate data from V3 to the latest version. It can also transfer existing configurations, such as dashboards, chart widgets, report widgets, discussions, reviews, users, modeling languages, etc.

To initiate the migration process, go to the Prolaborate installation folder (C:\Program Files\Prolaborate\ProlaborateDataMigration). Right-click on “DataMigrator.exe” and choose ‘Run as Administrator’.

Data Migrator initiates the command prompt window to show the migrated file name and status. After the migration is completed, press any key to close the window.

Note:

• From Prolaborate V5.2.0 onwards, Data Migrator is executed automatically at the end of the upgrade process.

To ensure the data migration was successful, please log in to the application and check that all the content has been migrated successfully.

4.2.14 Post Installation Steps

Internet Information Service (IIS) Support

The V5 application does not require an IIS manager to perform in Version 5. We upgraded the Config file, which completed all of the manual work that required manual installation of IIS. The user may access the web application through the domain specified during the installation phase when configuring Prolaborate.

Note:

Please enter the Domain name in the URL.
For example: http://sparx.prolaborate.com [or] https://sparx.prolaborate.com

You can choose either ‘http’ or ‘https’ Protocol depending on your need.

Update Password

After upgrading from v3 to the latest version, the admin should reset the registered user’s password. There are multiple ways the password reset can be achieved.

• If there are fewer users, the admin can set a Temporary password from the Users and License Management page. The users can then use the temporary password to reset their password.
• If there are more users, you can inform them to use the Forgot Password option on the login screen to reset their passwords. Mailer should be configured to use this option, which is not applicable for SSO and AD users.
• The admin can reset the password of all Prolaborate users using the Prolaborate Management application. When resetting the password in Prolaborate Management, the updated password will not be emailed automatically; it must be sent manually. This is not applicable for SSO and AD users.

Note:

• Admin must enter the credentials to reset the password of all registered users.

Update Port

Users who wish to use a different port for their application must perform the following steps manually in Prolaborate Management.

Open Prolaborate Management from the installed folder (C:\Program Files \Prolaborate\ProlaborateManagement) and run Prolaborate Management as an administrator.

1. Click Manage Configuration.
2. Open WebApp section.
3. Enter the desired port number. Choose an open port that is not currently being used by any other application on your system. The port should be opened in the Firewall. Click here to learn how to open a port.
4. Click Save.
5. Restart all the Prolaborate services once the action is successful.

Protocol Update

To run your application using the HTTPS protocol, users must manually configure the WebApp and Push Notifications settings in Prolaborate Management.

Update WebApp

Open Prolaborate Management from the installed folder (C:\Program Files\Prolaborate\ProlaborateManagement) and run Prolaborate Management as an administrator.

1. Click Manage Configuration.
2. Open WebApp section.
3. Choose an SSL certificate using the browse icon.
4. Enter the respective password for the certificate.
5. Enable the Use HTTPS check box.
6. Click Save.
7. Restart all the Prolaborate services once the action is successful.

Update Push Notification

Update WebSocket or Push Notification protocol from HTTP to HTTPS from Prolaborate Management if required.

Open Prolaborate Management from the installed folder (C:\Program Files\Prolaborate\ProlaborateManagement) and run Prolaborate Management as an administrator.

1. Click Manage Configuration.
2. Open Push Notification section.
3. Enter the Port Number that is open and not in use.
4. Choose an SSL certificate using the browse icon.
5. Enter the respective password for the certificate.
6. Enable the Use HTTPS check box.
7. Click Save.
8. Restart all the Prolaborate services once the action is successful.

Note:

• Ensure that any changes made to WebApp details align with corresponding adjustments in push notification settings.
• If your SSL certificate has expired, these configuration steps must be repeated to ensure Prolaborate functions without any interruptions.

OIDC Update

After installing Prolaborate, the admin must do the following steps to access the Application over HTTPS.

Open the application by entering the admin login credentials at the URL below.

Note:

Enter the Domain name in the URL. Example: http://(domainname)/Applications/Admin

Change the protocol to HTTPS and the Respective Port number. After changing the details, click the Save button.

Once saved, the information is automatically updated in the OIDC table of the Prolaborate database.

Configure SAML SSO

Following the upgrade, Prolaborate V5’s Application Base URL and Assertion Consumer URL will be different from Prolaborate V3. To ensure a smooth transition, the admin must change or modify the Prolaborate V5 Service Provider configuration details in the current SAML application of your SAML provider.

Service Provider Configuration

Copy the Service Provider configuration details from Prolaborate and paste them in the respective fields at the SAML application as described in the image below. 

 Identity Provider Configuration

Now, update the Identity Provider details in Prolaborate in parallel. Copy the Name, Sign-In URL, and Sign-Out URL from the SAML provider and paste them in Prolaborate.

In V5, we made mapping the attributes from the Prolaborate UI easier. Choose Active Directory Federation Services if your service provider is ADFS or Others for other service providers (OKTA, Jump Cloud, etc)

Map the attributes from the SAML SSO settings page, upload the SSL certificate and save the changes.

Attribute Mapping will be pre-filled with default values on the SAML Single Sign-On page and cannot be edited.

Users can change the values by clicking the toggle button from Default to Custom if required. Then copy the Attributes & Claims values from the SAML Application and paste them in the Prolaborate Attributes Mapping.

1. firstname
2. lastname
3. email
4. group

Enable Embed Share

After upgrading from V3 to the latest version, one must enable the Embedded Share in Repository settings to view the EA model information in SharePoint, Confluence, etc., published using iframe.

Migrate Prolaborate Content in Confluence

When upgrading from V3 to the latest version, you may encounter accessibility issues with Confluence details if you are using Confluence Cloud. To resolve this, follow the steps in this guide to retrieve your configuration details and Confluence data from V3 to the latest version of Prolaborate in Confluence Cloud.

Support

In case of any questions, feel free to reach out to prolaborate[at]support[dot]com

4.3 Upgrade Installation

Introduction

In this guide, we will look at the steps involved in upgrading your current installation of Prolaborate version 3.x to the latest version.

Use the points in the Decision Gate section to decide whether you are ready to proceed with the latest version of Prolaborate.

Once you are ready, check out the suggested Upgrade Plan section and plan your upgrade according to your processes and our suggestions. On the day of the Upgrade, follow the Installation and post-installation steps. Click here to know more.

4.4 Troubleshoot Installation

Refer to this guide to troubleshoot issues with the installation

5 Generate Data Cache

Enabling and generating a Data Cache is a one-time activity. Prolaborate relies on this data cache to show its users live diagrams and linked documents.

To create a data cache in Enterprise Architect V16 and V17, follow the steps below:

1. Open the model in Enterprise Architect.
2. Click on the Settings menu in the ribbon and choose Options.
3. Navigate to the Cloud section and enable the two checkboxes under Data Cache.
4. Click Create to generate a data cache.

To generate cache periodically,

1. Open Pro Cloud Config Client.
2. Double-click on a Database Manager to edit.
3. Enable Periodically Generate Diagram Images for WebEA & Prolaborate option.

Click on Configure and enter the following information.

Port	Select the Port that you are using to connect to this EA repository.
Model User	Enter a valid repository user. Ignore if model security is not enabled.
Model Password	Enter the password for the repository user. Ignore if model security is not enabled.
Interval (seconds)	Set the interval. The default value is 30 seconds.

Click OK and restart the Sparx Systems Professional Cloud service from the task manager.

6 Getting Started with Prolaborate

To get started with Prolaborate, follow the guides below.

Install License – Ensure the appropriate licenses are installed to grant users full access to all application features.

Add Repositories – Repositories are the first elements users interact with after logging in.

• Users can only manage repositories to which they have been granted access.
• Only Prolaborate Administrators have the permission to create new repositories.

Configure Sections – Define which Enterprise Architect (EA) packages should be accessible through Prolaborate. This helps tailor the user experience by focusing only on relevant models.

Set up Access Permissions – Administrators can assign controlled access to individual users or user groups, ensuring that the right people have the appropriate level of interaction within the platform.

Set up Guest Access – Enable the guest sign-up feature to allow external users to register and gain read-only access to the application, which is ideal for lightweight collaboration or review.

Configure Mailer – Prolaborate uses your SMTP or MS Graph server to send emails for account activations, notifications, reviews, and more. To ensure reliable email delivery, configure your Mailer settings correctly.

Setup Active Directory – Enable Active Directory integration to allow users from your organization to log in to Prolaborate using their existing domain credentials, streamlining authentication and user management.

Add Users – Users are team members collaborating within a repository. Each user’s ability to view or modify content is based on the access rights assigned by the administrator.

7 Appendix

7.1 How to Open a Port

Make sure the firewall is enabled by confirming that “Firewall state” is set to ‘On’ and not to ‘Off’.

Step 1: Open windows defender Firewall with Advanced Security.

Step 2: In the left-hand side of the navigation bar, click Inbound Rules.

Step 3: From the right side of the Inbound Rules tab click on ‘New Rule’. The new rule wizard launches.

Step 4: Select ‘PORT’ and click ‘Next’.

Step 5: Select ‘TCP’ and in the Specific local ports section, enter the Port number which needs to be opened and click on ‘Next’

Step 6: Select ‘Allow the connection’ and click ‘Next’.

Step 7: Make sure all Domains, Private and Public are checked and click ‘Next’.

Step 8: Specify the Name and Description for the port and click ‘Finish’.

7.2 Setup SQL Server

7.2.1 How to Create Prolaborate Database

‘SQL server authentication’ must be enabled and an admin account must be created. The following settings must be accomplished:

Step 1: Create a new Database called Prolaborate.

Step 2: Create a new user by using the ‘New Login’ option under Security -> Login section.

Step 3: Uncheck ‘Enforce password policy’.

Step 4:  Set the default database to ‘Prolaborate’.

Step 5: Configure ‘Server Roles’, grant access to all admin privileges.

Step 6: ‘User Mapping’, maps the Prolaborate database to the new user.

Step 7: Configure ‘Status’ as shown below:

7.2.2 How to Create EA Database

Follow the below steps to create an EA database; 

Create a database for the EA model and execute the following scripts in the EA database: first, execute ‘EASchema_1558_SQLServer.sql’ (Click here to download), and then execute ‘EABase_1558_SQLSvr.sql’ (Click here to download).  

Following the execution of this schema, it is necessary to transfer the EA Project to this server. For guidance, click here how to transfer your project to the EA Database.

7.3 Setup MySQL Server

7.3.1 Update MySQL Configuration Values

Post installing MySQL server, check and update the max_allowed_packet size and sql-mode or sql_mode values in MySQL configuration file by following the steps below,

1. Press Win + R key
2. Enter %programdata% and click Ok.
3. Open the my.ini file located at “C:\ProgramData\MySQL\ MySQL Server [your server version]”. (E.g., “C:\ProgramData\MySQL\MySQL Server 5.7”) in Notepad
4. Check your max_allowed_packet size value in MySQL configuration. If it is less than 100, update it to 1024 or higher. Unit of max_allowed_packet is bytes.
5. Check your sql-mode or sql_mode value in MySQL configuration. If it contains ONLY_FULL_GROUP_BY, remove it. ONLY_FULL_GROUP_BY introduced in MySQL v8 which causes an issue in running custom query in Prolaborate to retrieve data from EA Model DB. Removing it will fix the issue that occurred in running the custom query and will not pose any issues for EA repositories.
6. Once the changes are done, save the file.

7.3.2 Create Prolaborate Database

To create a new Prolaborate database, follow the steps below,

Step 1.Open MySQL Workbench and create a new connection.

Step 2.Open the new connection.

Step 3.Create new database called Prolaborate with charset ‘utf8mb4’ and collation ‘utf8mb4_general_ci’ and click on Apply.

Step 4.Click on Apply.

Step 5.Click on Finish.

7.3.3 How to Create EA Database

Follow the below steps to create an EA database. 

Create a database for the EA model and execute the following scripts in the EA database: first, execute ‘EASchema_1558_MySQLServer.sql’ (Click here to download), and then execute ‘EABase_1558_MySQLSvr.sql’ (Click here to download). 

Following the execution of this schema, it is necessary to transfer the EA Project to this server. For guidance, click here how to transfer your project to the EA Database.

7.4 Transfer Project to EA Database

Follow the below steps to transfer your EA model to EA Database.

Note: 

Before proceeding with the transfer process, it is essential to create an EA database. Click here to learn how to create an EA database for MSSQL and MySQL servers. 

Step 1: Open your EA model, navigate to Settings> Model> Transfer and Click on Full Project via connection. 

Step 2: Select the Transfer type as ‘File to DBMS’ (click here to know more about Transfer Type) and Choose the Source Project of your EA model and configure the target connection of the project either by Native Connection (Server connection) or ODBC Connection Wizard. 

Step 3: After configuring the Target connection, hit the Transfer button. All data will get transferred to the destined EA Database. 

After transferring the model to the database, set it up a Pro Cloud Server. Then, add it as a repository in Prolaborate. Finally, create a data cache.