How to get exchange rates from European Central Bank into ByD.

[abelousov]

Hello All

The problem is how to get exchange rates from https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml into SAP Business ByDesign daily. It can be via some development in Cloud Applications Studio. Is there any solution?

[former_member39718]

REACHOUT to srinivasan.rajagopalan@erplogic.com

om

[former_member39718]

Hi Aleksi,

It can be done via developments need any support contact us at info @erplogic.com

[former_member606838]

Hi Aleksei,

Would you share more information about the mashup as I need a similar thing but using Fixer.io

Thanks!

[solene_roques]

Hello Mousa,

Did you manage to get any further with this issue ?

I am also looking to integrate exchange rates without middleware and it is not really clear on what steps has to be followed in studio. Thanks

[former_member606838]

Hi solene_roques

Unfortunately not. I wrote a complete middleware in Azure using .NET to run in a daily basis. My colleage though is in an advance stage in developing such scheme so I am still waiting for him to be able later to write it in Cloud Applications studio.

[solene_roques]

Hi Mousa,

I finally managed to do it without middleware. Your developper can find valuable information here (that is what unlock me) : https://answers.sap.com/questions/748345/call-the-web-service-manageexchangeratein-from-the.html?chi...

Good luck 🙂

[abelousov]

Hello Jimmy,

Yes, we have found the solution, we managed to use a mashup to retrieve the data from the site.

Best regards,

Aleksei Belousov

[Jimmy1]

Hi Aleksei,

How did you solve your query with the exchange rates?

Kind Regards

Jimmy

[abelousov]

Hello Martin,

Thank you for your info.

openexchangerates.com looks interesting, not free of charge, though (as far as I understood).

Many thanks, anyway.

Best wishes,

Aleksei

.

[Former Member]

Dear Aleksei,

we have already implemented the Exchange Rates Sync between SAP Business ByDesign and Open Exchange Rates. What works quite well, is the integration between openexchangerates.com and SAP Business ByDesign. What we did not try yet, is the integration with ecb.europa.eu Anyway, we are happy to share our experience with you.

Feel free to send me a PM in case.

Kind regards Martin

[abelousov]

Hello Harshal,

We are really stuck on this task. What I found out :

Template 'Web service' only gives possibility to read or create entries of standard BO 'ExchangeRate' in ByD, that is, gives an access (R/W) to the BO (actually a simple table) from external systems (in this case BO 'ExchangeRate' looks as a Web Service on the internet and the external system itself has to initiate read / create operations.

Our task is such that ByD (rather a scheduled process in ByD) itself must ask the external service for the data. To get data from external source (in our case https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml), we should use template 'External Web Service Integration' together with 'Communication Scenario'.

(app) SoapUI can easily work with the eurofxref as with a Web Service - SoapUI sends empty (or whatever) request and gets the xml-content as a response.

I would like ByD to work in the same manner. It would suit me if I could get all the content as a string into a simple custom BO having the only element (string type) for this content. But I suspect ByD will try to parse the content according to some scheme (according to wsdl? custom BO structure?). Unfortunately I have not found any proper wsdl-file for this xml-content. And I do not know what structure of my custom BO should be to receive and arrange this content properly.

Now I got an error 'SoapFaultCode:2 Wrong SOAP Version' during Test Service Operations of the external web service

Are there any ideas?

Thank you.

Best wishes,

Aleksei

[HarshalVakil]

Hi Aleksei,

Within Business ByDesign system, We have provided the web service : ManageExchangeRateIn to import the exchange rate from the external source.

Go to Application and user management

Service explorer view

Search for the service interface : ManageExchangeRateIn

Select the row and click on Link for the documentation.

Can you please check this. Let me know if you need further details.'

Regards,

Harshal

[abelousov]

Thanks, Harshal

I checked the web service in my service explorer. Where do I have to input the URL into ManageExchangeRateIn for it to work?

[HarshalVakil]

Hi,

Basically, you will have to

1) Set up communication system

2) Set up communication arrangement using the communication system and assign the scenario (ManageExchangeRateIn)

there could be option to it via cloud application studio as described in the link. (I am not familiar with this process, but the link could act as reference for you.)

https://archive.sap.com/discussions/thread/3589616

Regards,

Harshal

[solene_roques]

Dear Harshal,

Could you provide more details about how to do so without a middleware pushing data into ByD please ?

As mentioned in the thread " you can build the integration as a ByDesign customization (though in this case it's a bit strange as it ends up sending web service requests to itself...)". Authors of this thread are all former members : https://answers.sap.com/questions/11068401/how-to-update-exchage-rate-automatically-in-sap-bu.html

Thanks