x

1. Select the Reporting Server you want to configure from the Data Servers area.
2. Right-click the Applications folder and select Configure Application Path.

   The Application Path dialog box appears as shown in the following image.

   

3. Select the In Path check box for the Configuration Path you want to set.

   The following options are available in the Application Path dialog box.

   • You can change the Application Path search order by using the arrows to move the selected application up or down.
   • The Preview button displays the syntax of the Application Path statement that will be created.
   • The Test button performs a test against the Application Path and provides file statistics.
4. Click Save to exit and save changes.

   If APPLOCK is set on the server, the option to configure the Application Path will not be available. In this case, you will only see applications that you are allowed to access. Other commands, such as New Application, Create, Delete, Rename will be disabled.

x

You can select to view applications that are only in the Reporting Servers Application Path by selecting a server under the Data Servers area.

1. Select the Reporting Server you want to configure from the Data Servers area.
2. Right-click the Applications folder and select Show Applications in Path to see all available applications, as shown in the following image.

   

   If APPLOCK is set on the server, the options to control how applications are displayed are not available. In this case, you will only see applications that you are allowed to access. Other commands, such as New Application, Create, Delete, and Rename will be disabled.

x

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

1. Expand your WebFOCUS Environment.
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, and then proceed as described.

6. Select New and then Synonym, as shown in the following image.

   

   The Create Synonym tool opens. By default, no adapters are available. Your first task is to configure an adapter in order to be able to access a relational, multidimensional, or other type of data source.

   

   Note: If any adapters have already been configured for the server, they will be listed under the Configured folder.

7. In this instance, we are assuming that no adapters are available. Expand the Available folder icon, select the required adapter, and click Configure, as shown in the image below.

   

   Depending upon your needs, you can use this window to start configuring an adapter, adding a remote server, or both.

   • Configured. This folder contains any data adapters or remote servers that are already configured. By default, when Developer Studio is installed on its own, the Configured folder displays a Remote Servers folder that contains EDASERVE, the default WebFOCUS Reporting Server, plus any other remote Servers that may be configured with your environment.

     You can use the Configured folder to create synonyms.

     Note: To add a new connection, right-click your server name in the Data Servers area and select Manage Adapters.

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

x

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. There are two ways to launch the Create Synonym tool from Developer Studio reporting tools:
   • Click Create New from the Open dialog box, as shown in the image below.

     

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

     

     Note: When accessing a Developer Studio Tool in the Managed Reporting Developer Edition, the Create New button will not appear for developers without Data Server privileges. The Data Server privilege is optional for Developers and standard for Content Managers and Managed Reporting Administrators. This restriction does not apply to the full edition of Developer Studio.

   The Create Synonym Tool opens, as shown in the following image.

   

2. Continue using the tool as described in this chapter. For more information, see Configuring Adapters and Remote Servers in Developer Studio.

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

1. Expand your WebFOCUS environment, right-click EDASERVE, and select Manage Adapters. For the Projects area, select the root folder Projects on, then right-click and select Manage Adapters.

   

   The Manage and Configure Adapters dialog box opens, as shown in the following image.

   

2. Select the adapter you want to configure, as shown in the following image.

   

3. Click Configure.

   The Adapter Configuration dialog box appears, as shown in the following image.

   An MS SQL Server adapter is issued for this configuration example.

   

   This dialog box enables you to define connection parameters for the adapter, including Connection Name, Server, Security, profile, and Default Database.

4. Click Configure.

   A dialog box displays, informing you that the adapter was successfully added to the configuration.

   

   From the Manage and Configure Adapters dialog box you can also manage existing adapter connections, change properties, add connections, test connections, delete connections, and create synonyms.

   

x

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

From the Projects area, right-click the root folder Projects On and select Manage Adapters.

1. Expand the Configured folder in the Manage and Configure Adapters window of the Create Synonym tool.
2. Select Remote Servers and choose Add Remote Server Connection.

   

   The Remote Server Configuration dialog box opens, containing fields to define the connection, as shown in the following image.

   

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 host name 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 number higher than the base TCP port. The default is normally 8121, not 8101.
   SECURITY	Specify how a user should log on to the remote server: IWA (Integrated Windows Authentication, Windows only). Passes your Windows user ID and password to the server when a connection is made. 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.
   HTTP_SSL	Defines whether the Secure Sockets Layer protocol is used in the Web Console listener of the remote server. Type: 0 if no SSL is used in the connection to the Web Console. 1 if SSL is used in the connection to the Web Console.
   COMPRESSION	Activates data compression in a data transfer between the 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 a user-defined algorithm. Key is 512-bit RSA-encrypted. Note: Encryption is not supported for the PIPE protocol. Only 0 and DES are supported for the HTTP protocol.
   CONNECT_LIMIT	Defines the maximum time, in seconds, that the client will wait for a TCP connection response from the server. Enter: -1 for an 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 Cancel to exit tool or Create Synonym to continue and create synonyms for the new remote server.
7. When you open the Manage and Configure Adapters dialog box, the following options appear when you select a configured remote server: Create Synonym, Test, Delete, and Properties.

8. Click Test to test the connection.

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

9. Click Close.

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

10. Click Close.

Your next step depends on your objectives and your server configuration:

• If you wish to make the new remote server visible in and accessible from the Data Servers folder as a distinct named entity, your next step is adding the remote server to your WebFOCUS Client configuration. The listing of servers in this location is controlled by the WebFOCUS Client and implemented through the WebFOCUS Administration Console. Proceed to Defining a Remote Server in the WebFOCUS Client Communication File.
• If your objective is to access data on the remote server through your default server, you must determine if the appropriate adapter and required synonyms already exist on the remote server. If they do not exist, you must configure and create them. See Configuring Adapters in Developer Studio and then Creating Synonyms in Developer Studio.