Real time data extraction from Salesforce.com using SAP BODS

[Former Member]

Hi,

Can any one of you provide information on how to extract changed data from Salesforce.com using SAP BODS.

I will be grateful if you can provide multiple options in detail manner.

Thanks!

Chiru

[former_member211387]

Hi

In order for realtime extraction from SFDC, the guide is your best reference.

One thing to keep in mind is to whitelist the SFDC url in the jobserver and CMC server hosting the webserver. You should add *.Salesforce.com to your trusted sites on these two servers.

once you set-up your adapter and services, you will be able to extract data from SFDC in realtime.

kind regards

Raghu

[Former Member]

Hi Raghu,

Thanks for your response.

My point here is we have a method to extract changed data using CDC table.

But for real time we need XML as source. Can you explain how this can be achievable. Can we do anything with Webservices. Can i get WSDL files from Salesforce.com for configuration and all.

Please explain.

Thanks!

Chiru

[Former Member]

Hi,

See page no. 23

http://help.sap.com/businessobject/product_guides/boexir32/en/xi32_ds_salesforce_en.pdf

Thanks,
Arun

[Former Member]

Hi Arun,

Thanks for your response. I have seen that and my doubt is whether we have to create CDC table in the source system or by default we will have CDC table in the salesforce.com. Please explain.

The source system which we are using is supposed not be changed as lot of business tranactions where going on.

Can you explain me without CDC concept.. Can we do anything with webservices.

And one more is for real time jobs source should be XML message from source system. If we use CDC table, how can we convert into XML in real time.

Thanks!

Chiru

[Former Member]

Hi,

I dont have much idea on salesforce, but the way it works is you have to create a saleforce cdc and use a map_cdc transform to load to the target.

Arun