Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

PostgreSQL Repository

This topic describes how to create a PostgreSQL repository.

Notes:

  • This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions.
  • Before starting, you must set up the PostgreSQL and PostgreSQL ODBC drivers, and you must have the appropriate permission to create a new database. The process of setting up PostgreSQL is beyond the scope of this User Guide; please consult your PostgreSQL documentation for further guidance.

Sparx Systems provides SQL scripts to create the required Enterprise Architect repository tables, on the Sparx Systems website. You can execute the scripts in any way you prefer. However, if you are unfamiliar with PostgreSQL and DBMS systems in general, you might want to consider a suitable front end tool.

One such tool is pgAdminIII, which is available at http://www.pgadmin.org/download/. It provides a convenient graphical user interface to enable creation of databases, execution of scripts and restores.

To get started with pgAdminIII, follow the steps below:

  1. Create a new database.
     
    Postgre-DBWizard
     
  2. Open and execute the PostgreSQL SQL script.
     
    PostgreSQLScripts
     
  3. Below is an example showing the tables created in the PostgreSQL repository after running the script in pgAdminIII.
     
    PostgreEMS

 

PostgreSQL repositories are created without any data, so you must perform a project data transfer in Enterprise Architect to copy a suitable starter project. If you are starting from scratch, EABase.EAP is a good starting point. If you are using an existing .EAP model, you can upsize it.