cancel
Showing results for 
Search instead for 
Did you mean: 

Installing SAP BusinessObjects BI Platform with an External MySQL RDS

Former Member
0 Kudos

Hello,

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

Regards,

Sid Ramesh

Accepted Solutions (0)

Answers (2)

Answers (2)

denis_konovalov
Active Contributor

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 ?

Former Member
0 Kudos

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.

denis_konovalov
Active Contributor
0 Kudos

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.