Skip to Content
0
Oct 20, 2015 at 03:33 PM

Extraction from C4C to BW

1380 Views

Hello,

I have some questions regarding sending data from C4C to BW.


Datasources:

CRMSRQHB

And some master data.

Requirements:

1. Best practice to extract data from C4C to BW

  1. How to extract delta data
  2. How to load full data (40000/day, about 10m/year)
  3. Can PI be used for sending data from C4C to BW, then how to extract delta, how to load full data
  • --> in the interface policy of my customer, they want to use PI as much as possible

2. Enhance the datasource in C4C (add fields in the datasource and include logic to fill the value in those fields).

In my research, the standard way is to extract via ODP ByD datasource in BW and then I think it is necessary to filter the value in Infopackge in BW for "delta" extraction (the field for handling delta is necessary e.g. updated date).

I am not sure if C4C can push data from this datasource, then I think PI can be used to send data in BW. (BW have web service datasource in which FM and web service is created to post the data to this datasource (push)). But if push is not possible in this datasoure, I am not sure PI can be used, or it is not too ineffective to use PI here. (I don't know, but I think too ineffective)


Kind regards,

Masa