cancel
Showing results for 
Search instead for 
Did you mean: 

XI-BI

Former Member
0 Kudos

Need to integrate third party databases (datawarehouses / datamarts) to SAP BW using XI. I need to know what are the advantages of using XI as an interface, and can I connect BW to the third party systems without using XI. There might be multiple sources to connect to BW, all Oracle/SQL databases, I need to suggest XI as the mechanism to interface, any document which justifoed why XI should be used.

Thanks

RB

Accepted Solutions (0)

Answers (2)

Answers (2)

agasthuri_doss
Active Contributor
0 Kudos
Former Member
0 Kudos

Hi Ranjeet,

Will probably explain a XI and BW integration which i think might be of help to you....

The integration of SAP XI and SAP BW offers the following advantages:

• Central maintenance of message flow between logical systems of your system landscape.

• Options for transformation of message content between sender and recipient.

Mappings help you to adapt values and structures of your message to the recipient. In this way, you can transfer different types of files to a SAP BW system using interface mapping. However, in any case, it is necessary to transform the data into a format that corresponds to the interface of the function module that is generated in SAP BW and used for data transfer. The function module contains a table parameter with a flat structure. This means that the data have to be transformed so that they fit to a flat structure in SAP BW.

• Using proxy communication with SAP BW.

Proxies are executable interfaces generated in the application systems for communication with the SAP XI Integration Server. We recommend the use of proxies for communication with SAP BW because they guarantee Full Quality of Service (Exactly Once in Order). They also guarantee that the data is delivered only once and in the correct sequence. The SAP XI Integration Server keeps the serialization as it was established by the sender.

Also go thru these links which are really good and it answers your question very clearly:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/21d8aa90-0201-0010-5e83-a37...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/8c10aa90-0201-0010-98a0-f07...

http://help.sap.com/saphelp_nw04/helpdata/en/0f/80243b4a66ae0ce10000000a11402f/frameset.htm

http://www.sap.info/index.php4?ACTION=noframe&url=http://www.sap.info/public/INT/int/index/Category-...

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

http://help.sap.com/saphelp_nw04/helpdata/en/9b/821140d72dc442e10000000a1550b0/content.htm

http://www.microsoft-sap.com/technology.aspx

I hope I have answered your query.

Regards,

Abhy