[HOWTO] Create an EA Project in a Microsoft Azure SQL Database

This blog post serves as a thought support and describes the necessary steps to create a Sparx Enterprise Architect project in a Microsoft Azure SQL database.

Prerequisites

Create Empty SQL Database

First of all an Azure SQL database has to be created to store the project data in (for each EA project a separate database is required).

  1. Log in to Azure Portal
  2. Select SQL databases in the navigation on the left side
  3. Create a new SQL database by clicking +Add

    1. Configure SQL database by providing database name, subscription and resource group (create a new one if necessary)
    2. Configure required server settings by providing server name, server admin login and location
    3. Click Select
    4. Configure required pricing tier settings by selecting max data size and setting DTUs to 20 (recommended by blog post of the Sparx Community written by Guillaume)
    5. Click Apply
    6. Click Create

Create New Firewall Rule

As soon as the deployment of the SQL database completed a new firewall rule has to be created to enable access to the Azure SQL database.

  1. Log in to Azure Portal
  2. Select SQL databases in the navigation on the left side
  3. Select the before created SQL database
  4. Click on Set server firewall
  5. Add client IP
  6. Click Save

Set Up Data Tables

Now the data tables can be set up as follows.

  1. Open Microsoft SQL Server Management Studio
  2. Connect to the Azure SQL database using the before created admin login
  3. Select the database and create a new query (right click on the database)
  4. Copy the contents of the following SQL scripts into the query window (consider the order of the scripts)
  5. Execute query (F5)

Now the database is ready to connect to with Enterprise Architect.

Connect to Database with Enterprise Architect

To connect to the Azure SQL database with Enterprise Architect procced as follows.

  1. Open Enterprise Architect
  2. Go to Open Project...
  3. Open dropdown of Connect to Server and select Connection Wizard
  4. Select provider Microsoft OLE DB Provider for SQL Server
  5. Click Next
  6. Provide connection information like server name and admin login and then select the database on the server
  7. Click OK
  8. Specify connection name and type
  9. Click OK

Now Enterprise Architect opens the EA project from the Microsoft Azure SQL database.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: