[URGENT]Pulling excel file from Shared location
I have a certain data value coming from Excel.
Thing is the excel needs to be updated by users on a daily basis. Also spotfire needs to be connected live (linked to data source) so that it can pull data from it and reflect the changes.
1. Can I upload the file to Spotfire Library.
2. Is it possible for Spotfire to access a shared folder on a different machine.
I want to put it on the table that authentication on both Spotfire Desktop and the shared drive will happen on basis of SSO.
1. Can I upload the file to Spotfire Library?
- Answer: No, not if the file will be updated regularly. Technically you could 'convert' the excel data to an sbdf format via Spotfire and then store it statically in the Library, but that would not be ideal... instead see answer 2.
2. Is it possible for Spotfire to access a shared folder on a different machine?
- First, the data must be added to the report via a UNC path accessible from the Web Player. For example: \\myserver\myfolder\mydata.xlsx
- Second, you must update the Web Player service config file to allow that file path. There are 2 methods. You can modify the existing AllowedFilePaths node with your path:
<setting name="AllowedFilePaths" serializeAs="Xml"> <value> <ArrayOfString> <string>\\myserver\myfolder\</string> </ArrayOfString> </value> </setting>
or by inserting the following:
<Spotfire.Dxp.Data.Properties.Settings> ... <setting name="AllowAllFilePaths" serializeAs="String"> <value>True</value> </setting> </Spotfire.Dxp.Data.Properties.Settings>
Third, ensure you are using Kerberos with Delegation as other SSO methods will either not work if the excel file is on a separate machine than the Web Player:
If the network share is shared from the server running the Web player:
In this scenario you can use any of the 4 SSO methods and simply grant read access to the network share for the end users just as you would grant access to any other network share.
If the network share is NOT shared from the server running the Web player:
In this scenario it is only possible to user the SSO method Kerberos with delegation as you would otherwise run into the so called "Double-hop" issue.
Once the Web player is setup to use Kerberos with delegations you then grant read permissions to the network share for the end users just as you would grant access to any other network share.
Sounds good. And remember that even if you go this route where you " make a folder on the same server machine", it should always be accessed via the UNC path like \\myWPserver\myFolder\myFile.xlsx. So when creating an analysis file in the installed client, it should be added with that exact path (so that the path which is valid everywhere is used).
I have asked the Infra team to check what kind of SSO they are working with. Depending on that I can suggest to either work with a separate location or make a folder on the same server machine.
I will update the happenings as soon as I get something
Does this solution work if the shared drive is running on Linux machine? The web player server can see the file ( from the windows explorer ) but somehow when we open the dxp with the UNC path, it throws an error. The user does have read access to the folder we are trying to access and can open the file from windows as well.
Fouth, if you are not using the SSO methond, but have Using Forms(Username and Password) or Anonymous:
If using any of these 2 authentication methods you need to grant access to the user running the application pool. By default the application pool will be running under the "Networkservice" account. It is usually easiest to set the application pool to be running under a custom Windows user account and then grant access to the network share for this user.