Replacing DCM Connections
When you are swapping DCM connections (for example, switching to a different person’s credentials), if you simply edit the DCM connection, you lose Custom SQL Query that may have been used. This page describes workarounds that allow you to swap your DCM connections, without having to save/store the queries.
Background
When you are swapping DCM connections (for example, switching to a different person’s credentials), if you simply edit the DCM connection, the Custom SQL Query screen is automatically cleared out:
On this page, we describe how you can swap out your DCM connections without losing the Custom SQL query that was stored there.
The methods described here only work when swapping DCM for DCM.
If you are transitioning from a Server Gallery connection to a DCM connection, we recommend you create a completely new Input tool with the DCM connection so that you can copy the old query and then re-connect your tools accordingly.
There are two possible approaches to making this swap, here listed in order of complexity:
recommended When you setup the New DCM Connection you’re migrating connections to, it contains a Connection ID. You can paste and replace this Connection ID over the old Connection ID that you’re swapping out. You can do using the Find and Replace functionality in Designer, specifically by: CTRL + F, find the old Connection ID, and then replace with the Connection ID of the new DCM connection. This will apply the connection update to the tools utilizing the connection and preserve the query.
You can wrap the input tool containing the DCM connection into a Macro and apply a DCM update action (the custom SQL query will remain). It’s only when editing the input tool that the query is cleared. The hack to not have to rewrite the query is to right-click -> copy the query field in the input tool, then update the DCM connection, then paste the query when the window pops up to do so.