05-05-2020 07:36 AM - edited 07-15-2021 12:30 PM
In the Manage In-DB Connections window, there are no options to clear the connection string history when clicking the Connection String drop-down list.
New GUI changes to Alteryx no longer shows clear history option by default.
Switch to classic GUI view for the menu options in the Input and Output Data tool.
1. Go to Options > User Settings > Edit User Settings.
2. On the new window, check the box "Use classic mode for the Input/Output tool menu options" and then click Save.
3. On a blank workflow canvas, place an Input Data tool.
4. Click the drop-down arrow to Connect a File or Database > Other Databases > Clear Connection History.
When using the Connect In-DB tool, the connect string history will be cleared. Feel free to leave the User settings to classic view or switch it back when done.
Thank you for this but, unfortunately, it does not answer the question which is specifically about the In-DB tools. Would you kindly update the article to include how to remove In-DB connection string history?
Hi @ssjl, can you send me a screenshot of what you are trying to clear?
@gtorres8, When using the Connect In-DB under "Open File Connection..." ...
Hi @gtorres8 / @ec417,
was curious if either of you found a solution for clearing In DB connection history
Nope... still waiting.
Hi @EC417 / @Ember9659 / @ssjl ,
An option to clear the In-DB File History is not available in the Designer's GUI. If this feature is required, it's recommended to open an Idea on the Alteryx Community to submit an enhancement request.
There is a way to clear this via the Windows Registry, but please review the disclaimer before attempting that.
Disclaimer: You need Administrator permissions to perform these steps. Because the registry is such a critical component of Windows, it's always recommended to back up the registry before making any changes. Do not perform these steps if you are not comfortable using the registry. Alteryx is not responsible for misuse or mishandling the Windows Registry or responsible for any recovery.
To clear the In-DB File history:
1. In the Windows Registry, navigate to:
Computer\HKEY_CURRENT_USER\Software\SRC\SrcLibW\FolderHistory
2. Locate the entries labeled InDBFileFile{number} (1 - 5) and delete them.
Creating new indbc files in Alteryx Designer will populate the registry starting with InDBFileFile1.
@Gtorres8 Thank you for the follow up!
Registry fix from above confirmed... thank you!
Idea posted here: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Enable-clearing-In-DB-connection-history/idi...
Thanks!!!!