Introduction

The webservice datasource works with a push mechanicm allow the datadelivery from the source system which is initiating the
extraction process. (As of 7.3 this can also be a pull datasource meaning bw can initiate the data retrieve.)

Configuring the webservice,

which uses the standardized XML format, is done in the administrator workbench.

To receive soap documents the SOAP service needs to be active in SICF only then data can be sent to bw through webservices.

C17.01.png

Before the datasource can be configured a sources system of the type webservice needs to be created. 

/wp-content/uploads/2014/01/17_01_365493.png

Maintain the necessary fields in the datasource and create an infopackage.

A17.01.png

B17.01.png

On the web services navigator test the WSDL service interface which can be access by going through the the Netweaver Java Application
Server.

H17.01.png

D17.01.png

To retrieve the URL with the XML definition go through WSADMIN (the transaction is obsolete from SAP NetWeaver AS 7.00, SP14) use SOAMANAGER.

Make sure that the port is setup properly in SAP Netweaver Administrator –> SOA tab –> SOA Middleware Global Settings –> HTTP Proxy tab.

Take the URL and provide it in the Web Service Navigator to test your webservice.  The webservice shows the defined fields provided in the definition of the datasource. After the import “manage PSA” will show the new created entry.

E17.01.pngF17.01.png

The webservice is working.

G17.01.png

    

The XML-Schema defines the rules how the XML document has to be structured. The document used to exchange data needs to
be “well-formed” and “valid”. Meaning it has to contain all rules according to W3C. World Wide Web Consortium (W3C)

To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

  1. CH Raman

    Thanks for exploring  web service based  data extraction. Good presentation and this doc more opt to business content extractors forum.

    Thanks for your efforts.

    Raman

    (0) 
  2. Limbadri Sabbani

    Hello Martin,

    Wow one more nice doc.

    Thanks for your efforts and your dedication to explore & share new things. It seems you are fully charged 😉

    Keep it up 😎

    Excited to see next topic.

    Regards,

    LS

    (0) 
  3. Harish Allachervu

    Hi Martin,

    as usual informative doc actually in the current blog you’ve given more insight about configuration of data extraction from webservice but i’ve one query here like if you want to schedule through process chain what are the steps need to be followed i know like something called daemon as such but not sure how this settings will be done if you aware of this can you please through some light on my concern.

    Thanks & Regards,

    Harish

    (0) 
  4. Daniel Ray

    Hi Martin,

    But how can we use SLT for the classic BW on HANA standard extractors for eg. 2LIS_13_VAITM where its further loaded to hana optimized IC. …I mean if we have BW on HANA, and want to use SLT to extract data to BW using this standard data extractor. How can we use webservice to extract data from ECC to BW on HANA using SLT.

    Can we use your above process to do this ? Please advice.

    Thanks

    DR

    (0) 
    1. Martin Grob Post author

      you can’t use SLT on the logistics extractors.you need to find the underlying base table and rebuild the logic of the extractor in order to use slt

      (0) 
      1. Daniel Ray

        Thanks for the reply Martin. But I got a reply from another blog that we can use it and was given this link to analyze. Configure a webservice datasource in #BW.

        However, I could not find anything which specifically suggest to use LO extractor’s for SLT through BW. I would appreciate if you can please update on the below 2 queries.

        1) We can still go use the LO extractors through SLT to a HANA view’s through Data services designer, and replicate these views to BW and use a Virtual provider on top of it with BW MD, and use it in BW bex reporting.

        2) Except LO datasources, we can use other standard SAP delivered datasource’s by  SLT replication to SAP BW on HANA. Is it true ?

        3) Can we use the SAP Delivered LO Datasource’s to replicate on SAP HANA VIEWS through direct extractor connection ?

        Thanks again

        DR

        (0) 
        1. Martin Grob Post author

          hi

          this blog only describes who you esablish and connect to a webservice in bw it has nothing to do with slt. SLT requires a transparent table (or maybe a view) but it cannot work with LO extractors or standard datasources unless you find the table behind it. I’m afraid HANA technology wont help you with the LO extractors.

          (0) 

Leave a Reply