Adaptive Server Anywhere (ASA) Repository

This topic describes how to create a Sybase Adaptive Server Anywhere (ASA) repository.


  • This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions.
  • Before starting, you must set up the ASA and ASA ODBC drivers, and you must have the appropriate permission to create a new database. The process of setting up ASA is beyond the scope of this User Guide; please consult your Sybase ASA 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 ASA and DBMS systems in general, you might want to consider a suitable front end tool.

Sybase Central is one such tool, that can be installed along with the DBMS. It provides a convenient graphical user interface to enable creation of databases, execution of scripts and restores.

To get started with Sybase Central, follow the steps below:

  1. Create a new database.
  2. Open Interactive SQL and execute the AS SQL script.


The following example shows the tables created in the ASA repository after running the script in EMS ASA Manager.





ASA 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.