I am using Automation designer to run procedures and export Excel files but I have to enter 10 times password when exporting 10 excel files. How to save password in Automation designer or just enter 1 time password for running the procedure and exporting all Excel files. THZ!
You can save the password in the login window. Check the "Save Passwords" checkbox at the bottom to save it for all connections, or if you only want to save it for some of them, you can do that in the grid.
If you don't want to save any passwords, then make the connection first from the login window, then run the exports.