Originally posted by: carao2020

Hi All,

We are running ITX 9.0.0.2 on Linux Environment and we have some SQL Server 2012 queries defined in MDQ File. The DSNs were defined and corresponding username & passwords were mentioned in odbc file. Additionally, the same username & passwords are mentioned in MDQ File. While moving code to higher level environments, I understood that we need to update the passwords in both ODBC & MDQ files.

Just trying to understand if we can use Resource Registry for the passwords in MDQ File so that we just need to update password in ODBC & Resource config file? Kindly review and suggest.

Thanks.

Originally posted by: PaulBrett

It depends on how you're using the MDQ files.  Using them in one way, means the username and password is compiled into the map.  Other ways, the MDQ is used (and the username/password combo extracted) at runtime.

I recommend using the Resource Registry for multiple environments, just bear the above in mind.

Thank you.

Paul

Follow me on Twitter

Originally posted by: PaulBrett

https://www.ibm.com/support/knowledgecenter/SSVSD8_9.0.0/com.ibm.websphere.dtx.did.doc/concepts/c_dbidref_Processing_MDQ_Files.htm

Thank you.

Paul

Follow me on Twitter

Originally posted by: carao2020

Hi Paul,

Thank you very much. I missed a point that I can use USER & PASSWORD adapter commands along with MDQ file.

Thanks once again.