Work around different Schema names in MII Databases

[jurgen_de_jong]

We have a customer with a Development, Acceptance and Production environment (SAP MII 15.4 SP0 Patch 1).

We created some advanced SQL queries on MDO's. (in case we CAN use an MDO query we also do, but sometimes the MDO query functionality doesn't meet our requirements)

However. The technical partner of our customer installed the 3 tier landscape with differente Schema Names for the MII Databases.

• SAPMGDDB
• SAPMGDQB
• SAPMGDPB

This brings up troubles when transporting the Queries from DEV to QAS and from QAS to PRD. Because we need to post process the queries and change the Schema Name for every query.

So I tried to do a couple of things:First I tried to enter a Global Property: Globals.schema

I really don't know if this is going to work

And use this Global Property in the query. But that didn't work

At second I tried to use parameters. and set the Global property in the parameter. Also didn't work:

Does anyone have a clue how we can manage to do a proper Transport of our queries without having to post process every single SQL query after transport?

[agentry_src]

The partner is obviously clueless and your client needs to be made aware of that.

Leaving that aside, what is the vendor of the database and why to you need to have the schema in the query scripting? Also why use MDOs instead of Query Templates directly against the database?