Link between MDM repository & SQL database

[Former Member]

Hi

Problem - once i create a MDM repository & rename the repository, SQL database still refers the repository with the old name. How to identify which repository corresponds to which database.

Arvind

[Former Member · Accepted solution]

Hi Arvind

If you look in your underlying database (SQL Server, Oracle, DB2) you'll find an "A2i_xCat_DBs" database / schema. In here you'll find a table called "A2I_CATALOGS". You'll find the link between repositories and database / schema names in this table.

HTH

Mark

[Former Member · Accepted solution]

Thanks alot Mark

Arvind