Skip to Content

Installing SAP BusinessObjects BI Platform with an External MySQL RDS

May 09, 2017 at 11:44 AM


avatar image
Former Member


I have a requirement where I have to install SAP BusinessObjects with an Externalized MySQL RDS. I did try to look through the forums for information on this but couldn't find any info. I would greatly appreciate if folks who have tried this can point to the steps that I should take to externalize the MySQL metastore to point to MySQL RDS


Sid Ramesh

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Denis Konovalov
May 09, 2017 at 11:47 AM

It is simple and in the install guide :

1. your external MySQL DB has to be supported by the BOE version you're installing
2. You install MySQL drivers on the server where the BOE goes
3. You install BOE selecting the DB you want and if drivers are correct and DB login info is good - you're done.

What do you mean by "externalize the MySQL metastore to point to MySQL RDS" ??

Do you have existing CMS DB in one mySQL and need to move it to another ?

10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 25, 2017 at 08:48 PM

Thank you, Denis Konovalov . I did not know that MySQL drivers had to be installed on the SAP Business Objects server and I have to try that now. The version I am trying to install is SAP Business Objects 4.2 and that does support MySQL.

To clarify, by use of the word "externalizing" I meant using an RDS cloud database as opposed to a local database. And I do not have any existing CMS database that I have to move, this is a fresh install and I am trying to install the Business Objects application with the cloud MySQL database.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

to connect to any DB, you need to have drivers for it on machine from which you will be connecting, so you need to have correct MySQL drivers on BOE server machine to connect to your cloud MySQL DB.

Those drivers need to be configured and connection working, prior to install of BOE.
You also need to make sure that the version of MySQL you're using is supported by 4.2.