How to connect from Business Objects to Amazon RDS database

[Former Member]

Hi All,

We need to connect from an in-house hosted SAP Business Objects XI 4.1 to an Amazon RDS hosted Oracle database and retrieve data for our reports.

Have you ever done that?

What are the potential challenges or pitfalls?

Could you please help with the required steps to build the connection?

Thanks,

Tibor

[Former Member · Accepted solution]

I think by using ODBC you can easily connect to Oracle based database.

Check following link for same:

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_data_acs_en.pdf

https://www.youtube.com/watch?v=EaRqwrZ3Zpw

I hope this will help.

Thanks,
Swapnil