Create SWA Master Database

Create SWA Master Database

SWA uses a database to store all its configurations, PDF reports and Progress data when using Two-Step Progress Updating.

Create an SWA Database on your database server, either MS SQL or Oracle. Name it, SWAMaster.

This needs to be done with (DB owner) credentials. SWA uses this database and must not be confused with the Safran Project or Safran Planner database.

Oracle Database Server

When using Oracle, you need to consider the tablespaces. You need to know the tablespaces' names before starting the installation. If these are anything but "safran_data" for the data and "safran_index" for the indexes, you need to edit the SQL-command file named "Tables.sql" in the "ORA" sub-directory. You must replace "tablespace safran_data" and "tablespace safran_index" with the correct names. If indexes shall be kept with the data, remove all "tablespace safran_index".

Before installing, you need a user called SAFRANSA, with at least CREATE TABLE, CREATE SYNONYM, and CREATE PROCEDURE privileges. Preferably, the SAFRANSA user should be granted DBA privilege. A default role called "SwaRole" will be created during database initialisation, and all privileges ("all" on tables/synonyms, "execute" on procedures) will be granted to this role. All tables must be created with SAFRANSA as the owner. Corresponding synonyms will be created through which the application will access the tables ("Create public synonym activities for SAFRANSA.SwaUsers" will enable the application to access the SwaUsers table without referring to its owner).

Make sure that all files described in the previous chapter are installed. When creating an Oracle database, make sure the tablespaces are named

At the same time, create your SWAuser, the user that will be used in the connection string later on. You will need to assign the SWARole to this user after you have initiated the SWAMaster database.

Safran Web Access System Administrator 22.2

Starting SWA System Admin
Start SWA System Admin from the desktop or the install path.
Default path: "C:\Safran Web Access\SwaSystemAdministrator"

Enter credentials according to user info, server and database name in the following window:

Configure database. Click "1. Upgrade Database" and click OK when completed.

Activate SWA. Click "2. Activate Swa" and continue.

Enter your Personal and company information and click Ok.

Add license key