Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

XI BW integration

Hi

We are trying to integrate an oracle database and BW 7 using XI. we are however succesfully getting the data from the Oracle database but are experiencing issues when sending the data through to BW. We used the HOW to integrate BW and XI found on the HOW section of the SDN site.

<b>Requirement</b>

We are required to pull data from an Oracle Database to BW 7 system. We can successfully connect and pull data from the database via an sql statement (JDBC adapter)

<b>Integration Repository Setup</b>

- We have created on the BW system a data source and made it available to the integration repository in XI.

- An interface object occup_sql_in has been created and assigned data types as per the sql result = inbound, async

- An interface object ofoOccupation has been created with message type as per the datasource downloaded from BW = inbound, async

<b>BW system</b>

- We created a proxy for ofoOccupation

<b>Integration Directory Setup</b>

- We have maintained our BW system BWD_300

- And have created a communication channel as follows:

- Name; occup_bw_out_com

- Adapter type: XI, Transport Protocol HTTP 1.0, Message Protocol XI 3.0

- Adapter engine Integration Server

- Address Type URL Address

- Targethost : <hostname of our BW system>

- Service ; 8000

- Path :/sap/xi/engine?type=entry

- Authentication type = Use Logon Data for Sap System and we maintained the username and password, client 300

We then created the following:

<b>Sender Agreement</b>

- service BS_JDBC_SENDER

- interface ofoOccupation

- Communication channel occup_sql_in_comm

<b>Receiver Determination</b>

- Sender – service BS_JDBC_SENDER

- Sender interface – ofoOccupation

- Configured Recievers – BWD_300

<b>

Interface determination</b>

- Sender Service BS_JDBC_SENDER

- Sender Interface – ofoOccupation

- Reciever service – BWD_300

- Inbound interface : occup_sql_in

<b>Recciever Agreement</b>

Sender service BS_JDBC_SENDER

- Reciever service BWD_300

- Interface occup_sql_in

- Communication Channel occup_bw_out_comm

<b><i><u>Problem</u></i></b>

The system stays on status to be delivered. Please assist

Regards

Ronny<b></b>

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question