CASD DB configuration trouble to use AWS hosted RDS database

[Mohamad Sukry Ilias]

Hi All,

I need advise on below:

Customer try to some configuration but:

1. Default database for mdbadmin SQL Login should be set to mdb (DB team followed instruction on https://knowledge.broadcom.com/external/article/228326/mdb-database-connection-problem-while-sq.html). However, this feature is not supported in RDS for multi-AZ deployments

2. Can the DB data be exported in a DB server agnostic format so we could restore it to a different DB like Oracle etc?

Can anyone advise on this matters?

Thank you

[Sebastian Nagy]

Hi Mohamad,

I'm trying to understand what backend you are trying to use MS SQL or Oracle - in #1 you point to a document about MSSQL while in #2 you mention Oracle.

Most importantly you have to confirm that your DBMS and configuration is really certified, before proceeding further.

You would need to rely on the available configuration options in the installer. For MSSQL you can change the "Database Name" to whatever you want, you don't have to use mdb. 'mdbadmin' user is a requirement, and that would be automatically created by the install script if the admin user, provided during install, has permission to create new users. For Oracle you have to provide the "Oracle Service Name" already created.

Yes, we have had customers install the MDB on a server then move to another, but the DBAs have to replicate the same configuration on the new database as well. CASM supports only MS SQL and Oracle DBMSs, and we don't provide told to move from one DBMS to another.

I hope understood your questions correctly..

Sebastian