1
General Board / Setup PCS on a cloud Virtual Machine
« on: February 27, 2024, 10:18:49 am »
Hello EA experts,
I had this question on the PCS section for a few days but I have not got a response, so I am moving it here:
Upon receiving recommendations from Geert, BobM, and Eve, I proceeded to create a virtual machine (VM) on Azure to host the PCS. Here's what I've accomplished thus far:
1- Set up a VM on Azure Cloud (Windows Server 2022 - Size Standard B2ms (2 vcpus, 8 GiB memory))
2- Installed PCS.
3- Installed Xampp (I have not done any configuration for it yet)
4- EA? (Do I need to install EA on the same VM that hosts PCS?)
5- Installed SQL Server Express on the same VM, created a database, tested it with a simple SELECT statement and it's working.
6- I established a connection between the PCS and the SQL Server.
https://ibb.co/WBbdWJb
When I tried to establish Cloud connection from my local EA client to Pro Cloud Server hosted on the VM. In the Server field (shown in the screenshot below), I added the IP address of the VM and typed “Test”. I do not actually have any models yet on PCS because I do not know how to add one there.
https://ibb.co/1dvzPpf
However, I got an error message (shown in the screenshot below):
https://ibb.co/856XZds
My understand that I should then follow the steps (shown in the link below):
https://sparxsystems.com/enterprise_architect_user_guide/16.1/the_model_repository/settingupdatabasemodelfile.html
The above link lists the steps to Set up a Project on a DBMS Repository:
To set up your project on a DBMS repository, you work through these stages:
1. Set up your DBMS software and create a database.
2. Create the required tables in your database, by running a script supplied on the Sparx Systems website.
3. (For certain DBMS products, and if you are not using the Enterprise Architect Native Connection to access the database) Set up an ODBC driver to enable connection to the repository.
4. Transfer the project from the source file to the DBMS repository; the source file can be:
- a .QEA, .EAP or .FEAP base model, to begin a new project from scratch, or
- a previously-developed project file, to move an existing project into the DBMS repository
5. Connect to your repository; we recommend using the Enterprise Architect Native Connection for this.
My questions are:
1- Where can I find the script (underlined) above?
2- How can I create a model on my local machine and transfer it to PCS?
3- How can I test whether someone from my team (with a standard license) has access to the model and that everything is working?
4- When we test that things are working properly, I need to get a floating license. My understanding is that I should use the second option in the below screenshot. For the server address, should I add the IP of the VM that hosts PCS? The port is 1804 or 1805 based on the protocol used (http or https). The user name and password are the user name and password, I use to log in to Pro Cloud Config?
https://ibb.co/bJJwfd8
I would appreciate your help to get the setup complete and the connection established.
I had this question on the PCS section for a few days but I have not got a response, so I am moving it here:
Upon receiving recommendations from Geert, BobM, and Eve, I proceeded to create a virtual machine (VM) on Azure to host the PCS. Here's what I've accomplished thus far:
1- Set up a VM on Azure Cloud (Windows Server 2022 - Size Standard B2ms (2 vcpus, 8 GiB memory))
2- Installed PCS.
3- Installed Xampp (I have not done any configuration for it yet)
4- EA? (Do I need to install EA on the same VM that hosts PCS?)
5- Installed SQL Server Express on the same VM, created a database, tested it with a simple SELECT statement and it's working.
6- I established a connection between the PCS and the SQL Server.
https://ibb.co/WBbdWJb
When I tried to establish Cloud connection from my local EA client to Pro Cloud Server hosted on the VM. In the Server field (shown in the screenshot below), I added the IP address of the VM and typed “Test”. I do not actually have any models yet on PCS because I do not know how to add one there.
https://ibb.co/1dvzPpf
However, I got an error message (shown in the screenshot below):
https://ibb.co/856XZds
My understand that I should then follow the steps (shown in the link below):
https://sparxsystems.com/enterprise_architect_user_guide/16.1/the_model_repository/settingupdatabasemodelfile.html
The above link lists the steps to Set up a Project on a DBMS Repository:
To set up your project on a DBMS repository, you work through these stages:
1. Set up your DBMS software and create a database.
2. Create the required tables in your database, by running a script supplied on the Sparx Systems website.
3. (For certain DBMS products, and if you are not using the Enterprise Architect Native Connection to access the database) Set up an ODBC driver to enable connection to the repository.
4. Transfer the project from the source file to the DBMS repository; the source file can be:
- a .QEA, .EAP or .FEAP base model, to begin a new project from scratch, or
- a previously-developed project file, to move an existing project into the DBMS repository
5. Connect to your repository; we recommend using the Enterprise Architect Native Connection for this.
My questions are:
1- Where can I find the script (underlined) above?
2- How can I create a model on my local machine and transfer it to PCS?
3- How can I test whether someone from my team (with a standard license) has access to the model and that everything is working?
4- When we test that things are working properly, I need to get a floating license. My understanding is that I should use the second option in the below screenshot. For the server address, should I add the IP of the VM that hosts PCS? The port is 1804 or 1805 based on the protocol used (http or https). The user name and password are the user name and password, I use to log in to Pro Cloud Config?
https://ibb.co/bJJwfd8
I would appreciate your help to get the setup complete and the connection established.