File path configuration Question
I have loaded a file to Spotfire and kept loading option as "Linked to Source" instead of embed. When i open the link in web player it says "The datasource may be missing or has been changed".
Can someone tell me how to connect this report to data source dynamically, i mean, Spotfire server should understand the location and load the data into report. I heard something to set at server side. If yes, can you please guide me or provide a link to go thru.
The file i pointed refreshes every day and i want this process to be automatic than manual. Please throw in your ideas.
(1) Ensure you add your file to Spotfire client from a UNC path like:
Becuase that EXACT path must be accessible on the Web Player server as well. So if you add a file from c:\users\mylocaluser\Desktop\mystuff\myfile.xlsl, then that will not be present locally on the Web Player machine and it won't work. This path can be seen in the installed client here:
- Edit > Data Table Properties > select your table > Source Information Tab
(2) Once you have the file in the report based on a UNC path like above, then you need to allow that file path on the Web Player. Instructions for this are found onthe TIBCO Support site in KB: 42035 Accessing linked data in the Web Player.
KB: 42035 Accessing linked data in the Web Player
Title: Accessing linked data in the Web Player. Description: If an analysis has linked data, the following changes in configuration will allow the Web Player to open that analysis. Environment: Product: TIBCO Spotfire Web Player Version:5.5, 6.0, 6.5 OS: All Supported Operating Systems -------------------- Resolution: The Web Player's ability to access linked files that are located outside the Web Player server must be enabled in the web.config file. Changes to the web.config file only take effect after the web.config file has been saved and the Web Player application pool has been restarted in IIS. Make a backup copy of the web.config file before making any changes to it. There are two ways of addressing this: 1). Specify the individual shared drives in the web.config file's 'AllowedFilePaths' parameter: ======= <setting name="AllowedFilePaths" serializeAs="Xml"> <value> <ArrayOfString> <string /> </ArrayOfString> </value> </setting> ======== The string value has to be modified to contain the UNC path of the network drive. Note that this means the default use of <string /> (which is an XML null tag, with the / at the end of the tag) must be replaced with <string>...</string> syntax (with the / at the beginning of the XML end tag). Example: <string>\\srv1\share\</string> 2). Add the following parameter in the web.config file. =============== <Spotfire.Dxp.Data.Properties.Settings> ... <setting name="AllowAllFilePaths" serializeAs="String"> <value>True</value> </setting> </Spotfire.Dxp.Data.Properties.Settings> =============== Once this setting is added to the Web.config file, restart the application pool and try accessing the files using the Web Player. Note: Only use one of these options. For any of these options to work, make sure the user running the Web Player Application Pool has the required access to the shared drive. By default, the Web Player application pool runs as 'NETWORK SERVICE' and this user does not have access beyond the Web Player server machine. You may need to run the application pool as a custom user account. A custom account can normally be placed as Domain\Username in identity. Make sure that this user has access to the network share. Note: Use an XML editor or a plain-text editor (such as Notepad) when editing the web.config file. Do not edit using WordPad or MS Word, as these applications often replace standard quotation marks (" ", ' ') with angled quotation marks that will break the XML code in the file.
(3) You then need to ensure that the propert accounts have access to it. This will differ if you have basic authentication vs SSO. This KB describes it:
KB: 43015 How to open analysis files on the Web Player when they contain linked data located on a network share.
Title: How to open analysis files on the Web Player when they contain linked data located on a network share. Environment: Product: TIBCO Spotfire Web Player Version: All versions OS: All Supported Operating Systems -------------------- Resolution: No matter which authentication method you use, you need to add the path to the network share to the "AllowedFilePaths" section of the web.config. Please see KB article 42035 for more information. Web player 7.0 and older ********************************************** You need to grant at least read permission on the network share to the user accessing the network share.Depending on what authentication method is used on the Web player the user can be either the user running the application pool in IIS or the actual user logged into Windows on the client machine. Using SSO(Single sign on) methods: If you are using one of the 4 SSO(Single Sign on) methods then you need to grant access to the network share for the user running the web browser. This is because as soon as you use "Windows Authentication" in IIS, it will be the users credentials that will be used to access the network share. This is not something the Web player has to do with, it is the way IIS uses Windows authentication. 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(See reference #1 for more details). 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. 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. ********************************************** Web player 7.5 and newer ********************************************** The Spotfire Web player 7.5 is no longer running on IIS(Microsoft Internet Information Services) and all user authentication is now done on the Spotfire server, so the way the Web player accesses shared network drives has changed compared to earlier versions. In v7.5 the Web player service is running under the identity of the "Tibco Spotifre Node Manager" service. This means that unless you are using Kerberos as authentication method on the Spotfire server and you have enabled delegation for the service account used by the Spotfire server for kerberos, it is the identity of the user running the "Tibco Spotifre Node Manager" service that will be used to connect to network shares. - If you are not using Kerberos as authentication method, then you need to make sure the user running the "Tibco Spotifre Node Manager" has read permissions to the network share. - If you are not using Kerberos as authentication method and have enabled delegation for the service account used the Spotfire server for kerberos, then you need to make sure the end user has read permissions to the Spotfire server. ********************************************** Note! Linking data to files located on a network share should always be done using UNC paths and not mapped network drives. You need to link the data in the analysis as "\\server\networkshare\file.ext" and NOT "z:\folder\file.ext"