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 should 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.      Maintain tab page General.

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

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

       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.

       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.

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

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-Enabled Function Modules. Select the Web service and choose Web Service  ® WSDL (Web Service Description Language) to display the WSDL description.

Result

A PSA is created in BI with the DataSource. You can transfer the data to the PSA using a push. 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.