Skip to Content
avatar image
Former Member

Installing SAP BusinessObjects BI Platform with an External MySQL RDS

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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 ?

    Add comment
    10|10000 characters needed 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.

    Add comment
    10|10000 characters needed 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.