Prev Next

WebConfig - Adding a Model Connection

New model connections can be added using the 'Add a Connection' option at the foot of the WebConfig 'Home' page.

The process of adding a new model connection has two steps - selecting the connection type, then entering the details that are required for the model connection.

Select Connection Type

When you click on the 'Add a Connection' option the 'Select Connection Type' page displays.

The WebConfig supports the creation of Firebird, Oracle (OLE DB) or SQL Server (OLE DB) Model Connections. Select the relevant radio button for the connection type, depending on the type of database you are accessing.

In the case of Firebird you will then have the option of either creating a new Firebird model directly from the WebConfig, or accessing an existing Firebird model.

For other model types (DBMS repositories), the model should have been created and tested (by accessing the model via Enterprise Architect's 'Connect to Server' option) prior to adding the Cloud Connection.

Note:

  • The DBMS types (such as Oracle and SQL Server) are only listed on this page if the relevant drivers are found on the server
  • The Pro Cloud Server also supports connections to MySQL and PostreSQL databases; however, these connections cannot be created using the WebConfig (they require definition of an ODBC system data source, which is not possible via the web client)
    To create a connection to MySQL or PostreSQL, use the Pro Cloud Server Configuration Client - Application

Add Model Connection

After you select the model type, the 'Add Model Connection' page is displayed. The options provided vary depending on the model connection type you selected.

Item

Description

See also

Firebird

Firebird models are stored on the server within the Pro Cloud Server's Models sub-folder (e.g. C:\Program Files (x86)\Sparx Systems\Pro Cloud Server\Service\Models).

When selecting Firebird you are provided with two options.

  • New Firebird Model - Select this option to create a new Firebird model; enter a name for the Firebird model in the 'File Name' field. No path or file extension are required
    The new, empty Firebird model will be created on the server (in the 'Models' sub-folder) and the model connection will be associated with this file
  • Existing Firebird Model - Select this option to create a model connection that links to an existing Firebird model (which already exists in the 'Models' sub-folder)

Oracle (OLE DB)

Connection Name / Alias

Specify a short, unique name for the connection. This is required when accessing the model via Enterprise Architect or WebEA.

Net Service Name

Enter the Oracle Net Service Name as defined in the TNSNAMES.ORA.

User

Enter the user name.

Password

Enter the password for the specified user.

SQL Server (OLE DB)

Connection Name / Alias

Specify a short, unique name for the connection. This is required when accessing the model via Enterprise Architect or WebEA.

Server / Instance

Enter the Server Name or Server Instance; for example: 'SQL-SERVER' or 'SQL-SERVER\SQL2012'.

User

Enter the user name.

Password

Enter the password for the specified user.

Database

Enter the name of the database that is the Enterprise Architect repository.

Learn more