| 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. 
|
|
|
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'. Database Enter the database name of the Enterprise Architect repository. User Enter the user name. Password Enter the password for the specified user. |