Product Information
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
The help portal also provide details on other extraction options.
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
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
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.’
Hello everyone, the link to the BW guide is now fixed. Please let us know if you cannot reach it.
-ginger
Thanks Pooja Bhalla
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
Hi,
the CA is inbound because it is a synchronous inbound query webservice. It is a query-response scenario triggered from BW.
Regards, Marcus
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
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
I receive "Access Denied" when I try to access to video on SAPJAM.
Can you resolve the issue?
Thank you
Mario
Hello,
I am having the same issue. Anyone got you an answer?
I am interested in the documentation.
Thanks
João Ribeiro
Please try to access the presentationm from the link below:
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/102f4d0b-454a-3310-87a2-f767c08e9159?QuickLink=index&overridelayout=true&60550448939173
Hello Pooja,
I have access now!
Thanks a lot.
Cheers,
João Ribeiro
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
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
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
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
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
Please create a ticket. This will need evaluation
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
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
This needs to be checked. Please create a ticket for this.
Is the issue resolved. Could you please put some light on the solution..
Regards
Akshay
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.
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
@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
Hi Suchita
You can exposed the survey answers Data source and the visit data source separately, for consumption in BW
Regards,
Ashwini
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.
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
Sorry, but how did you create connection? By WSDL file?
Yes we are using WSDL file for creation of the ODP Connection.
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.
Hi Vladimir
Did you get a response ? We have the same issue but find no documentation about that.
Thanks
Johann
Hi,
Do you know what was the root of this issue? If yes, please share.
Advance Thanks
Regards
Naveen
Hello Everybody,
I just want to post the issue we have while trying to connect BW to C4C via HTML-Mashup.
Do someone has an idea how to fix this issue?
I appreciate your feedback and help.
Best regards
Herve
Can someone please provide Access to the embedded videos? I have a login to JAM but get only Access Denied. Thank you.
The links are working now.
Same here... Great performance from SAP linking from the official help site of C4C to here where nothing seems working 🙁
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
Hello,
I also cannot view the 2 presentation because of missing SAP Jam access. Can this be granted?
Hello,
can someone please add me to the jam group?
I can't access the documentation.
thanks in advance
Adriano
@Pooja Bhalla
Hi,
I do not have access to the files either. Can I be added to the concerned JAM group please.
Best.. Suraj
@Pooja Bhalla
The links are updated now.
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
Hi Andreas,
The documentation is available at the link below
https://help.sap.com/viewer/66e9a9081a7b40e38c8604d6617d0311/1811/en-US/0af70eb19a6342848d4979a052d6a13c.html
Regards
Pooja
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
Hi Shankar,
You will have to create pseudo delta using conditions like last changed date etc.
Regards
Pooja
Hi @Pooja Bhalla
I also can not play the videos. Can you please grant me access?
Thanks a lot in advance!
BR
Rouven
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.
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
Dear Pooja,
this link is broken
https://cp.hana.ondemand.com/dps/d/preview/6029d1035487452d858f1cdf229f4af1/1508/en-US/frameset.html?186b3de4763d1014bdd381a74921cf5f.html
Helio Paixao
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
Hi Renato,
What exactly are you looking for?
Regards
Pooja
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 BW/4HANA
Regards,
Renato
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
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
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
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
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
Hi Pooja
All the links are broken. Could you please share it once again. I want inbound part BW to C4C.
Thanks
Hello All,
I removed the links to the two guides that were out of date and will ask the relevant team to add a comment with the right reference
Regards,
Dedi
Any luck on this? In specific, like Murugesh above, i am interested in inbound part BW to C4C. In specific, BW report as mashup in C4C without SAC?