cancel
Showing results for 
Search instead for 
Did you mean: 

Read C4C Data Source

Former Member
0 Kudos

Hi,

We have few options available to play with Cloud Data Source from BW but cannot read from Cloud Data Source directly.

Please suggest some solution.

1. Web Service - Business Analytics Data Upload

This feature is useful when we push data from BW to Cloud Data Source.

There is no Web Service to read data from Cloud Data Source because this will ease us to handle data table in loop.


2. Web Service - Account 360

Similar to Account 360, all other web services are directly on Business Object ex Account, Lead, Opp etc which means we will have to write ABAP Code in BW for each Cloud business objects, create many DB tables for each bus objects and handle processing accordingly.

Again this would be risky/time consuming and given the time constraint, we have already developed Custom Data Source on Cloud and need some Web Service facility to read data records of DS and get into DB Table on BW.


3. Web Service - Integrating Analytics with an SAP NetWeaver Business Warehouse System

There is this facility using ODP but its not available in our RSA1 because our BW Version is 7.0 and ODP is available in SAP BW 7.3 onwards.

Alim


Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hello

We have configured BW integration and were able to integrated C4C data Source e.g. CODOPPH, CODCUSTOMER

We have one observation, that when the data is integrated in BW data source and extracted, we do not see certain data for character string data type field.

Also in CODCUSTOMER data source we have extracted External ID ( which is our ECC Customer ID).

but when the data source is integrated and extended we do not see this data, in the columns - see below.

other fields are replicated correctly

Other fields are address fields are also blank.

is there a way to fix this. Will appreciate any help

Regards

Thanks

Piyush Gandhi

carlos_hidalgo
Explorer
0 Kudos

Hi Alim.

Is it possible to read data from the Data Source using SDK ?. I need to do some calculations in sdk based on a custom data source.

Thanks!.

Former Member
0 Kudos

These are all great questions. We are about to release a set of how-tos on best practices on integration scenarios that cover all of the above.

You have the following options for integration scenarios for reporting/analytics

1. Data in C4C with Cloud Data Source- this is meant for admins to easily configure an "object" in C4C that you can upload an excel spreadsheet and then be able to see that excel data in Customer Insight, Interactive Dashboards, and C4C BI/Analytics. The Cloud Data Source also has SOAP web services available so you can push data into the Cloud Data Source via a 3rd party application that can consume the Cloud Data Source SOAP APIs

2. Data in C4C with Custom Business Object/Standard Business Object with MDAVs (C4C BI/Analytics enabled)- these have more flexibility than a Cloud Data Source, but also are more complex and thus require more implementation time. With a BO MDAV you can expose the BO data just like a Cloud Data Source in Customer Insight, Interactive Dashboards, and C4C BI/Analytics. To get data in a BO MDAV you have the following ways

a. Push the data in via a 3rd party application that can consume the C4C SOAP or C4C oData APIs for the BO

b. Pull the data in via C4C SDK batch job or a real-time call (user clicks a custom button) that can call a 3rd party SOAP or REST API

c. Push the data in via C4C Migration Workbench/Mass Data Maintenance excels (only for Standard BOs)

d. Push the data in via C4C SDK xml file upload with the WebDAV adapter (only for Custom BOs)

3. Data in BW with ODP- as mentioned above, BW can get data from C4C BOs via ODP.

Former Member
0 Kudos

Hi Rei,

Thanks for your inputs but they are more on Excel data migration OR data transfer from external system to C4C using SOAP API OR data transfer from C4C to external system through Web Service on Business Object.

I think some of which I already explained in my query but I need something that can read data source value from C4C to BW. Any data source Custom/Std.

Also could you please explain if Web Service in C4C/SDK is different then SOAP API.

Alim

Former Member
0 Kudos

The following is available to get data out of C4C. Once you get data out of C4C then you need to figure out how to get it into your reporting/analytics tool like BW. C4C is like any public cloud solution where we provide APIs, simple excel spreadsheets, and a SDK framework to get data out depending on the use case.

In your data warehousing reporting use-case, treat C4C as just another source of data for your ETL (extraction, transformation, and load) process for your BW environment.

a. Pull the data out of C4C via a 3rd party application that can consume the C4C SOAP or C4C oData APIs for the BO. SAP Data Services (Cloud and OnPrem) is an excellent tool that can do this.

b. Push the data out of C4C with C4C SDK batch job or a C4C SDK real-time call (user clicks a custom button) that can call a 3rd party SOAP or REST API

c. Pull the data out of C4C via C4C Migration Workbench/Mass Data Maintenance excels (only for Standard BOs)

How you automate the extraction process from C4C is a BW implementation effort where you need to figure out what BW provides for Extraction or any 3rd party middleware/ETL with what C4C provides to get data out of C4C.

Former Member
0 Kudos

Hi Rei

We also have a requirement to integrate with SAP BW on prem for a Joined Data Source which we have createdusing Std. Data Source

e.g.

Opportunity Header and Item

Account Master Data

Contact Data

The Joined Data Source cannot be exposed as the expose button is greyed out.

Can you suggest how do we integrate this data source to BW without SDK/PDI.

Regards

Thanks

Piyush Gandhi

0 Kudos

Hi Piyush,

It is no longer possible to expose the join data sources to BW from C4C. This has been done to reduce the performance issues. You can refer this documentation in help center " Expose option is disabled for join data sources in 1608". You need to individually expose the data sources to BW system and perform join in BW system. Like in case of Opportunity Header and Item, you can expose individually "Opportunity Header" and "Opportunity Item" data sources and perform join in your BW system.

Thanks,

Trivedhi

Former Member
0 Kudos

Hi Alim,

I have similar requirements.

Data Source replication from C4C to BI

a.    standard data source from SAP C4C to BI

b.      custom data sources from SAP C4C to BI

c.       standard data sources with additional extended KUT fields

1) Is this possible to integrate cloud with BW bi-directional ?

2) If yes what is the possible way to integrate Data Source , Custom Solution with Web Service or Standard Integration?

3) What is the minimum BI version to integrate with cloud system using ODP?

Many Thanks,

Mithun