What is the feasibility of getting the data fetch from 3rd party system, storing it and converting it to the required SAP format.

[former_member742586]

Hi Folks,

My client has an requirement.

FXML and FXCSV services provide daily average currency exchange information in XML or CSV formats and are easy to use and setup as an automatic procedure to obtain the rates directly from our exchange servers for your SAP/ERP systems. Once you subscribe to one of the services, you will be able to access the service via the Internet using the HTTP protocol to send requests and receive responses in XML or CSV formats that contain a list of currencies, dates and the appropriate exchange rates. With FXML or FXCSV, you can obtain one-to-one, one-to-many and many-to-many exchange rate tables of over 164 currencies for any date since 1990 for $2,400/year.

Unfortunately we do not support the process of integrating with third party software however you are welcome to test FXML and/or FXCSV to help with the integration process. To start testing either of the services, you may use the following test client identification: 'oandatest' (without the quotes).

So i have followed some sample HTTP requests.  With this client ID, we will be able to  send HTTP requests and receive responses, however, the exchange rates returned will be for one day in the history only.

Request to check the feasibility of getting the data fetch from 3rd party system, storing it and converting it to the required SAP format.

what is the best approach to achieve this interface?

is this Soap to HTTP?

Soap to RFC?

[Bhargavakrishna]

Hi Kalyan,

We can get the data from third-party and can send it to the SAP system.

You can go for SOAP or HTTP it depends on the third-party and how feasible they are for integration.

To get a XML file from the web-service you can use HTTP get option.

The exchange rates returned will be for one day in the history only.

Where it should store?

Please refer the below links

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/01/05/michals-pi-tips-exchange-rates-fr...

http://scn.sap.com/people/michal.krawczyk2/blog/2010/01/22/pixi-how-to-get-an-xml-file-from-a-web-pa...

http://wiki.scn.sap.com/wiki/display/XI/SOAP+AXIS

You can go for HTTP to Proxy / RFC

Regards

Bhargava krishna

[former_member742586]

Thanks for the reply Bhargava krishna, we are maintaing URL in sm59 ,cretaing HTTP destination..

So best approach for this scenario is HTTP to Proxy correct.

But i have a problem here,we are using 7.31 version,Proxy side we need to use XI adapter but in 7.31 version i cannot find XI adapter configured in Communication channel.

If we go RFC it will work???

[Bhargavakrishna]

Hi Kalyan,

please refer the below link to use soap with XI protocol..

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70066f78-7794-2c10-2e8c-cb967cef4...

Regards

Bhargava krishna

[ambrish_mishra]

Hi Kalyan,

Are you using PI for this requirement ?

Ambrish

[former_member742586]

Actually my client has asked to check with PI possible or not?

FXML service is accessed using a POST1 to a particular URL with a single request key named

“fxmlrequest”.

So i am in a confusion that PI will support this requirement or not?

Help needed

Thanks,

Kalyan.