Hello all,
As of today, we use the good old alias in-memory to connect to our datasources in in-memory. We have several environments so we use constants in order to change the name of the in-memory alias during execution.
To illustrate :
![simonaubert_bd_0-1701895804110.png simonaubert_bd_0-1701895804110.png](https://community.alteryx.com/t5/image/serverpage/image-id/332791iC11E07A3FD03AB86/image-size/medium?v=v2&px=400)
Depending of the environment, the constant « v_gp_contexte » will take different values :
- GP_DS08_SIDATA for la dev.
- GP_EE_SIDATA for prod.
Sounds nice, right? But now, we would like to use DCM and the nightmare begins :
We can't manually change the name and set the question :
![simonaubert_bd_2-1701895988262.png simonaubert_bd_2-1701895988262.png](https://community.alteryx.com/t5/image/serverpage/image-id/332792i8711F9F179BA026E/image-size/medium?v=v2&px=400)
if we look at the xml of the workflow, we only find an id so editing it is useless :
![simonaubert_bd_3-1701895988262.png simonaubert_bd_3-1701895988262.png](https://community.alteryx.com/t5/image/serverpage/image-id/332793i92461003C11D5260/image-size/medium?v=v2&px=400)
(for informationDCM connections are stored in some sqlite db in C:\Users\{yourname}\AppData\Local\Alteryx
So, I would like to use the DCM inside the in-memory alias (the in-memory alias is stored and can be edited), just like for in-db connection alias.
Best regards,
Simon