Posted 3 August 2017, 3:53 pm ESTI've noticed that the password and user name are plain text in the file created from pivotview.write. Would you consider encrypting this? What I'm going to have to do is save the xml file, then encrypt the connection string, then when I open the file I'll have to decrypt the conenction string and then open the file.
Also, If I create a visualization and save it. If my user name and/or password changes I won't be able to open this visulization again unless my program edits the connection string in the xml file. I understand with the number of data sources this tool connects to it might not be possible to prompt for a user name and password, but if it is possible could this be implemented. I don't think this is an issue with local data source (maybe Excel if it is password protected).
Finally, if I want to share a visualization with someone. They can connect to it, but unless I change the connection string for this user they will be connecting as my user with my password.
I'm working around all of this, but I would think these are some things that you might look at enhancing in a future releases.