Originally posted by: SystemAdmin

All,

I've designed in my test system a map that references an Oracle database as an input card, by using an .mdq file from the database interface designer.

Now that this works, I need to set things up so that the same compiled map can run in the test, QA and PRODUCTION systems, each referencing a different database.

From what I understand, the resource registry can help me get around this, but I don't see how to integrate it. I cannot put alias values into the input card settings.

Does anybody know how to work this out?

Thanks in advance,
Matt
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: TarunB

"I cannot put alias values into the input card settings" - This is basic functionality, certainly if you are using the Integration Flow Designer. If you're driving maps through a command server execution then you would just override the map settings as part of the map call.

If you are using the IDF then set your map up as normal and override the input card setting with the Resource value name, for example %Database_Connection_123%, and create this name in your Resource Registry with a value like -MDQ MyDB.mdq -QUERY MyQuery

You'd probably have a different MDQ per environment (my preference), or a different database for each environment within the one MDQ file.

Can you confirm your set-up and exactly what the problem is?
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange