I am extracting data using DB connect.
The source system releases view and we connect to the source system by DB connect and create a datasource on the view in Dev BI system.
then we transport datasource to quality and production BI system.
In Dev and Production BI system we have DB user for the source system as say ' ABC'.
but in quality we have DB user for that source system as say 'ABCDE'.
Every time when I transport the datasource to quality system I have to change the Db user for the datasource from 'ABC to 'ABCDE'. (changing DB user for datasource in 'extraction' tab of the datasource in quality BI system)
What can be done to avoid this manual change of DB user in quality BI system.?