IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Expand all | Collapse all

Integration Between WebMethods and SAP BW(Business Warehouse)

  • 1.  Integration Between WebMethods and SAP BW(Business Warehouse)

    Posted Tue October 04, 2016 11:08 AM

    Dear Guys,

    Actually i am searching for methods to establish and implement connectivity and integration Between webMethods and SAP BW(Business Warehouse).
    Can you help on this.


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 2.  RE: Integration Between WebMethods and SAP BW(Business Warehouse)

    Posted Tue October 04, 2016 11:54 AM

    I believe you can connect to SAP BW in various ways via SAP Adapter connection and invoke their available BAPIs/BADIs/RFC’s and also send data via flat files thru, so AL11 can pick up the files and send it to BW system for downstream reporting etc…

    Have you review communication options with the BW/Basis team and so they can assist vs what available in wM Sap Adapter wise?

    HTH,
    RMG


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 3.  RE: Integration Between WebMethods and SAP BW(Business Warehouse)

    Posted Wed October 05, 2016 07:03 AM

    SO i think much changes required from SAP BW side.little from wM perspective.
    any web-services or HTTP post is also usable.
    appreciate your help.


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 4.  RE: Integration Between WebMethods and SAP BW(Business Warehouse)

    Posted Wed October 05, 2016 07:26 AM

    What’s your requirement, accordingly we can say what changes to be done at wM end.

    Thanks,


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 5.  RE: Integration Between WebMethods and SAP BW(Business Warehouse)

    Posted Wed October 05, 2016 07:27 AM

    Also, are you using BAPI or RFC calls to deal with SAP BW ?

    Thanks,


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 6.  RE: Integration Between WebMethods and SAP BW(Business Warehouse)

    Posted Wed October 05, 2016 08:50 AM

    iF BAPI or RFC call is working with SAP bW then i can go with this approach.
    Requirement is already mentionend integration communication methods with wM and SAPBW.
    what initials required things we need to integrate both.


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 7.  RE: Integration Between WebMethods and SAP BW(Business Warehouse)

    Posted Wed October 05, 2016 01:18 PM

    First and foremost you need to setup SAP Adapter connection to your SAP ECC system and then work with Basis and BW team to setup RFC’s and so wM can invoke those available RFC’s (function modules) via Adapter Services and send the data to BW.

    Is your integrations involves bi-directional way?

    HTH,
    RMG


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 8.  RE: Integration Between WebMethods and SAP BW(Business Warehouse)

    Posted Wed October 05, 2016 03:50 PM

    BW integration is feasible with SAP Adapter. Make sure you have the latest fix levels installed. If you have any questions or concerns while implementation kindly post it here.


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 9.  RE: Integration Between WebMethods and SAP BW(Business Warehouse)

    Posted Thu October 06, 2016 05:59 AM

    Dear RMG.

    I got Some information like SAP can’t expose a RFC from SAPBW end.is this True?
    and like u asked the integration is required from both sides.
    Do we have more communication methods with SAPBW like polling,HTTP POST or webservices?


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 10.  RE: Integration Between WebMethods and SAP BW(Business Warehouse)

    Posted Fri October 07, 2016 09:34 AM

    Any Webservice communication can happen with SAP BW and webMethods,Because i came to know that SAP bW can only push data not able to Pull data and it doesn’t allow you pull data by External systems.


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 11.  RE: Integration Between WebMethods and SAP BW(Business Warehouse)

    Posted Sat October 08, 2016 06:44 AM

    There is no such wS communication mechanism b/w them. You ask them do they use BAPI for communication with other systems.

    Thanks,


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 12.  RE: Integration Between WebMethods and SAP BW(Business Warehouse)

    Posted Wed April 12, 2017 09:04 AM

    I had done guys completed both ways

    wM->SAPBW pushed data through webservices,For any fuction module with given fields,They can create a webservice unit provider.YOu can select namespace SOAP to use and throw your data…

    SAPBW->WM they will provide an RFC details and fields.they will put data into the open hub table and then they can run a process chain and you can make their signal green with one status field and send it to third party

    They can do for both bulk data and delta load…

    after this while communicating with dev test and prod environment when you will hit the URL in webservice,you will get a Virtual interface not found error,Solution for that is say BW team to activate all deactivated instance of webservice with the use of admin security Id only,

    This will enable webservice interface at their side and you can push your data…


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB