Change connection query of in-db connection for o-auth token based authentication

[diksha1107]

URGENT HELP!

Hi all,

I want to create an analytical app which takes the input of a token and changes the connection query. I tried using dynamic input in-db tool but that is accepting only connection name and db query. 

Why token?

I'm trying to establish o-auth 2 token based authentication of denodo uisng alteryx.

Please assist if this is possible or suggest an alternative.

Thanks in advance.

[atcodedog05]

Hi @diksha1107 

I had faced a similar issue and later was forced to use input tool. You can place the input tool in a batch macro and you can change the connection string through control parameter.

[diksha1107]

Hi @atcodedog05 

Can we make dsn less connection using input tool?

[atcodedog05]

Hi @diksha1107 

If its possible in In-Db tools then it should be possible in Input tool too.