Skip to Content

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>

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 10:21 AM

    Hi,

    You have to activate them in Integration Directory-----Configuration and the try ...hope it wil work this time..

    Reward With points

    Regards

    Sai Ganesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 22, 2007 at 01:01 PM

    Hi

    Thank you all for such a speedy response. I have gone and activated all the queues, however I am now getting teh following error on

    SAP:Stack>Proxy calls are not permitted on sender or receiver side on the IS (client)</SAP:Stack

    My XI System is setup as an Integration Server and my BW system (where the proxy is activated) is set to Application server

    Please assist.

    Regards

    Ronny

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 21, 2007 at 10:06 AM

    go to smq2 in XI and check if there are any entries. In case there is, then activate them all.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 11:56 AM

    hi ,

    i am nt very sure abt this but you are using XI adapter so just give the details in <b>Header Mapping in receiver Agreement in ID</b>

    also clear your queues.

    hope this will help

    regards

    HONEy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2007 at 12:07 PM

    hi

    first check your credntials and then check right on your input and output folder

    sometimes files gets stuck in RWB in the to be delivering status due to large file size or due to unavailable service at that time.

    if you find this file in RWB in the status to be delievering then click on the left of the row showing your message and select it then click on resend it

    It may ask you for your password

    give the right credentials hope it may be successful

    thanks

    Sandeep Sharma

    PS:reward with points if helpful

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.