Questions about the deployment of CloudService

[Michel Gibelli]

Hello,

I just have deployed the CloudService on a server with PostgreSQL as RDBMS.
I have followed the instructions given in this page :
http://www.sparxsystems.com/enterprise_architect_user_guide/12/projects_and_teams/setting_up_the_server.html

and with the help fo this PDF :
http://www.sparxsystems.de/fileadmin/user_upload/pdfs/Cloudservice/Enterprise_Architect_Cloud_Services.pdf

It works fine. Of course, some SQL queries have to be adjusted due to syntax differences between the SQL dialects.

I have some questions regarding the deployment of a number of EA projects (dozens) on this platform :

• It seems that for each EA projet, we need to create a new PostgreSQL base, a new ODBC32 datasource, right ?
• The script to create the base creates the tables, but does not initializes a new empty project. So we need to create an empty project (.eap format for example) and then transfert the project, right ?
• Can I dump this empty project and use it to create several other projects whitout any risks (of duplicate GUID for exemple) ?
• Is it possible to deploy these tables in a named schema instead of the public schema ?
• In the dialog Box "Add Database Manager" of the SSCloudServiceClient.exe, what is the syntax of the connection string" ? It seems to me that the name of the datasource becomes the name of the EA projet, no ? At this step, would it be possible to have a "generic DSN" and give the parameters (as the database name or the servername or the user) in the connection string ?

In fact, my main objective would be to configure the whole thing remotely and easily : create a new repository, create a new ODBC and add it to the cloud server.

I don't know if it is achievable, and I would appreciate any returns or answers.

Thanks in advance
Michel

[Dermot]

With Project Transfers you can use the .eap or the CLoud Service base EABASE.FDB. For a copy of the .FDB see in the Cloud services directory: C:\Program Files (x86)\Sparx Systems\Cloud Services\Service\Models.

If you are doing multiple databases you might consider installing EA on the server and doing project transfers from the EABASE.FDB to the Postgres DB's.

Q. It seems that for each EA projet, we need to create a new PostgreSQL base, a new ODBC32 datasource, right ?
A. Yes.

Q.   Can I dump this empty project and use it to create several other projects whitout any risks (of duplicate GUID for exemple) ?
A. Yes - there can be some duplication of the base, but these in general should not cause any conflict.

I suggest you contact support for a copy of the leatest installer document.

[Michel Gibelli]

Thank you for your answers.

I will submit a request to the support