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.

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:

1. Open Micro Focus Enterprise Analyzer Administration.
2. Click Administer > New Workspace.

   This opens the Create new workspace dialog box.

3. Double-click New Workspace (Postgre SQL)

   This opens the New workspace dialog dox.

4. 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.
5. 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.
6. Click OK.

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.