This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
@AhmedAlZabidi I hope you were able to fix the workflow freezing issue. I am writing this reply, just to answer folks who might have faced a similar issue-
There can be a couple of reasons why your workflow freezes while modifying the input tool which uses an ODBC or any other database API.
1) You might be using a VPN (like Cisco Anyconnect) to access the database which might be residing on a client network. You will have to work with your IT guys to make sure the tunneling performance is adequate.
2) The most likely reason is the auto-configure option enabled by default on Alteryx Designer. To disable this go to Options>User Settings>Edit User Settings>Advanced and click on the option "Disable Auto Configure" Doing this will remove the functionality of fields being populated on a newly added tool. Just hit F5 to manually configure the tools.
Note: Based on my experience, using Alteryx Designer residing in a remote desktop gives better performance with respect to I/O connections compared to VPNs.