We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dynamic input tool with .indbc file

Pingu
10 - Fireball

Hello!

 

All our database connections work with .indbc files. Now I never have a problem with this, but for this workflow I need to have a dynamic SQL query. 

 

Where normally inputs look like this:

Pingu_0-1683882215036.png

I now want to use a dynamic SQL query using the dynamic input tool. The problem is, is that it does not recognize the .indbc files.

 

Pingu_1-1683882301754.png

 

Pingu_2-1683882335370.png

Any suggestions?

4 REPLIES 4
ArtApa
Alteryx
Alteryx

@Pingu - In-Database connection can be create and stored as .indbc file. You cannot use In-DB with Dynamic Input. Instead you may want to learn and use Dynamic Input In-DB and Dynamic Output In-DB:

 

 - https://help.alteryx.com/20223/designer/connect-db-tool

 - https://help.alteryx.com/20223/designer/dynamic-input-db-tool  

Pingu
10 - Fireball

Thanks very much ArtApa. I managed to do it with the Dynamic Input In-BD tool... turns out I was using the wrong tool, oops.

KellyMiller
5 - Atom

Do you have updated URLs for these links? I am getting 404 errors on them.

Labels
Top Solution Authors