Rest adapter in PI to get Exchange rates

[viswanahreddy]

My requirement is to get the exchange rates from OANDA RESTfull API and upload it into SAP using PI.

I wanted to use Rest adapter to get the Exchange rates from OANDA(Introduction | OANDA Exchange Rates API)

OANDA web URL ---> SAP PI 7.4--->SAP

Does any one have idea about their licencing(once time purchase or monthly) or need to upgrade the service pack to get Rest adapter.

[justin_santhanam · Accepted solution]

Whose licensing are you asking here? OANDA or SAP?

If you are talking about OANDA then I would say talk to their sales department, when we were interfacing with OANDA for exchange rates I remember it's yearly subscription and you are limited to no.of exchange rates you can seek per year I guess.. We had 3000 I guess.. Better to talk to their sales team..

If you are talking about SAP, then if you are on the correct SP level then REST adapter comes with it. You don't have to pay separate licensing for REST adapter..

Thanks,
Justin.

[viswanahreddy · Accepted solution]

Thanks for the reply

I am talking about Rest adapter.

In system>status i could see there are many components and i am not sure which one i should choose it as PI service pack.

Please suggest whether the service pack provide suits my requirement, if not what is the right one i should go for.

If no updates required then is there any thing else to deploy to get the Rest adapter?

[maheswarareddykonda · Accepted solution]

Are you looking for Rest adapter, if yes, that is available from 7.4SP09 or 7.31SP14

which version yours?

[viswanahreddy · Accepted solution]

There are many components in the below screen shot and i am not sure which one i should choose it as PI service pack.

[maheswarareddykonda · Accepted solution]

choose it what?

are u looking for know the version of PI, if yes, Goto ESR-->rightcleck on SAP BASIS component and click on version.

i think as per that screen, yours SP08

[former_member186851 · Accepted solution]

Hello Anna,

Which SP pack is urs?

Based on that you should select

[viswanahreddy · Accepted solution]

I can see that it is SP8,

[former_member186851 · Accepted solution]

I guess Rest adapter is available from SP09

[viswanahreddy · Accepted solution]

Thanks a lot.

To update SP09 what would be the cost involved in it.

[maheswarareddykonda · Accepted solution]

ok. better go for latest version.

Poll protocol is available in SP11 which may useful in your case

http://scn.sap.com/docs/DOC-64996

also i heard, new SP is releasing this November, so i am strongly suggest get this version , because they were planned many issues related to REST adapter fixes in this SP

[maheswarareddykonda · Accepted solution]

since its just SP upgrade , there is no charges , all you have to check with BASIS team to get the components from marketplace do needful.

[viswanahreddy · Accepted solution]

Thanks a lot for your time

[justin_santhanam · Accepted solution]

Hello,

You should check you exact SP information .. Don't go based on Basis component..

http://host:port/webdynpro/dispatcher/sap.com/com.sap.xi.adminweb/AdminApp

[viswanahreddy · Accepted solution]

Hi Justin

Hope you have worked on OANDA.

If possible could you please post some screen shorts so that it will be very helpful for me to complete the interface.

How do i need to place this URL in Rest adapter.

https://www.oanda.com/rates/api/v1/rates/INR.xml?api_key=xxxxxx&decimal_places=5&date=2015-11-19&fie...

[justin_santhanam · Accepted solution]

Hello,

First delete API_KEY from the link you posted here.. API_KEY is specific to your company(unless its trial version)... I have worked on using AXIS Adapter, but REST adapter should be straight forward.. Let me give you shortly...

Justin.

[viswanahreddy · Accepted solution]

I deleted the key and getting the same error(SOAP Axis sender)

Channel configuration

I am struggling to configure this interface using SOAP Axis...
Could you please share how you have done this integration...

[justin_santhanam · Accepted solution]

Annapureddy,

I think you have mistaken.. I asked you to delete the API_KEY from the forum thread here.. Not from your configuration.. Did you deploy all the AXIS files? Also did you deploy the SSL Certificate from OANDA to the trusted keystore in PI?

Thank you,

Justin.

[viswanahreddy · Accepted solution]

I am sorry.

I am not able to edit that comment...can you suggest me pls.

[former_member186851]

which service pack you have?