Creating a Workspace in Oracle or DB2

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.

Note: Do not modify the name of the workspace after you create it. Doing so will cause unpredictable results.

Before creating a workspace, you must configure an ODBC data source name (DSN) for the database that holds the workspace repository, as described in the installation guide for your product. You will need the following DSN configuration information to create the workspace:

The data source name.
The database schema name your DBA created for the repository.
The database user name and password that give access to the schema.
If required by your DBMS, the name of the tablespace your DBA created for the repository. If the DBA also created a tablespace for database indexes, you will need the name of that tablespace as well.

The folder in which you plan to create workspaces must be shared with team members. It’s 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.

Choose Start > All Programs > Micro Focus > Enterprise Analyzer > Enterprise Analyzer Administration. The Administration window opens.
Choose Administer > New Workspace. The Create new workspace dialog opens.
In the Create new workspace dialog, double-click the New Workspace icon for the RDBMS in use at your site or select it and click OK. The New workspace dialog opens.
In the New workspace dialog, choose the location for the workspace in the Save in drop-down. In the File name field, enter the name of the workspace. Choose a name that describes the legacy application as closely as possible. Click Save. The Define Connection Parameters dialog opens.
In the Define Connection Parameters dialog, click the Connection tab. On the Connection tab, enter:
- The ODBC data source name you defined at ODBC data source configuration. If you have not defined a data source name, or want to use a different data source name, click ODBC Manager to open the data source name configuration dialog, then follow the instructions for ODBC data source configuration in the installation guide for your product.
- The database schema name your DBA created for the workspace repository.
- The database user name and password that give access to the schema.
- If required by your DBMS, the name of the tablespace your DBA created for the repository. If your DBA also created a tablespace for database indexes, enter the name of that tablespace in the Tablespace for Indexes field. These fields are displayed only for DBMSs that require a tablespace name to be specified.
Click the Security tab. In the Policies list box, select:
- Simple Security Policy if you want to enforce a workspace security policy that recognizes two classes of users, master users and ordinary users.
- Three-Group Security Policy if you want to enforce a workspace security policy that recognizes a third class of users, subject matter experts (SMEs), with special privileges to create, assign, and delete tags.
In the Files access group box on the Security tab, select:
- Direct sources access via Windows share if your site does not restrict Windows access to workspace source files to the master user.
- Secure sources access via EA file server if your site restricts Windows access to workspace source files to the master user, while using the optional file server to make the source files available in the product to ordinary users. Make sure the values for the server name and port number fields are correct.
Note: For File Server installation and setup instructions, see the installation guide for your product.
Click OK.
Note: If you created the workspace in a non-shared folder, you are warned to that effect and prompted to share the folder. After you share the folder, make sure to 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.