Skip to Content
Product Information
Author's profile photo Pooja Bhalla

SAP Cloud for Customer integration with SAP Business Warehouse – Know your options

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

 

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

The help portal also provide details on other extraction options.

Assigned tags

      57 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Chandan Bankar
      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

      Author's profile photo Ginger Gatling
      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

      Author's profile photo Ginger Gatling
      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.’

      Author's profile photo Ginger Gatling
      Ginger Gatling

      Hello everyone, the link to the BW guide is now fixed.  Please let us know if you cannot reach it.

      -ginger

      Author's profile photo Bejoy Jacob K
      Bejoy Jacob K

      Thanks Pooja Bhalla

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Marcus Echter
      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

       

      Author's profile photo Julia Bayrhammer
      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

      Author's profile photo Marcus Echter
      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

      Author's profile photo Mario Santoro
      Mario Santoro

      I receive "Access Denied" when I try to access to video on SAPJAM.

      Can you resolve the issue?

      Thank you

      Mario

      Author's profile photo Joao Tiago Ribeiro
      Joao Tiago Ribeiro

      Hello,

      I am having the same issue. Anyone got you an answer?

      I am interested in the documentation.

      Thanks

      João Ribeiro

      Author's profile photo Pooja Bhalla
      Pooja Bhalla
      Blog Post Author
      Author's profile photo Joao Tiago Ribeiro
      Joao Tiago Ribeiro

      Hello Pooja,

      I have access now!

      Thanks a lot.

      Cheers,

      João Ribeiro

      Author's profile photo Saurabh Kumar Pandey
      Saurabh Kumar Pandey

      Hi Pooja ,

      I want to access the videos and ppt document but it says Internal Server Error . Can you help me where i can find the same .

      With regards,
      Saurabh Kumar pandey

      Author's profile photo Shankar Chintada
      Shankar Chintada

      Hi Pooja,

       

      Great Blog.

      As its a ODP service in C4C, can we use BODS (Data Services) to connect the ODP Datasources and load into 3rd party databases ?

      Thank you for your help in advance.

      Regards

      Shankar

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Pooja Bhalla
      Pooja Bhalla
      Blog 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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Pooja Bhalla
      Pooja Bhalla
      Blog Post Author

      Please create a ticket. This will need evaluation

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Pooja Bhalla
      Pooja Bhalla
      Blog Post Author

      This needs to be checked. Please create a ticket for this.

      Author's profile photo Akshay Bhandari
      Akshay Bhandari

      Is the issue resolved. Could you please put some light on the solution..

       

      Regards

      Akshay

      Author's profile photo Meenakshi Palaniappan
      Meenakshi Palaniappan

      Yes, this issue was resolved.

      Data type "Text of variable length with a minimum of 1200 characters" in C4C is mapped as SSTRING in BW, and those fields are of problem. Even if we change data type as CHAR in BW that doesn't help.

      Solution is to apply a OSS Note in BW 2218111 as instructed by SAP, and it worked for us.

       

      Author's profile photo Akshay Bhandari
      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

       

      Author's profile photo Suchita Phulkar
      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

      Author's profile photo Ashwini Kumar Dalai
      Ashwini Kumar Dalai

      Hi Suchita

      You can exposed the survey answers Data source and the visit data source separately, for consumption in BW

       

      Regards,

      Ashwini

       

       

      Author's profile photo Akshay Bhandari
      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

       

      Author's profile photo Vladimir Grigoriev
      Vladimir Grigoriev

      Sorry, but how did you create connection? By WSDL file?

      Author's profile photo Akshay Bhandari
      Akshay Bhandari

      Yes we are using WSDL file for creation of the ODP Connection.

       

      Author's profile photo Vladimir Grigoriev
      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.

      Author's profile photo Former Member
      Former Member

      Hi Vladimir

      Did you get a response ? We have the same issue but find no documentation about that.

      Thanks

      Johann

      Author's profile photo Naveen Kumar Nandyappa
      Naveen Kumar Nandyappa

      Hi,

      Do you know what was the root of this issue? If yes, please share.

      Advance Thanks

      Regards

      Naveen

      Author's profile photo Former Member
      Former Member

      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

       

       

      Author's profile photo Stefan Katschewitz
      Stefan Katschewitz

      Can someone please provide Access to the embedded videos? I have a login to JAM but get only Access Denied. Thank you.

      Author's profile photo Pooja Bhalla
      Pooja Bhalla
      Blog Post Author

      The links are working now.

      Author's profile photo Jens Schwendemann
      Jens Schwendemann

      Same here... Great performance from SAP linking from the official help site of C4C to here where nothing seems working 🙁

      Author's profile photo Former Member
      Former Member

      Hi,

      Seems like i don't have and  access to look into "Outbound Integration (C4C to SAP BW)" recording, can you help me with this.

       

      Thanks,

      Shreyas

      Author's profile photo David Jacobs
      David Jacobs

      Hello,

       

      I also cannot view the 2 presentation because of missing SAP Jam access. Can this be granted?

      Author's profile photo Adriano Puleo
      Adriano Puleo

      Hello,

      can someone please add me to the jam group?

      I can't access the documentation.

      thanks in advance

       

      Adriano

       

      @Pooja Bhalla

      Author's profile photo Suraj Pai
      Suraj Pai

      Hi,

      I do not have access to the files either. Can I be added to the concerned JAM group please.

      Best.. Suraj

      @Pooja Bhalla

      Author's profile photo Pooja Bhalla
      Pooja Bhalla
      Blog Post Author

      The links are updated now.

      Author's profile photo Andreas Tidl
      Andreas Tidl

      Hello SAP,

      Can you please have a follow up, of the existing comments? There are many many users including myself, who like to have access to the documentation you refer to here.

       

      Thank you!

      Regards
      Andreas

      Author's profile photo Pooja Bhalla
      Pooja Bhalla
      Blog Post Author

      Hi Andreas,

       

      The documentation is available at the link below

      https://help.sap.com/viewer/66e9a9081a7b40e38c8604d6617d0311/1811/en-US/0af70eb19a6342848d4979a052d6a13c.html

       

      Regards

      Pooja

      Author's profile photo Shankar Chintada
      Shankar Chintada

      Hi Pooja,

      Any ideas on extracting delta data using OData Service from C4C?

      We successfully connected to C4C using Data Services and able to extract all the required collections. Now we are thinking how to activate all these Collections ( Otherwise called Datasources  ) for Delta to only get changed data going forward.

       

      Regards

      Shankar

      Author's profile photo Pooja Bhalla
      Pooja Bhalla
      Blog Post Author

      Hi Shankar,

      You will have to create pseudo delta using conditions like last changed date etc.

      Regards

      Pooja

      Author's profile photo Rouven Ette
      Rouven Ette

      Hi @Pooja Bhalla

      I also can not play the videos. Can you please grant me access?

      Thanks a lot in advance!

       

      BR

      Rouven

      Author's profile photo Alba Calpe
      Alba Calpe

      Dear @Pooja Bhalla

      I am specially interested in the option "Use BW reports as mashups", but I can not find the related information.

      The link in the post is not working and I can not find any chapter regarding to that in the analytics guide.

      Could you please give me more detailed information?

      Best regards,

      Alba.

      Author's profile photo Pooja Bhalla
      Pooja Bhalla
      Blog Post Author

      Hi Alba,

       

      You can look at the mashup documentation at the link below:

      https://cp.hana.ondemand.com/dps/d/preview/6029d1035487452d858f1cdf229f4af1/1508/en-US/frameset.html?186b3de4763d1014bdd381a74921cf5f.html

      Author's profile photo Hélio Paixão
      Hélio Paixão

      Dear Pooja,

       

      this link is broken

       

       

       

       

       

      Helio Paixao

      Author's profile photo Renato Petrulis
      Renato Petrulis

      Hi @Pooja Bhalla ,

       

      Do you know if there's anything special related to integration between C4C and BW4?

      Just found this note:

      https://apps.support.sap.com/sap/support/knowledge/en/2943427

      Regards,

      Renato

      Author's profile photo Pooja Bhalla
      Pooja Bhalla
      Blog Post Author

      Hi Renato,

       

      What exactly are you looking for?

       

      Regards

      Pooja

      Author's profile photo Renato Petrulis
      Renato Petrulis

      Hi Pooja,

       

      The steps described in this blog does not apply to SAP BW4.

      In the note I mentioned in my last post, SAP says: this integration  is "not officially supported by us."

      Have you had the opportunity to integrate C4 with SAP BW4?

      This is a tip I got from someone at local SAP office.

      SAP%20BW/4HANA

      SAP BW/4HANA

       

      Regards,
      Renato

      Author's profile photo Christophe Posson
      Christophe Posson

      Hello Pooja,

       

      I have the exact same question as Renato. In that note it says ODP is no longer supported. So what is the alternative to integrate C4C to BW4HANA?

       

      Kind regards,

      Christophe

      Author's profile photo Christophe Posson
      Christophe Posson

      Hello @Pooja Bhalla ,

       

      Did you get a chance to look at Renato's question? We are on the verge of starting our technical design to integrate C4C to BW4HANA using oData. But there is not much information available for this.

      So any help would be highly appreciated.

      Thanks in advance,
      Christophe Posson

      Dave De Poorter

      Author's profile photo Hélio Paixão
      Hélio Paixão

      Dear Pooja,

       

      the following links are also broken:

       

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

       

      Helio Paixao

      Author's profile photo Jacques Schreiner
      Jacques Schreiner

      Hi All,

      Recently we've managed to connect C4C to BW4 (via ODP - Web Service) and the data loading into BW4 works well so far.

      I read in the previous messages that ODP would be not supported anymore?! Anyone could please confirm that?

      Besides I'd like to know if it's recommended to use the "old" InfoObject from the BW4 Business Content (0CRM_OHGUID, 0CRM_OHGUID, etc.) or not? There aren't any infoobject 0C4C* available in the Business Content...

      Best Regards,

      Jacques

      Author's profile photo Marco Borgmann
      Marco Borgmann

      Hello Jacques,

      we're thinking in the same direction. Additional to that we found the snote 2943427 which is currently under construction. So theres no confirmation to that point?

      Kind regards

      Marco