Database for MDM 7.1

[Former Member]

Hi,

We are planning to install MDM in our landscape. Kindly let me know whether we need a seperate licensed database for MDM or will the oracle database comes bundled along with the MDM software.

Your inputs will be more helpful.

Regards,

Varadhu

[Former Member]

Hi,

After the thoruogh analysis, I came to know that we can use any database (even existing database) for the MDM server provided you have the access to the system user of that database.

Thanks for you replies.

Regards,

Varadhu

[Former Member]

Hi,

Thanks for the response.

Can you please provide me the steps involved in configuring MDM 7.1 with database ?

Regards,

Varadhu

[Former Member]

Hi Varadhu,

Refer to the MDM Installation guide from service.sap.com/swdc

Release & Upgrade Info > Installation & Upgrade Guides > SAP Netweaver > SAP Netweaver MDM > SAP Netweaver MDM 7.1 > Intallation Guide.

For Oracle DB, below are some steps from the guide:

Install Oracle and Create a Database Instance

􀁸 You need to install both DBMS and client of Oracle if you plan to host Oracle on the same machine

as MDS. If the DBMS and MDM reside on different hosts, the MDS host requires the installation of

the Oracle client.

􀁸 If the MDS and the DBMS are on the same machine, use the Net Configuration Assistant to define a

Listener address and local Service Name that uses the IPC protocol rather than TCP. This affects

the listener.ora and tsname.ora files, which can also be edited manually. This increases the

repository unarchive performance.

􀁸 MDM does not support Oracle client versions other than the DBMS to which it connects. For

example, you can use only an Oracle 10.2 client for an Oracle 10.2 database.

􀁸 Oracleu2019s performance increases when separate spindles (hard disks) are used for the main data

and indices. Rollback segments (for transactions and logging) are set at database instance creation

time and can represent an opportunity to use three separate spindles. The location of the main and

index files can be set before repository creation, unarchiving, or duplication via the Console.

􀁸 Make sure that you reboot the machine after a new installation of Oracle on a Windows platform so

that the MDM service can inherit the Oracle path from the system.

􀁸 The Cursor Sharing parameter is set on a session basis to be exact. This provides a small

performance improvement for certain operations between MDS and the Oracle Server. For earlier

versions of MDM, you may have the option of globally turning this parameter on for the entire Oracle

instance with the following command:

ALTER SYSTEM SET cursor_sharing='EXACT' scope=BOTH

Hope this helps!!

Cheers,

Arafat

[Former Member]

Hi Varadhu,

Database does not come with the MDM Installation, you need to get a DBMS separately. Be it Oracle or MS SQL.

Regards,

Arafat

[Former Member]

Hi Varadhu,

MDM doesnt come with the database. You need to install the database seperately.

Hope it helps.

Thanks,

Minaz