Show TOC

Procedure documentationFind Data Locate this document in the navigation structure

 

You add the data services required as the sources of information processed in the iView.

You can create an iView using data services from a number of different back-end systems. For example, you might use a stored procedure from an Oracle system (imported through the JDBC connector) to call up data that is subsequently used as input to an SAP R/3 BAPI, and output to a table.

This graphic is explained in the accompanying text.

iView that contains SQL stored procedure and R/3 BAPI

Note Note

Visual Composer supports Web services that are compliant with the Basic Profile 1 standard of the Web Services Interoperability (WS-I) Organization. In addition, connections to Web services for SAP back-end systems must be performed via logical destinations (configured in the SAP J2EE engine with the Visual Administrator) and not via portal systems.

End of the note.

Prerequisites

You have opened (drilled down into) the iView that will contain the data service(s).

Procedure

  1. Click the Find Data button in the task-panel toolbar.

  2. From the System drop-down list at the top of the task panel, select the alias of the system from which you will retrieve the first data service.

    Note Note

    You can use the keyboard to type the partial or full system alias, to facilitate locating its name in the list.

    End of the note.

  3. Use the fields and drop-down lists displayed (according to system type) to enter your search criteria, and then click Search. All data services matching the search criteria and residing in the selected system are displayed.

    Note Note

    When you perform a search on a repository-based Web service system, you use the Group criteria to search for the Web service's operations, sorted by groups. When searching for third party Web services, you use the Operations criteria.

    End of the note.

  4. From the results list, locate the data service that you require and drag it onto the workspace. If needed, the Define Data Service dialog box is displayed, listing the ports and the metadata of the data service. You can use this dialog box to display or hide different ports of the data service, and to select the fields that will be channeled through the selected ports.

  5. Once you have defined the parameters of the data service, click OK to close the dialog box and, if required, answer the confirmation message.

  6. To import one or more additional data services, repeat the procedure from step 2 (if the data service resides in a different system) or step 3.

    Note Note

    If you are composing a complex model that contains a number of data services that process a large amount of data, you should use a nested iView to "chunk"parts of the model for streamlined processing. In conjunction with this, you can define a dedicated connection for the "heavier" data services. To do so, choose   Tools   Options   Compiler   tab and select the Use dedicated connections for nested iViews checkbox. For more information about nested iViews, see Create Interrelated iViews.

    End of the note.

  7. You can test the functionality of a data service by right-clicking its icon and choosing Test Data Service from the context menu. In the Test Data Service dialog box, enter values into the mandatory fields and click Execute to display the results of the query. When you are done testing, click Close.

Result

You are ready to model the iView logic, by creating and defining the UI elements and their connections.

More Information