Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

There is no option to clear the In-DB connection string history

gtorres8
Alteryx Alumni (Retired)
Created

Environment Details


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.

idea Skyscrapers
 

  • Alteryx Designer
    • 2018.4 and higher
    • User Settings options
  • Input/Output Data Tool
  • In-DB Tool
    • Connection History


Cause


New GUI changes to Alteryx no longer shows clear history option by default.



Resolution


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.

idea Skyscrapers
 

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.

idea Skyscrapers
 

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.

 

Additional Resources

 

Comments
ssjl
8 - Asteroid

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?

 

gtorres8
Alteryx Alumni (Retired)

Hi @ssjl, can you send me a screenshot of what you are trying to clear?

EC417
6 - Meteoroid

@gtorres8,  When using the Connect In-DB  under "Open File Connection..."  ... 

 

 

In-DB Strings.png

Ember9659
5 - Atom

Hi @gtorres8 / @ec417,

was curious if either of you found a solution for clearing In DB connection history

EC417
6 - Meteoroid

Nope... still waiting. 

gtorres8
Alteryx Alumni (Retired)

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.

 

gtorres8_0-1621015843650.png

 

Creating new indbc files in Alteryx Designer will populate the registry starting with InDBFileFile1.

Ember9659
5 - Atom

@Gtorres8 Thank you for the follow up!

EC417
6 - Meteoroid

Registry fix from above confirmed... thank you!  

ssjl
8 - Asteroid