Creating DataSources for Web Services 

Use

In order to transfer data into BI using a Web service, the metadata first has to be available in BI in the form of a DataSource.

Procedure

You are in the DataSource tree in the Data Warehousing Workbench.

...

       1.      Select the application components in which the DataSource is to be created and choose Create DataSource.

       2.      In the next screen, enter a technical name for the DataSource, select the type of the DataSource and choose Copy.

The DataSource maintenance screen appears.

       3.      Go to the General tab page.

                            a.      Enter descriptions for the DataSource (short, medium, long).

                            b.      If necessary, specify whether the DataSource may potentially deliver duplicate data records within a request.

       4.      Go to the Extraction tab page.

Define the delta method for the DataSource.

DataSources for Web services support real-time data acquisition. Direct access to data is not supported.

       5.      Go to the Fields tab page.

Here you determine the structure of the DataSource either by defining the fields and field properties directly, or by selecting an InfoObject as a Template InfoObject and transferring its technical properties for the field in the DataSource. You can modify the properties that you have transferred from the InfoObject further to suit your requirements by changing the entries in the field list.

Entering InfoObjects here does not equate to assigning them to DataSource fields.  Assignments are made in the transformation. When you define the transformation, the system proposes the InfoObjects you entered here as InfoObjects that you might want to assign to a field.

       6.      Save and activate the DataSource.

       7.      Go to the Extraction tab page.

The system has generated a function module and a Web service with the DataSource. They are displayed on the Extraction tab page. The Web service is released for the SOAP runtime.

       8.      Copy the technical name of the Web service and choose Web Service Administration.

The administration screen for SOAP runtime appears. You can use the search function to find the Web service. The Web service is displayed in the tree of the SOAP Application for RFC-Compliant FMs. Select the Web service and choose Web Service  → WSDL (Web Service Description Language) to display the WSDL description.

Result

The DataSource is created and is visible in the Data Warehousing Workbench in the application component in the DataSource overview for the Web service source system. When you activate the DataSource, the system generates a PSA table and a transfer program.

Before you can use a Web service to transfer data into BI for the DataSource, create a corresponding InfoPackage (push package). If an InfoPackage is already available for the DataSource, you can test the Web service push in Web service administration. 

See also:

Web Services