community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Error when saving workflow with In-DB tools to Alteryx Gallery

Alteryx Partner

@MarqueeCrew - Yes. I have three other flows that are scheduled in the gallery and run the exact same query. The only difference is: (1) They are referencing different tables (2) They are normal input tools.

Alteryx Partner

@MarqueeCrew - Posting a screenshot of a successful run on the flow locally along with the query that I'm running in the Connect In-DB tool.

Local_Successful_Run_of_ERCOTRTLMP.png

Select * From database.schema.table_name
Alteryx Partner

After a call with @KevinP I was able to resolve the second issue by creating an In-DB Connection with a SQL Server Ole DB driver, replacing the SQL Server ODBC driver. In order to get this driver to work I had to make these few configurations:

  1. Integrated Security: Open this prompt and then close it (this is effectively an "acknowledgment" of this setting in Alteryx)
  2. Persist Security: Open this prompt and set it to "True"

 

Kevin also offered a solution that replaced the need for the In-DB tools altogether. He suggested using the regular input data tool and writing the following optimized query which returns the last RecordID:

 

Select Top 1 RecordID From Database Order By RecordID Desc

This solution, in particular, was a great reminder to leverage SQL and experiment with queries if the tools begin to pile up. Thanks for your assistance, Kevin!

Highlighted
Alteryx
Alteryx

@dallen Happy to be of assistance and I am glad to hear the solutions provided are working well for you. Also thank you for updating the post with the solutions as it may help other users in the future.

Labels