Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How can I use constants in the Connection Name with AMP?

Magne
7 - Meteor

Hi, Using Constant in Connection Name for In-DB Input tool does not work with AMP.

 

I have created a few different ODBC connections that I use directly in the Input tool, and have created the constant User.GFT that I set to "Dev", "Test", and "Prod" depending of the environment of the workflow. 

 

Without AMP the connection work fine and uses the correct ODBC connection according to the constant value. When using AMP this does not work. If I replace %User.GFT% with Dev directly in the Connection Name, it works with AMP, but then the whole point of constant is gone, and there is also ridiculously much more work each time I switch between the environments. How can I get this work with AMP, and not increasing the work when switching environments?

 

Magne_0-1659695923705.png

 

2 REPLIES 2
TonyaS
Alteryx
Alteryx

@Magne 

Thank you for using AMP Engine and for bringing this to our attention. 

 

I ran this by our Engineers and for now a workaround seems to be to convert the workflow type to a Macro. This appears to fix the issue, but I will also add a defect to our backlog to ensure that constants with In-DB tool connections work in regular workflows with AMP by falling back to the original Engine for this functionality. In-DB tools are not AMP enabled, but that should not prevent the functionality from working in an AMP workflow. 

TonyaS_0-1659719177575.png

 

I also wanted to share the various AMP related resources that we have available: 

 

•Help Documentation

https://help.alteryx.com/current/designer/alteryx-amp-engine

https://help.alteryx.com/current/designer/Alteryx-Engine-and-AMP-Main-Differences

https://help.alteryx.com/current/designer/AMP-Memory-Use

https://help.alteryx.com/current/designer/tool-use-amp

https://help.alteryx.com/20221/designer/engine-compatibility-mode

https://help.alteryx.com/20221/designer/performance-profiling-amp-engine

https://help.alteryx.com/20221/server/amp-engine-best-practices

 

•AMP Engine Webinar (32 minutes)

https://community.alteryx.com/t5/Analytics/AMP-Engine-Discover-the-Untapped-Performance-of-Your-Anal...

 

•AlterEverything Podcast

https://community.alteryx.com/t5/Alter-Everything-Podcast/66-The-Alteryx-AMP-Engine-Explained/ba-p/5...

 

•Community Blog posts

https://community.alteryx.com/t5/Analytics/Accelerate-Your-Analytic-Processes-with-the-New-AMP-Engin...

https://community.alteryx.com/t5/Engine-Works/AMPlify-your-Workflows/ba-p/617590

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Best-practice-with-the-new-Multi-threa...

https://community.alteryx.com/t5/Engine-Works/AMP-Engine-Technical-Deep-Dive-Part-1-Why-AMP/ba-p/570...  

https://community.alteryx.com/t5/Engine-Works/AMP-Engine-Technical-Deep-Dive-Part-2-Key-concepts-of-...  

Tonya Smith
Sr. Technical Product Manager, Alteryx Engines
Magne
7 - Meteor

@TonyaS 

Thank you for your reply.

 

I will then conclude that the AMP engine is not mature enough to be used for our cases. I will try the AMP Engine again later when the constant issue is fixed, and I'm looking forward to speeding up the processing of our workflows.  

Labels