Developer Studio Data Access and Descriptions

In this section:

Developer Studio includes sample data and Master Files to help you familiarize yourself with the interface and practice creating applications. However, to create applications that report on your own data, you need Master (.mas) and Access (.acx) Files (synonyms). Master Files describe the data so WebFOCUS can report on it. Access Files provide information that WebFOCUS needs to access the data. A synonym is a collection of Master and Access Files for a specific data source.

To create and run applications on your local machine, Master and Access Files must be in a subdirectory of the Application Root directory (APPROOT) located on drive:\ibi\apps by default. If you are developing applications using a remote WebFOCUS environment, you have access to the Master and Access Files on the remote Reporting Server.

If you use a local copy of the Reporting Server, you can create and run applications locally by configuring the local Reporting Server. There are two ways to configure the local server to access data:

After you have added a remote server or a data adapter, the synonym tool can create your Master and Access Files as explained in How to Create a Synonym in Developer Studio .

Note: If you are not using a local copy of the Reporting Server, you use resources on the remote environment. If you have administration rights to the remote Reporting Server, you can launch the Reporting Server Console in order to administer the server, configure data adapters, create synonyms, and perform other tasks. All processing will be done on the remote machine.


Top of page

x
Configuring Data Adapters, Remote Servers, and Synonyms in Developer Studio

How to:

Reference:

You can set up access to your data using the Create Synonym Tool within Developer Studio or the Server Console. Both approaches edit the same underlying server files, so it does not matter which you use. This topic explains how to add a remote server, configure a data adapter, and create a synonym using the Create Synonym Tool within Developer Studio.

For information on the Server Console, see Using the Reporting Server Console for Data Access and Synonym Preparation.



x
Procedure: How to Access the Create Synonym Tool

To launch the Create Synonym tool from the WebFOCUS Environments area of the Explorer:

  1. Expand your WebFOCUS environment (for example, localhost), expand Data Servers, expand the server, expand the Applications folder, expand an application, and right-click the Master Files folder for the application in which you wish to access the data source.

    If you wish to use the data source in multiple applications, or have not yet created your application, you can use the baseapp application, where resources can be stored for sharing and access by other applications.

    Tip: If you are developing from the Projects area of the Explorer, expand the project, and right-click the Master Files folder, then proceed as described.

  2. Select New and then Synonym.

    The Create Synonym tool opens.

    Depending upon your needs, you can use this Window to create synonym for existing adapters, configure a new adapter or add a remote server.

    • Configured. This folder contains any data adapters or remote servers that are already configured.

      You can use the Configured folder to add new connections for existing data adapters or servers, edit existing data adapters or servers, or create synonyms.

      Note that this folder will not initially be visible for a WebFOCUS installation. It becomes visible only after an adapter or a remote server has been explicitly configured.

    • Available. This folder lists the data adapters that you can configure on the Reporting Server platform.

    Note: If any adapters have already been configured for the server, you will see the available adapters, from which you can immediately begin to create synonyms.

  3. If no adapters are available, expand the Available folder, select the adapter you want to configure and click the Configure button.

    The Manage and Configure Data Adapters window opens.



x
Procedure: How to Access the Create Synonym Tool From Developer Studio Reporting Tools

When building a report, you can access the Create Synonym Tool directly from any of the Developer Studio reporting tools when you want to report against a synonym that is not available in the list.

  1. To launch the Create Synonym tool from Developer Studio reporting tools:
    • Click Create New from the Open dialog box, as show in the following image.

      Open dialog box

    • Click Create New from the WebFOCUS Table List dialog box, as shown in the following image.

      WebFOCUS Table List

      Note: When accessing a Developer Studio Tool in the Managed Developer Edition, the Create New button will not appear for developers without Data Server access permission.

    The Create Synonym Tool opens.

  2. Continue using the tool as described in this chapter.

    For more information, see Configuring Adapters and Remote Servers in Developer Studio in the Describing Data With Graphical Tools manual.

When you have completed the synonym creation process, the new synonym appears in the list of available synonyms. You can then select it and continue to create your report request.



x
Procedure: How to Configure an Adapter in Developer Studio
  1. From the Projects area, right-click on the root folder Projects on and select Manage Adapters.

    The Manage and Configure Adapters dialog box opens.

  2. Expand the Available folder icons to choose from the list of available adapters.
  3. Select an adapter to configure.
  4. Click Configure to add the selected adapter.
  5. Complete the connection information for your adapter.
  6. Click Configure.

    A message from the Reporting Server confirms that the adapter has been added to your configuration.

  7. Click Cancel to exit the tool.
  8. Or select Create Synonym to proceed and create synonyms for the configured adapter.

    The following options are available from the Manage and Configure Adapters dialog box.

    • Create Synonym
    • Test
    • Delete
    • Properties
  9. Click Test to test the connection.

    If you entered the correct connection parameters, sample data should appear.

    If the test fails, click the connection, select Properties, and adjust your information accordingly.

  10. When sample data appears, click Close.


x
Procedure: How to Add a Remote Server in Developer Studio

This procedure assumes that you have opened the Create Synonym tool and have clicked the Configure button to access the Manage and Configure Data Adapters window. You are now ready to proceed as described below:

  1. Expand the Available folder in the Manage and Configure Data Adapters window of the Create Synonym tool.
  2. Instead of choosing an adapter from the list, select Remote Servers and click Add Remote Server Connection.

    A window appears containing fields to define the connection.

  3. Complete the fields as follows:

    Basic Parameters

    Description

    NODE

    Type a name by which you will refer to the server. The name is your choice, but cannot be the same as any other server. It must begin with a letter and cannot be more than eight characters.

    HOST

    Specify the hostname or IP Address for the server.

    PORT

    Specify the base TCP port for the server. The default is normally 8120, not 8100.

    HTTP_PORT

    Specify the HTTP port for the server. This is normally one more than the base TCP port. The default is normally 8121, not 8101.

    CLASS

    If this is a z/OS server, you must include a qualifier. (Pertains only to z/OS servers.)

    SECURITY

    Specify how a user should log on to the remote server:

    • Explicit. Passes the user ID and password you provide.
    • Password Passthru. The user ID and password received from the client application are passed to your data source at connection time. This option requires that the server be started with security off.
    • Trusted. For a trusted connection, where the current logged on user ID is passed to the server.

    If the server is not on Windows and runs with security ON, providing an explicit user ID and password is required to create synonyms.

    user

    If security is set to Explicit, type a specific user ID.

    password

    If you entered a user, provide a password.

    domain

    For a server on Windows, you can specify the domain where the user ID is defined.

    DESCRIPTION

    Optionally, type a description for the node. This description displays in the WebFOCUS front-end tools.

  4. When connecting to a Unified Server, click the Advanced tab and specify the SERVICE NAME, and other parameters, as required.

    Advanced Parameters

    Description

    SERVICE NAME

    CLIENT (servicename)

    Defines how to send outbound communications to a remote server.

    servicename is optional. If servicename is provided, it must match the value of SERVICE in the service block of the server.

    COMPRESSION

    Activates data compression in a data transfer between client and server. Type:

    • 0 for no compression.
    • 1 for compression on.

    ENCRYPTION

    Defines the encryption. Type:

    • 0 for no encryption.
    • DES for 56-bit fixed-key Data Encryption Standard.
    • Advanced, enables you to easily select and combine ciphers, modes, and RSA key lengths. This option provides the following ciphers: 3DES, AES 128, AES192, AES 256, and the following modes: ECB and CBC.
    • IBCRYPT for user-defined algorithm. Key is 512-bit RSA-encrypted.

    Note: Encryption is not supported for PIPE protocol. Only 0 and DES are supported for HTTP protocol.

    CONNECT_LIMIT

    Defines the maximum time, in seconds, that the client will wait for a TCP connection response from the server. Type:

    • -1 for indefinite wait.
    • 0 for no wait.

    MAXWAIT

    Defines the time, in seconds, that the client will wait for a response from the server:

    -1 indicates indefinite timeout.

  5. Click Save when you have provided your parameter values.

    A message indicates that a new server was added.

  6. Click Create Synonym.
  7. Select the Filter by owner/schema and object name check box.
  8. Fill in the Owner/schema field and Object name fields.
  9. Click Next.
  10. Expand Configured and Remote Servers to see the new server.

  11. Select the new server.

    The Create Synonym, Test, Delete, and Properties buttons appear.

  12. Click Test to test the connection.

    If the remote server is started and you typed the correct connection parameters, sample data should appear.

  13. Click Close.

    If the test fails, click the server, select Properties, and provide an explicit user ID and password. Then click Save and try the test again.

  14. Click Close.


x
Procedure: How to Create a Synonym in Developer Studio

If it is not already open, launch the Create Synonym tool from the WebFOCUS Environments area of the Explorer:

  1. Expand your WebFOCUS environment (for example, localhost).
  2. Expand Data Servers.
  3. Expand the server.
  4. Expand the Applications folder.
  5. Expand an application, and right-click the Master Files folder for the application in which you wish to access the data source.

    If you wish to use the data source in multiple applications or have not yet created your application, you can use the baseapp application, where resources can be stored for sharing and access by other applications.

    Tip: If you are developing from the Projects area of the Explorer, expand the project, and right-click the Master Files folder, then proceed as described.

  6. Select New and then Synonym. The Create Synonym tool opens.
  7. In the first window, you can choose any configured Data Adapter or Remote Server that has been added to the default Reporting Server. Note that when you are creating a synonym through a Remote Server, the remote server should already contain the required synonyms and the corresponding adapters.

    Select adapter to configure or Select connection to create synonym dialog box

    The server configuration, indicated by the server profile, determines which adapters and servers appear. In this example, the Adapter for Microsoft SQL Server is configured. If you have configured remote servers, they will appear expanded in the Remote Server folder.

  8. Select the server or adapter that you configured and click OK.

    A window opens in which you can enter additional information about the data source you wish to access.

    Note: The options in this window vary depending on the type of adapter or server you are using. To access the pertinent information for your adapter directly from Developer Studio, choose Reporting Server Console from the Command menu. The Server Console opens. Click Help on the menu bar, select Contents and Search, expand the Adapters topic in the Table of Contents pane, and look for the adapter for which you wish to create the synonym. The relevant synonym creation parameters are fully defined.

    The following example is for accessing an adapter for EDASERVE.

    Select synonyn candidate dialog box

    After you complete this window, the data source or server is queried to determine the metadata you can use to create synonyms. For a relational database, this is usually a list of tables or views. This window lets you filter the results so there are fewer tables from which to choose. Optionally, choose whether both Tables and Views should be returned. By default, both check boxes are selected.

    For some data sources, you can select to generate synonyms for other object types, for example, Stored Procedures. If you do, the remaining input parameters will vary slightly.

  9. For some data sources, you have the option to choose a database or other parameter.

    You will have to select an appropriate database or choose Default Database. You will be able to choose from the database tables when this window is complete.

  10. Optionally, check Filter by owner/schema and object name to filter the results based on owners or table prefixes. This limits the list of tables returned from the remote data source and makes it easier to choose the data for which you want to create synonyms. If you do not include selection criteria, the entire list of tables is displayed.
  11. Click Next.

    The top of the Create Synonym window now displays additional fields you can use to refine your synonym. Remember that the parameters vary depending on the type of adapter or server you are using.

    The Create Synonym window

    The bottom of the Create Synonym window provides a list of tables for which you can create synonyms. To choose all tables, select the Default synonym name check box.

  12. Click Create Synonym.

    The synonym is created and a confirmation window appears. Once again, note that the window may vary depending on the type of adapter or server you are using.

    Create Synonym confirmation window

    The synonyms are created in the selected application directory. In this example, the default application, baseapp, is used.

  13. Click Close.


x
Reference: Synonym Creation Parameters for Microsoft SQL Server

The following table describes the synonym creation parameters for Microsoft SQL Server, based on Tables, Views, or External SQL Scripts.

Parameter/Task

Description

Restrict object type to

Restricts candidates for synonym creation based on the selected object types: Tables, Views, External SQL Scripts, and any other supported objects.

Selecting External SQL Scripts from the drop-down list enables you to represent SQL SELECT statements as synonyms for read-only reporting. A Synonym candidate can be any file that contains only one valid SQL Query and does not contain end-of-statement delimiters (";" or "/") and comments. For related information, see Location of External SQL Scripts in this chart.

Depending on the adapter, you can further restrict your search by choosing check boxes for listed objects.

Database selection

To specify a database from which you can select a table or other object, do one of the following:

  • Check Default database to use the database that has been set as the default database.
  • Select a database from the Select Database drop-down list, which lists all databases in the current DBMS instance.

    Uncheck Default database if you are going to select a database other than the default (This does not apply to Informix SE, for which Default database must be checked.)

Filter by owner/schema and object name

Selecting this option adds the owner/schema and object name parameters to the screen.

  • Owner/Schema. Type a string for filtering the selection, inserting the wildcard character (%) as needed at the beginning and/or end of the string. For example, enter:
    • ABC% to select tables or views whose owner/schema begin with the letters ABC.
    • %ABC to select tables or views whose owner/schema end with the letters ABC.
    • %ABC% to select tables or views whose owner/schema contain the letters ABC at the beginning, middle, or end.
  • Object name. Type a string for filtering the procedure names, inserting the wildcard character (%) as needed at the beginning and/or end of the string. For example, enter:
    • ABC% to select all procedures whose names begin with the letters ABC.
    • %ABC to select all procedures whose names end with the letters ABC.
    • %ABC% to select all procedures whose names contain the letters ABC at the beginning, middle, or end.

Location of External SQL Scripts

Extension

If you specify External SQL Scripts in the Restrict object type to field, these additional fields are displayed.

The following standard naming conventions apply for UNIX, IBM i IFS, and z/OS HFS:

  • In the Base Location field, specify the physical directory location of the file that contains the SQL Query.
  • In the Document Extension field, enter the extension of the script files to filter the list of candidates.

On IBM i, you can use alternative IFS naming conventions to access library members. The following entry illustrates this method:

  • In the Location of External SQL Scripts field, enter:
    /QSYS.LIB/MYLIBRARY.LIB/MYSRC.FILE
  • The Extension is understood to be MBR. You can enter this value explicitly or leave the input box blank.

During synonym generation, the adapter issues native API calls to obtain a list of elements in the select list and builds the Master File with a field for each element. The generated Access File references the location of the SQL script in the DATASET attribute, which contains the full path, including the file name and extension to the file containing the SQL Query. For example,

DATASET=/ul/home2/apps/report3.sql

When a WebFOCUS report is created, the SQL Query is used to access data.

Select Application

Select an application directory. The default value is baseapp.

Cardinality

Select the Cardinality check box to reflect the current cardinality (number of rows or tuples) in the table during metadata creation. Cardinality is used for equi-joins. The order of retrieval is based on the size (cardinality) of the table. Smaller tables are read first.

If the cardinality of the tables to be used in the application are dynamic, it may not be beneficial to choose this setting.

With foreign keys

Select the With foreign keys check box to include within this synonym every table related to the current table by a foreign key. The resulting multitable synonym describes all of the foreign key relationships for the table.

Dynamic columns

To specify that the Master File created for the synonym should not contain column information, select the Dynamic columns check box.

If this option is selected, column data is retrieved dynamically from the data source at the time of the request.

Prefix/Suffix

If you have tables with identical table names, assign a prefix or a suffix to distinguish them. For example, if you have identically named human resources and payroll tables, assign the prefix HR to distinguish the synonyms for the human resources tables. Note that the resulting synonym name cannot exceed 64 characters.

If all tables and views have unique names, leave prefix and suffix fields blank.

Customize data type mappings

To change the data type mappings from their default settings, select this check box. The customizable mappings are displayed.

Overwrite existing synonyms

To specify that this synonym should overwrite any earlier synonym with the same fully qualified name, select the Overwrite existing synonyms check box.

Default synonym name

This column displays the name that will be assigned to each synonym. To assign a different name, replace the displayed value.

Select tables

Select tables for which you wish to create synonyms:

  • To select all tables in the list, select the check box to the left of the Default synonym name column heading.
  • To select specific tables, select the corresponding check boxes.


x
Reference: Synonym Creation Parameters for Stored Procedures

For data sources that support stored procedures, you can use a reporting tool to execute a procedure and report against its output parameters and answer set. Among the benefits of this method of executing a stored procedure are:

The first step is to create a synonym for the stored procedure you wish to report against. A synonym describes the parameters and answer set for the stored procedure.

An answer set structure may vary depending on the input parameter values that are provided when the procedure is executed. Therefore, you need to generate a separate synonym for each set of input parameter values that will be provided when the procedure is executed at run time. For example, if users can execute the stored procedure using three different sets of input parameter values, you need to generate three synonyms, one for each set of values. Unless noted otherwise, input parameters refers to IN parameters and to INOUT parameters in IN mode.

Note: If you know the internal logic of the procedure, and are certain which range of input parameter values will generate each answer set structure returned by the procedure, you can create one synonym for each answer set structure. For each synonym, simply provide a representative set of the input parameter values necessary to return that answer set structure.

A synonym includes the following segments:

The following chart describes the parameters used to create the synonym.

Parameter/Task

Description

Restrict object type to

Select Stored Procedures.

Filter by owner/schema and object name

(for DB2, this applies to all platforms except IBM i)

Selecting this option adds the owner/schema and object name parameters to the screen.

  • Owner/Schema. Type a string for filtering the selection, inserting the wildcard character (%) as needed at the beginning and/or end of the string. For example, enter:
    • ABC% to select tables or views whose owner/schema begin with the letters ABC.
    • %ABC to select tables or views whose owner/schema end with the letters ABC.
    • %ABC% to select tables or views whose owner/schema contain the letters ABC at the beginning, middle, or end.
  • Object name. Type a string for filtering the procedure names, inserting the wildcard character (%) as needed at the beginning and/or end of the string. For example, enter:
    • ABC% to select all procedures whose names begin with the letters ABC.
    • %ABC to select all procedures whose names end with the letters ABC.
    • %ABC% to select all procedures whose names contain the letters ABC at the beginning, middle, or end.

Library

Object Name (IBM i only)

To avoid the return of an extremely large and potentially unmanageable list, always supply a value for Library or Object Name:

  • Library. Type a string for filtering the Library (or DB2 Collection), inserting the wildcard character (%) as needed at the beginning and/or end of the string. For example, enter:
    • ABC% to select tables or views whose owner IDs begin with the letters ABC.
    • %ABC to select tables or views whose owner IDs end with the letters ABC.
    • %ABC% to select tables or views whose owner IDs contain the letters ABC at the beginning, middle, or end.
  • Object name. Type a string for filtering the table, view, or object names, inserting the wildcard character (%) as needed at the beginning and/or end of the string. For example, enter:
    • ABC% to select all tables, views, or objects whose names begin with the letters ABC.
    • %ABC to select all whose names end with the letters ABC.
    • %ABC% to select all whose names contain the letters ABC at the beginning, middle, or end.

Select

Select a procedure. You can only select one procedure at a time since each procedure will require unique input in the Values box on the next synonym creation pane.

Name

The name of the synonym, which defaults to the stored procedure name.

Select Application

Select an application directory. The default value is baseapp.

Prefix/Suffix

If you have stored procedures with identical names, assign a prefix or a suffix to distinguish their corresponding synonyms. Note that the resulting synonym name cannot exceed 64 characters.

If all procedures have unique names, leave the prefix and suffix fields blank.

Overwrite existing synonyms

To specify that this synonym should overwrite any earlier synonym with the same fully qualified name, select the Overwrite existing synonyms check box.

Customize data type mappings

To change the data type mappings from their default settings, select this check box. The customizable mappings are displayed. For information about them, see Data Type Support in the chapter for your adapter in the Adapter Administration for UNIX, Windows, OpenVMS, IBM i, and z/OS manual.

Values

Select the check box for every parameter displayed for the specified procedure.

Note the following before you enter parameter values. If the procedure you selected has input parameters (IN parameters and/or INOUT parameters in IN mode), you will be prompted to enter values for them. However, the need for an explicit Value entry depends on the logic of the procedure and the data structures it produces. Therefore, while you must check the parameter box, you may not need to enter a value. Follow these guidelines:

  • Explicit input values (and separate synonyms) are required when input parameter values cause answer sets with different data structures, which vary depending on the input parameters provided.
  • Explicit input values are not required when you know the internal logic of the procedure, and are certain that it always produces the same data structure. In this situation, only one synonym needs to be created and you can leave the Value input blank for synonym creation purposes.

If a Value is required, enter it without quotation marks ("). Any date, date-time, and timestamp parameters must have values entered in an ISO format. Specify the same input parameters that will be provided when the procedure is executed at run time if it is a procedure that requires explicit values.



Example: Synonym for Microsoft SQL Server Stored Procedure CustOrders

The following synonym describes a Microsoft SQL Server stored procedure with one input parameter, one output parameter, and one answer set containing four variables.

The Master File for the synonym is:

FILENAME=CUSTORDERS, SUFFIX=SQLMSS, $
   SEGMENT=INPUT, SEGTYPE=S0, $
      FIELDNAME=@CUSTOMERID, ALIAS=P0001, USAGE=A5, ACTUAL=A5,
         MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
   SEGMENT=OUTPUT, SEGTYPE=S0, PARENT=INPUT, $
      FIELDNAME=@RETURN_VALUE, ALIAS=P0000, USAGE=I11, ACTUAL=I4, $
   SEGMENT=ANSWERSET1, SEGTYPE=S0, PARENT=INPUT, $
      FIELDNAME=ORDERID, ALIAS=OrderID, USAGE=I11, ACTUAL=I4, $
      FIELDNAME=ORDERDATE, ALIAS=OrderDate, USAGE=HYYMDs, ACTUAL=HYYMDs,
         MISSING=ON, $
      FIELDNAME=REQUIREDDATE, ALIAS=RequiredDate, USAGE=HYYMDs,
         ACTUAL=HYYMDs, MISSING=ON, $
      FIELDNAME=SHIPPEDDATE, ALIAS=ShippedDate, USAGE=HYYMDs,
         ACTUAL=HYYMDs, MISSING=ON, $

The Access File for the synonym is:

SEGNAME=INPUT, CONNECTION=ITarget, STPNAME=Northwind.dbo.CustOrders, $
SEGNAME=OUTPUT, STPRESORDER=0, $
SEGNAME=ANSWERSET1, STPRESORDER=1, $


x
Procedure: How to Refresh Synonyms

Refreshing a synonym enables you to update field information while preserving the original synonym title, description, usage, virtual field, and DBA information. The action also synchronizes the Master File with the table on which the synonym is based.

You can refresh synonyms from either the Data Servers area under the WebFOCUS Environments folder or from the Projects area.

  1. Right-click a synonym (Master File).
    • In the WebFOCUS Environments folder, Master Files are listed within an application in the Data Servers Applications area.
    • In the Projects area, Master Files are listed in a Master Files folder under a project name.
  2. Select Refresh Synonym to recreate the Master File.

    Note: Refresh is not applicable to Cube data sources at the current time, and not supported for FOCUS files.



x
Procedure: How to Delete Synonyms

Master Files and Access Files are removed from the server when you delete a synonym.

  1. Right-click the synonym you want to delete and select Delete.

    You are prompted to confirm the deletion.

  2. Click Yes to delete or No to cancel.


x
Procedure: How to View or Edit Synonym Code

This feature is available in the Projects area and in the Data Servers area under the WebFOCUS Environments folder.

  1. Right-click a synonym (Master File).
    • In the Projects area, Master Files are listed in a Master Files folder under a project name.
    • In the WebFOCUS Environments folder, Master Files are listed within an application in the Data Servers Applications area.
  2. Select one of the following:

    In the Projects area:

    • Edit in Synonym Editor opens the file in the Synonym Editor. This is the default option if you double-click the Master File or synonym.
    • Edit in Text Editor displays code in the text editor.
    • Edit in registered tool appears if an external tool is registered through Windows Explorer. The registered tool name is Notepad, WordPad, and so on.

    In the WebFOCUS Environments area:

    • Edit in Synonym Editor opens the file in the Synonym Editor. This is the default option if you double-click the Master File or synonym.
    • Edit in Text Editor displays code in the text editor.
    • Edit in registered tool appears if an external tool is registered through Windows Explorer. The registered tool name is Notepad, WordPad, and so on.
    • Export to Sources creates an extract file containing WebFOCUS metadata that is used for import with the Ascential MetaStage® software. This option is enabled if the Ascential MetaStage software is installed on your PC.

Note: By default, you also see Access (.acx) Files in the Master Files folder.



x
Procedure: How to View and Modify the Properties of a Synonym

Right-click a synonym in the Explorer window and select Properties. The Properties dialog box displays general file information, such as location, size, and other attributes.

The Projects area has options for Attributes. Check one of the following:


Top of page

x
Using the Reporting Server Console for Data Access and Synonym Preparation

How to:

A server user who has been granted the required metadata privileges, can configure and manage adapters, and can be permitted to create synonyms through the Reporting Server Console. You can use the Server Console as an alternative to the Developer Studio tools to configure adapters, add remote servers, and create synonyms. In addition, many other configuration options are available through the Server Console.

For a full understanding of configuration options and server capabilities, see the Server Console help system or the following manuals: Server Administration for UNIX, Windows, OpenVMS, IBM i, and z/OS and Adapter Administration for UNIX, Windows, OpenVMS, IBM i, and z/OS.

Note:



x
Procedure: How to Access the Reporting Server Web Console

To open the Reporting Server Console in Developer Studio:

  1. Click the Reporting Server Console icon from the Object Explorer toolbar or open the following page in a web browser:
    http://hostname:port#/webconsole

    The Server Console opens in your web browser.

  2. To access the Server Console help, click Help and select Contents and Search. Expand the Adapters folder in the Table of Contents, and review the information for your adapter.

WebFOCUS