How do I change the Source names in MetaMatrix?
Issue
We are using a database called Support in SQL and imported the metadata. We now have to setup additional environments and did this by adding a number to the original database, however this causes an error when trying to query the database since it is expecting Support but is now called Support_1.
So there is no way that you can set MMX to ignore the database name and only look at the layout of the database when creating a query.
It looks like it does a prefix of the database name in the query i.e.
Select * from Support.dbo.ClientDetail
We would like it to ignore the database name "Support" and just be
Select * from dbo.ClientDetail
Environment
- MetaMatrix 5.5.3
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
