Hi,
I have Alteryx server 2021.1 and i want to update the MongoDB user table.
I want to change the username in MongoDB table.
Could you please tell me the steps. How do i update the same using MongoDB input tool on server.
Thank you!
Hi @alt_tush
It is not recommended that users make direct edits to the embedded MongoDB environment, especially if you're not absolutely certain that the change being made will not have any negative impact.
Because of the risk of providing you (or being misinterpreted) incorrect instruction, I'd suggest reaching out to support@alteryx.com directly so that they can assist you with the change you're trying to make to ensure that proper precautions are done to reverse changes made should your server become unstable.
Hi jrgo,
Thank you so much for your assistance.
Could you please help me with steps to see the list of users in mogoDB using alteryx.
Thanks again
PROCEED AT YOUR OWN RISK AND I TAKE NO RESPONSIBILITY IF YOUR ENVIRONMENT BECOMES UNSTABLE
The link below is a good How-To article with connecting to MongoDB using Robo 3T which is free (not Studio 3T).
https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/How-to-Login-to-Robo-3T/ta-p/601025
You can also use the MongoDB Input tool (Connectors)
Note that the instructions are assuming that you are remoted (RDP) into your server. You could connect to Mongo remotely, but it does require that the port MongoDB communicates on (default 27018) be open to inbound/outbound traffic. Take caution though as opening this port will present a new security risk since MongoDB does not need to communicate outside of the machine it's hosted in (except in multi-worker node environments).
Yes its totally my responsibility 🙂
Thank you so much for your help 🙂
Hello,
Do you succeed to update mongdb user table?
I want to manually create 1 user directly to the DB and wonder if it's possible and how?
If I need to only insert 1 new line in user table or if I have to insert/update data into other tables...
Regards
