I am trying to figure out how to embed the data to the DXP file when the user downloads the DXP file by going to the Web Player and presses File -> Download as DXP File option.
Currently, when the user downloads the file locally and opens it, they get prompted for the "Data Connection" credentials:
I am assuming that is because our data is accessed via database and it is not embedded into the DXP file itself. I have 2 questions:
For the first question, click Edit then Data Table Properties. On the General tab, select "Embedded in analysis" under Store data.
I don't know the answer to your second question.
What I normally do is save a version of the DXP locally that has all the correct connections. I then manually save copy as a library item when the data needs to be updated. When you do this, it gives you the option to embed the data in the library item version of the DXP. It isn't the best solution if the data needs to be updated frequently.