Skip to Content

Cloud for Customer comes along with strong analytics capabilities which helps drive insights in real time. C4C not just helps you to report on data available within the system but also provides you capability to upload data from external system.

In case the corporate strategy is to utilize a central reporting system for all reporting needs, C4C provides capability to extract data to external system.

In this blog we will cover in the options available for integration with SAP NetWeaver Business Warehouse (BW).

The following options are available for C4C and SAP BW integration:

Outbound Integration (C4C to SAP BW)

  • Transfer data from C4C to BW using the ODP connector
  • Pull C4C report data via ODATA

Inbound Integration (SAP BW to C4C)

  • Transfer data from BW to a C4C Cloud Data Source
  • Use BW reports as mashups

This presentation  describes the setup required for each option.

We have two guides to help you with the implementation:  Integration with BW  and our Mashup Authoring Quick Guide.

The combination of the presentation and the guides will get you started on integration with BW.

The video recording of the conversations are available as outlined below:

Outbound Integration (C4C to SAP BW)

  • Transfer data from C4C to BW using the ODP connector
  • Pull C4C report data via ODATA

SNAG-0330.png

Inbound Integration (SAP BW to C4C)

  • Transfer data from BW to a C4C Cloud Data Source
  • Use BW reports as mashups

SNAG-0328.png

To report this post you need to login first.

33 Comments

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

  1. Chandan Bankar

    Hello Pooja,

    I am not able to access the two documents –  Integration with BW  and our Mashup Authoring Quick Guide.

    Not sure if any one else facing this.

    Regards,

    Chandan

    (0) 
    1. Ginger Gatling

      HI Chandan,

      The links are now fixed.  I noticed the BW one opens up the analytics guide, but I can’t see the BW integration content.  We’ve reached out to our documentation colleagues and I expect we will have a fix soon.  The mashup links will now work.  It takes you to the IT operations/setup guide, directly to the mashups section.

      Ginger

      (0) 
      1. Ginger Gatling

        We now have an answer on the BW link. There is a fix, but it won’t be live until the 1511 documentation updates are published.  In the meantime, use the work-around below.  

        Click on the link in the blog for the BW integration guide, then:

        Problem: The user has to navigate to the end and then click the > sign and it will open the hierarchy below it. It’s too unnecessary extra clicks. But at least you can access the document. Maybe you can add the following note next to the link:

        ‘Note: Please navigate to the end of the guide to locate the BW Integration document, and click on the node to open the hierarchy.’

        (0) 
  2. S VALDI

    Hi all, quick question on C4C to BW integration scenario (outbound, BW is the reporting system).

    When creating the communication arrangement, it is created as inbound. Not sure if this is just a terminology issue ( I was expecting it to be an outbound, but outbound is not available). Is extracting data from C4C to BW an inbound connection from C4C?

    Apologies if I need to post my question in a different place, let me know where.

    Many thanks

    (0) 
    1. Marcus Echter

      Hi,

      the CA is inbound because it is a synchronous inbound query webservice. It is a query-response scenario triggered from BW.

      Regards, Marcus

       

      (0) 
  3. Julia Bayrhammer

    Hello all,

    additionally I’ve got another question: is it possible to connect BW system via PI to C4C?

    In our case data from C4C should be send to BW for analyzing purposes, so direction will be C4C – PI – BW.

    Regards,

    Julia

    (0) 
    1. Marcus Echter

      Hi Julia,

      yes this is possible. You would need to enter the PI host URL in BW source system in this case and route the request on PI to C4C. On PI you need a dummy iflow to do this.

      Regards, Marcus

      (0) 
  4. Piyush Gandhi

    Hello

    We have created a Joined Data Source by Joining serval C4C Standard Data Source, e.g. Opportunity Header and Item Data Source, Account Master Data , Contact Master Data

    We want to expose this  Joined Data Source to BW.

    But the Expose button is greyed out.

    Can any one advise how to expose a Z-namespace Data source created in C4C by joining serval Std. Data Source.

    Regards

    Piyush Gandhi

    (0) 
    1. Pooja Bhalla Post author

      Hi Piyush,

      For performance reasons we recommed that you expose individual datasources to BW and join them there.

      Exposing join DS is not allowed.

      Regards

      Pooja

      (0) 
  5. mk p

    Hi Pooja,

    We exposed Account master data to BW. But external id received in BW PSA is empty for all accounts.

    But when running the Account master data report on C4C side, it shows external id values.

    Similarly we cannot see Account Description, etc..Those fields are also received empty in BW.

    Please advise what are we missing.

    Thanks

    (0) 
  6. Piyush Gandhi

    Hello

    Need some advice

    As also mentioned by MK-P , We have created a Data Source for CODCUSTOMER data source from C4C. Since we need the External ID ( ECC Customer number ID) in BW as this is available in the CODCUSTOMER data source, So is the Account name. City, Address data is empty when we check the data replicated in BW. Seems the Character String Type fields are not replicating, See below Can you Account Data.JPG

    Can you advise what we are missing here , since even in opportunity (CODOPPH) data source we had a similar issue, the opportunity description did not replicate in BW.

    Do we need do anything in BW which will enable the correct data integration

    Regards

    Piyush Gandhi

    (0) 
    1. Akshay Bhandari

      Hello Piyush,

      Did you get the resolution for the issue

      We have a data issue while integrating the BW system with the C4C system.

      When the data for the datasource is previewed in C4C system the data is being properly displayed. But when the data is extracted in BW system and the datasource is previewed instead of the data the UUID is displayed.

      Eg. In case datasource CODOPPH – we require Opportunity name (DOC_UUID) and Opportunity ID (DOC_ID) the fields are displayed correctly i.e we are able to view the Opportunity name and Opportunity ID at the C4C end. But in case of BW UUID is displayed for Opportunity name and opportunity id is displayed correctly.

      Could you please help us in this regards

      Regards

      Akshay

       

      (0) 
  7. Suchita Phulkar

    @Pooja Bhalla – Hi Pooja, I understand from this blog that joined DS can not be exposed for consumption in BW. My requirement is to have the C4C Visit Survey Answers in SAP BW system which is the central analytics system . Now the problem is, C4C Data source ‘Visit Survey Answers’ is a joined data source and if I check the individual data sources of it, there are many which are now available as Data Source under Business Analytics ( for example CODINDICATORV, GREGFISCB etc. I believe SAP use them internally). Does this mean there is no way to get the Survey Visit Answers reported in BW ? Alternatively, Is it possible for BW to pull C4C Visit Survey Answers report data from C4C ? Can you please share your thoughts  ? Many thanks in advance

    (0) 
  8. Akshay Bhandari

     

    ​Hello Bernd,

    BW C4C integration

    I need some clarification if you have worked in this area of integration between BW system is as below. We have connected SAP BW system 7.4 with SAP C4C system 1702 (Cloud for Customer) using ODP connection.

    1. When the data for the datasource is previewed in C4C system the data is being properly displayed. But when the data is extracted in BW system and the datasource is previewed instead of the data the UUID is displayed.Eg. In case datasource CODOPPH – we require Opportunity name (DOC_UUID) and Opportunity ID (DOC_ID) the fields are displayed correctly i.e we are able to view the Opportunity name and Opportunity ID at the C4C end. But in case of BW UUID is displayed for Opportunity name and opportunity id is displayed correctly.

    How can the exact description/name of the Opportunity can be extracted in the BW system from SAP C4C System.Could you please help us out in this regards

    Many Thanks

    Akshay

     

    (0) 
  9. Vladimir Grigoriev

    Hello!

    We tried to create C4C/BW connection to uplad data from C4C to BW. We exported WSDL file, but when I tried to import it I had issue:

    The WSDL document is not compatible with proxy class “CO_RSDSPX_ODP_IN”: “Unsupported Operation(s): GetList, GetContextList, GetDetails, GetCursorList, OpenCursor, FetchCursorPackage, CloseCursor, FetchDataDirect, CloseSubsc”

    Please, assist.

    (0) 
  10. Herve Seidou Toure

    Hello Everybody,

    I just want to post the issue we have while trying to connect BW to C4C via HTML-Mashup.

    1. A Report is created for this purpose and we copied the corresponding URL (http://….synthomer.cen) to use it in the mashup configuration in C4C
    2. HTML-Mashup has been set up and embedded in C4C (we created a button “SAP BW”)
    3. But when we click on that button the area where the mashup is supposed to be shown is loading all the time without any error message!

    Do someone has an idea how to fix this issue?

    I appreciate your feedback and help.

    Best regards

    Herve

     

     

    (0) 

Leave a Reply