Connecting to a Workspace in Oracle or DB/2

Once a workspace has been created on the Enterprise Analyzer server machine, other users can connect to the workspace from EA clients. When you connect to a workspace, you create a link file with connection information that points to the workspace. Because the connection information is already stored in the file, you don’t have to enter it again when you reopen the workspace connection. Like a workspace file, a link file has a .rwp extension.

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

  • The data source name.
  • The database schema name your DBA created for the repository you want to link to.
  • The database user name and password that give access to the schema.
  1. Choose Start > All Programs > Micro Focus > Enterprise Analyzer. The Open Existing workspace dialog opens above the Enterprise Analyzer main window. Click Cancel to dismiss the dialog.
  2. Choose File > Build New Connection. The Define Server Workspace Connection dialog opens.
  3. In the Define Server Workspace Connection dialog, select the ODBC driver for the RDBMS in use at your site in the Database Provider drop-down. In the Required Parameters group box, 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.
    Note: The Tablespace and Tablespace for Indexes fields are for future use.
  4. When you are satisfied with your entries in the Define Server Workspace Connection dialog, click the Browse button for the Save Link As (.rwp) field. The Save Server Workspace Connectivity dialog opens.
  5. In the Save Server Workspace Connectivity dialog, choose the location for the workspace link in the Save in drop-down. In the File name field, enter the name of the link. Click Save. The linked workspace opens in the Enterprise Analyzer main window. EA creates a link file (.rwp) in the specified location.