SAP Netweaver MDM 7.1 Installation with MS SQL Database

[Former Member]

Hello Experts,

I have installed MDM 7.1 System on IBM AIX and connected to Oracle database. I have observed whenever we create Repositories MDM Created Table Spaces/ Data files under the one Oracle_SID that is how it should be . Now we had to install MDM on windows machines using with MS SQL DB. I have installed it and connected to MS SQL Server.

The problem is when ever we create or copy new repositories it is creating new database for each repository under MS SQL Server, Although we have created a separate SQL Database and mentioned the same name while initializing the database connection.

Example while connecting MDM For first time to the DB , I have used 4 schema options , Now if i create a new repository it is creating 4 Database instances under MS SQL DB. On oracle it will just create Table Spaces.

Is there any one who worked on MDM Using MS SQL DB. Is this a problem or This is how it works on MS SQL ?

Please help , I really appreciate your help.

Thanks,

Ravi

[Former Member · Accepted solution]

Hi Ravi

Yes, this is how MSSQL does things. An MSSQL database is conceptually equivalent to an Oracle schema. Since each repository created on Oracle creates its own schema (ignoring Z schemas), each repository created on MSSQL also creates its own database.

HTH,

Mark

[Former Member · Accepted solution]

Thanks to Mandeep and Mark ! You made it very clear .

[Former Member]

Hi Ravi,

As per my understanding this is the standard behavior of MS SQL Database. I think this is how it works.

Please Refer, Step III>> of this blog where he states that For each repository, there are two databases XXXX_m000 and XXXX_z000. /people/balas.gorla/blog/2006/09/08/change-tracking-in-mdm

Also refer, Here it says connect to database for repository.

Step 3) Connect to Database u2013 RepositoryName_Z000 and then open table A2i_CM_History http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10cbe10c-0654-2c10-3d8b-ff99dadc4...

Regards,

Mandeep Saini