Creating a Workspace in PostgreSQL

You create a workspace on the Enterprise Analyzer server machine. Other users connect to the workspace from Enterprise Analyzer client machines. The workspace repository resides on a database server, and can be accessed by any user with database privileges to the repository.

Important: Do not modify the name of the workspace once created. Doing so might result in unpredictable behavior.

Before creating a workspace, you must configure an ODBC Data Source Name (DSN) for the database that holds the workspace repository. You will need to create a 64-bit DSN using the PostgreSQL ODBC UNICODE driver. You will need the following DSN configuration information to create the workspace:

The data source name.
The database name created for the repository.
The server and port. The default port for PostgreSQL is 5432.
The username and password that give access to the schema.

The folder in which you plan to create the workspaces must be shared with team members. It is usually more convenient to share the folder before you create workspaces, but you can do it afterward if necessary, then refresh the workspace path.

It is the responsibility of the workspace creator to designate users for security policies. Perform this task as soon as you have finished creating the workspace, then periodically edit the list of users as required. There are two options to create a workspace using PostgreSQL:

New Workspace (PostgreSQL)
New Workspace (PostgreSQL simple)

New Workspace (PostgreSQL)

Perform the following steps to create a new workspace using PostgreSQL:

Open Micro Focus Enterprise Analyzer Administration.
Click Administer > New Workspace.
This opens the Create new workspace dialog box.
Double-click New Workspace (PostgreSQL)
This opens the New workspace dialog dox.
Navigate to the location for the new workspace. In the File name field, type the name of the new workspace. Click Save. This opens the Options - Define Connection Parameters dialog dox.
Click the Connection tab. On the Connection tab:
- In the Data Source Name field, type the ODBC data source name you specified at ODBC data source configuration. If you have not specified a data source name, or want to use a different data source name, click ODBC Manager to open the Select Data Source dialog box and follow the instructions for ODBC data source configuration in the installation guide for your product and then click OK.
- In the Database Name field, type the database name.
- In the Database Schema Name field, type the database schema name for the workspace repository.
- In the User Name and Password fields, type the user name and password that give access to the schema.
Click OK.

New Workspace (PostgreSQL simple)

Taking the simple option to create a workspace takes less steps, but requires a pre-specified User or System ODBC data source name (DSN):

The ODBC DSN has Postgres35W as its Name or Data Source.
The ODBC DSN has the following connection information specified:
- Database
- Server
- User Name
- Port
- Password

Perform the following steps to create a new workspace using PostgreSQL:

Open Micro Focus Enterprise Analyzer Administration.
Click Administer > New Workspace.
This opens the Create new workspace dialog box.
Double-click New Workspace (PostgreSQL simple)
This opens the New workspace dialog dox.
Navigate to the location for the new workspace. In the File name field, type the name of the new workspace.
Click Save.
This opens the Create New Workspace dialog box. Which displays important information on the workspace created.
Click OK.
Note: A schema will be created in the database specified in the ODBC DSN which will have the workspace name typed in step 4.

Note: If you create the workspace in a non-shared folder, you are warned and are prompted to share the folder. After you share the folder, ensure that you refresh the workspace path.

You are notified that the workspace was created successfully. Enterprise Analyzer creates a workspace file (.rwp) and a folder with the same name in the specified location. The workspace folder contains support files and subfolders for EA output. A project with the same name as the workspace is displayed in the Repository Browser.