The new Native Connection feature in version 16 of Enterprise Architect provides a clean and simple
method for connecting to a repository overcoming the need for any technical background.
The Native Connection provides a simple and consistent connection across the board.
Whether this is for connecting users directly on workstations
or configuring the Pro Cloud Server's connection to the DBMS repositories.
What we'll firstly run over are some examples
of connecting directly from Enterprise Architect to a repository.
For these we'll show you connecting to a Maria DBMS repository.
Then an MS SQL repository.
Then we can have a look at using the same type of connection on the Pro Cloud Server.
For this we'll connect them to a MariaDB
and finally create a new Firebird repository.
Let's start with connecting to a MariaDB repository.
On the Start Page we select the server connection option,
then select the MariaDB option type in a description.
Type in the server name where this is hosted.
Set the database name. Then give it a username and password.
We test this and on giving a connection successful.
We then click on the OK to start the connection.
We give it a security password which then opens the repository.
Let's try connecting to an MS SQL repository. On the Start Page we select
the Server Connection option, then select the MS SQL option.
Type in a description, type in the server name or where this is hosted.
Set the database name, then give it a username and a password.
This has the option to either select OLE DB or ODBC as the driver.
We test this and on seeing the connection is successful.
We then click on OK to start the connection. We give it a security password
and there we have the repository opened.
Let's now have a look at the same process but from the Pro Cloud Server configuration application.
For this we'll look at connecting to a MariaDB repository and a Firebird file repository.
We start by opening the Pro Cloud Server configuration dialog.
Then we add a database connection. We start with the Maria repository, we connected to earlier.
As you can see this is much the same process for the DBMS. You select the MariaDB option.
Type in a description.Type in the server name, where this is hosted.
Then give it the username and password.
We use the Test to check it, then click on OK to save it.
We open the Database configuration and ensure it is enabled as a Pro Cloud repository.
Let's now open an Enterprise Architect by selecting the Cloud Connection option.
We give it a security password and there we have the repository opened.
Finally let's look at creating a simple new Firebird repository on the Pro Cloud Server.
We start by giving it an Alias.
Then give it a unique file name with an extension of .feap.
We press OK then run through the enabling.
This creates a new Firebird repository ready to run.
We then open it in Enterprise Architect file with the Cloud Connection option.
We enter a name for the connection as well as inputting the Alias as the Model Name.
This opens up the new model ready to add a package,
which we will do with the Model Wizard to start us off with a Use Case Diagram.
Hopefully this gives you a good starting point for getting familiar with the new
Native Connection feature, which is available in the new version 16 release of Enterprise Architect.
For more information on this see sparxsystems.com/ea16