Plain HTTP Adapter

[Former Member]

Hi All,

I am working on a scenario ,

ThirdyPartyDB(Oracle) --> PI -->SAP.

I am not using JDBC Sender between OracleDB and PI.

As client wants event based trigger from Thrid party system.When ever a event occurs,the third party system(DB) would send data to PI.So I suggested them to write a Stored procedure to convert their DB Table data to XML format and send it over HTTP .

Now, I need to given them a HTTP URL where they need to send their data.So, in this case will I use Sender HTTP adapter or Receiver HTTP adapter?

Please provide some heelp on the follwoing scenario DB(Stored Procedure) >HTTP Adapter->PI>Idoc->SAP.Could you please givea sample DB stored procedure as how to convert data in DB to XML and send that to HTTP URL.

Venu

[Former Member · Accepted solution]

Thanks , I have a couple of question,

1. Should the URL which I need to provide the DB guys looks like this ,

http://hostname:port/sap/xi/adapter_plain?namespace=http%3A//svg.com/target&interface=mi_test&servic... user&sap-password=password&sap-client=001&sap-language=EN

Do i need to register do setting XI for this URL , i mean exposing this URL etc...

2.Assume that, the DB guy is sending two fields test1 and test2 , so would the XML look like

<?xml version="1.0" encoding="UTF-8"?>

<ns0:mt_test xmlns:ns0="http://svg.com/target">

<test1>value1</test1>

<test2>value2</test2>

<test3>value3</test3>

</ns0:mt_test>

or is it enough if the DB guy sends the below XML

<test1>value1</test1>

<test2>value2</test2>

<test3>value3</test3>

Thanks in advance.

Venu

[Former Member · Accepted solution]

>

> 1. Should the URL which I need to provide the DB guys looks like this ,
> http://hostname:port/sap/xi/adapter_plain?namespace=http%3A//svg.com/target&interface=mi_test&servic... user&sap-password=password&sap-client=001&sap-language=EN
> 

Yes

 Do i need to register do setting XI for this URL , i mean exposing this URL etc...

No need

> 2.Assume that, the DB guy is sending two fields test1 and test2 , so would the XML look like
> 
> <?xml version="1.0" encoding="UTF-8"?>
> <ns0:mt_test xmlns:ns0="http://svg.com/target">
>    <test1>value1</test1>
>    <test2>value2</test2>
>    <test3>value3</test3>
> </ns0:mt_test>

yes

[Former Member · Accepted solution]

Hi Venu,

URL for HTTP

http://<host>:8000/sap/xi/adapter_plain?namespace=<namespace>&interface=<interface>&service=<sender_...

Just send the credentials then they will set at their GUI, not mandatory to include the credentials in the URL.

Remaining things are fine.

For stored procedures check this link

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Regards

Ramesh

[Former Member]

You need to create sender HTT P adapter and receiver adapter as idoc

You need to provide the HTTP url to DB team for posting the data to PI system along with User and password

DB team has to take care of executign the Stored procedure which post the data in XML format over HTTP

i.e HTTP request should have XML data which needs to be converted to IDOC

HTH

Rajesh