Skip to main content
InSource Solutions

TN Intel108 Referencing a Shared Excel Datasource from the Intelligence Analytics Client

  1. Last updated
  2. Save as PDF

InSource_Logo_Transparent.png

Description

 

This article from InSource shows how to configure a shared Excel datasource when publishing a workbook from the Wonderware Intelligence Analytics client.

  • Author: Rich Brooks
  • Published: 8/17/2016
  • Applies to: Wonderware Intelligence 2014R2 and higher

Details

Wonderware Intelligence data is sometime supplemented with related data from other sources.  In this case, data from an Excel spreadsheet is included in a workbook containing Intelligence data.  It is important to setup the Excel spreadsheet in a shared location.  This will facilitate regular updates to the data on a rolling weekly or monthly basis.

The data source in the Intelligence Analytics client needs to be saved to a shared folder.  Click on the name of the Excel workbook as shown circled below.

Capture1.PNG

Enter a UNC path to access the file with the format \\<node name>\<share>\ .

Capture2.PNG

The UNC path needs to include a shared folder that is accessible by the users that will be updating the Excel data.

Capture3.PNG

Select File and Save from the menu to save the changes to the Tableau workbook.

Capture4.PNG

In this example, the Tableau workbook is saved to the same UNC path as the Excel workbook.

Capture5.PNG

Select the Yes button to replace the file, if it already exists.

Click on one of the sheets from the tabs at the bottom of the Intelligence Analytics client.

Capture6.PNG

Select Server and Publish Workbook... from the menu.

Capture7.PNG

The Include External File option must be turned off before publishing.  Uncheck the checkbox circled above and then click the Publish button.

Capture8.PNG

You will be prompted to exclude the external files.  Click on the Yes button to confirm.

The workbook will be published to the Intelligence (web dashboard) server.  Any changes to the Excel data may be made from the shared folder.