Alteryx using DCM connection can't view stored procedures in pre sql configuration

Question

Hello everyone, recently upgraded to the version 2024.1 and as a team decided to change database connections to DCM. Ran into an issue where the pre sql wasnt running the stored procedures. First Screenshot shows the configuration of the main query where the stored procedures are appearing and do run

Second screenshot shows the pre sql configuration

Has anyone ran into this issue before?

Note: Using a regular string connection with odbc works just fine. Only when using the DCM is when i'm having issues

apathetichell · Answer

@Heriberto_Prieto :

1) confirm the DCM user and the standard user are the same.

2) if problem persists:

a) contact your Alteryx rep and open a support ticket ---> this is on the internal implementation side of DCM and we can't help.

b) swap from DCM back to ODBC.

aatalai · Answer

@Heriberto_Prieto I'm not too sure about stored procedures, but possibly try looking at the dynamic input tool and updating the stored procedure that way?