Create a New Embedded MongoDB Database
Embedded MongoDB is the most popular and widely used database option when installing Alteryx Server or Desktop Automation. The Mongo instance is usually created when Alteryx is first installed/configured. This article provides instructions on how to create a new instance without reinstalling Alteryx. Why would you want to install a new instance?
- Perhaps you have decided to change authentication methods from Windows Auth to SAML. Since Alteryx does not support changing the authentication method on an existing MongoDB database, the following steps should be taken:
- Troubleshooting purposes, for example, a feature is not working as expected following an upgrade.
- Corrupted DB instance and no prior backups are available
Note: As always, it's recommended you get in touch with Alteryx Support (Support(https://support.alteryx.com) if you are unsure or feel uncomfortable making this change. Creating a new mongo instance will effectively start Alteryx from scratch. Existing data (such as users, workflows, and collections) will not be available in this instance.
- Alteryx Server or Alteryx with Desktop Automation
- All
- Open Alteryx System settings on the Server
- Navigate to Controller>Persistence
- Under Data Folder> Click on Browse and navigate to the Persistence folder. In this example, the persistence folder is C:\ProgramData\Alteryx\Service\Persistence.
- Create a new folder under persistence and name it something Unique. i.e. MongoDB_New, Then click OK
- Check and confirm you have selected the new persistence folder to avoid overwriting the existing database.
- Then click Next until you reach the end, followed by Finish
Important: Once you commit the changes, the Alteryx service will automatically restart.
If there's a need to switch back to your existing database, this can be done by opening Alteryx system settings, Navigating to controller>persistence, and changing the Data folder to point to the existing MongoDB folder/instance. For the above example it's "MongoDB."