cancel
Showing results for 
Search instead for 
Did you mean: 

Scenario for data transfer from CRM to BW

Former Member
0 Kudos

Hi Guru's,

Could any one tell me what kind of scenario (e.g. file to file, Idoc to file etc) is used to transfer the data between the following systems using XI interface:

Also, tell me how we can do it......

1. CRM to BW

2. Informatica to BW

3. R3 to BW

4. Oracle to BW

Thanks in advance. I will assign you the points

Regards,

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

about the connection between informatica and BW, I'm not an expert of Informatica, just would suggest to take a look at this document (unfortunately i did'nt found the english version)

http://www.informatica.com/FR/solutions/integration/sap/informatica_sap_bw.pdf

It talks about some BAPIs for exchanging data between Informatica and XI, so probably it would be usefull to evaluate this opportunity first.

Kind Regards,

Sergio

moorthy
Active Contributor
0 Kudos

Hi,

It depends on following parameters:

1) Business Requirement/Functionality

2) As-Is Process if any

3) Volume,frequency,hardware

4) Complexity of the business Process

>>>In General SAP applications systems are integrated with XI thru 3 ways - Idocs(Standard/custom) , RFCs/BAPIs, and Proxy (WAS>6.40)

<i>1. CRM to BW</i>

>>>Here you can use Idoc ->XI->File scenario , Idoc->XI->Proxy scenario etc.

<i>2. Informatica to BW</i>

>>>In this case flat file data will be uploaded into BW. So file->Xi->File/Proxy interface, you can think of

<i>3. R3 to BW</i>

>>>Idoc/RFC->XI->Proxy

<i>4. Oracle to BW</i>

>>>From Oracle Database, you can retrieve the data and you can upload with follwoing options

JDBC Adapter->XI->BW

File->XI->BW

Totally the scenarios for Data transfer is depending on many parameters.

Some of the demos-

https://www.sdn.sap.com/irj/sdn/docs?rid=/webcontent/uuid/110ff05d-0501-0010-a19d-958247c9f798#xi [original link is broken]

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/f36ce30f-0e01-0010-a89b-c15...

Regards,

Moothy

Former Member
0 Kudos

Hi Bharath,

it mainly depends on:

1) what you have to transfer, custom data, standard data (for SAP business logic e.g. customer/delivery)

2) how you need the transfer mode to be (synch/asynch)

3) the volume of data

4) the frequency of data transfer

Consider that a typical scenario for interfacing SAP systems like CRM/R3 with XI is mainly based on IDocs/RFCs/proxy,..

In general when communicating from XI to BW you should prefer Proxy (the first link explains in details why).

I suggest you to have a look at these links:

How to Push Data into BW from XI

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/18dfe590-0201-0010-6b8b-d21...

How to do BW - XI scenario

XI-BI Integration

/people/kamaljeet.kharbanda/blog/2005/09/16/xi-bi-integration

Informatica to BW

http://www.informatica.com/FR/solutions/integration/sap/informatica_sap_bw.pdf

Getting data from external system

Real World Scenarios of SAP XI

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/e17fdb90-0201-0010-2cb6-fe9...

CRM - XI integration

Kind Regards,

Sergio