LiveDesign Connector panel features

General

The LiveDesign Connector is a Spotfire panel developed to increase the integration of LiveDesign and Spotfire from Spotfire Analyst and Web Player. Using the LiveDesign Connector, you can, among other features, import LiveReport data into Spotfire and create Spotfire templates designed for the LiveDesign Gadget.

To use the LiveDesign Connector, follow the steps described below:

1. Open the LiveDesign Connector panel
   • Launch your Spotfire client (Analyst or Web Player)
   • Click on the menu Discngine > LiveDesign Connector

2. Login to LiveDesign
   • If you are not already connected to LiveDesign, enter your credentials in the opened window
   • You can save your credentials to avoid this step next time

Import LiveReport

1. Click on Import
   • This button is available from the LiveDesign Connector home page in the Import LiveReport card
   • This will open the import page

2. Select the LiveReport to import

   • To find it you can filter the LiveReports based on the name or id, or you can browse the complete LiveDesign tree
   • When your mouse is over a LiveReport name, additional information is provided, such as author or id
   • Once selected, click on Next
     
     

3. Set the import options

   • Set the name of the import data table
     • For now this name must be "LiveReport Data" or the name defined in the DefaultExportDataTableName preference to be used in the gadget
   • Select the structure column(s) you want to generate
   • Choose if you want to import the LiveReport in the current document or in a template related to the selected LiveReport

4. Click on Import LiveReport
   • The import process steps will be displayed

5. Once the import is done, you can check the status in the Spotfire notifications

Explanation:
When importing a LiveReport as a data table into Spotfire, the data source LiveDesign DataSource by Discngine is used. In addition some metadata are stored in the data table properties and will be used when saving the document as template, including project ID and name, LiveReport ID and name, structure formats and origin.

Save as template

After editing a document having a LiveReport imported into the standard data table ("LiveReport Data" or name defined in the DefaultExportDataTableName preference), you can save the document as a new template.

1. Click on Save

   • This button is available from the LiveDesign Connector home page in the Template card
   • This will open the save template page, with prefilled values if you are already in an existing template

2. Set the template name and location

   • Check the concerned project and LiveReport
   • Set the name of the template
   • Set the description of the template
   • Choose the accessibility level of the template.
     • If Global, the template will be saved under <DefaultLibraryPath>/Project 0
     • If Project, the template will be saved under <DefaultLibraryPath>/Project <Project ID>
     • If LiveReport, the template will be saved under <DefaultLibraryPath>/Project <Project ID>/LiveReport <Livereport ID>
     • The final library path is reminded below
     • See Library Structure Convention for more details

3. Click on Save

   • The document is saved at the indicated location, and the data table is configured to be in "Stored Data" mode

You can now use the template from the Spotfire Connector Gadget.

Explanation:
Saving a Spotfire document as a template for the gadget implies extra-steps compared to the simple save functionality. The first step is to use the appropriate path in the Spotfire library to have the chosen accessibility of the template from the gadget in LiveDesign. If the accessibility of a template is set to LiveReport, then this template will be available in LiveDesign only from the associated LiveReport. If it is set to Project, then it will be available from all LiveReports of the associated project. Finally if it is set to Global, it will be available from all LiveReports. The second step is to set the data loading to “Stored data” in order to avoid having to reconnect to LiveDesign each time the analysis is opened, either in Spotfire or LiveDesign environments. The last step is to close the panel before saving (and open it back after) in order to not have the panel displayed by default when opening a template in the gadget.

Manage project columns

After importing one or several LiveReports in a Spotfire template, you can manage the list of LiveDesign project columns available in these LiveReports.

NB : currently, only Computational Models (without parameters), Database (Other) Columns and Freeform Columns are managed.

1. Click on Manage project columns

   • This button is available from the LiveDesign Connector home page in the Edit LiveReport card
   • This will open the Manage Project Columns page

2. Select the data table for which manage project columns

   • This data table must have been imported from a LiveReport

3. Search for the column(s) to add/remove

   • You can expand/collapse the folders in the column tree view
   • You can filter the columns by name in the search field

4. Add or remove a column in the associated LiveReport

   • Click on the Add (+) or Remove (-) button located next to the name of the column
   • A notification will be displayed when the column is added or removed successfully
   A column can be present in the LiveReport but hidden. In this case, the column will not be imported in Spotfire, as only visible column are exported by the LiveDesign API.

5. (Optional) Refresh the content of a column being part of Computational Models in the associated LiveReport

   • Click on the Refresh Model button located next to the column name
   • This will run the corresponding model
   • A notification will give the status of this run

6. Refresh the selected data table after editing the associated LiveReport by clicking on the Refresh Data Table button.

Example:

Synchronize tags

In LiveDesign, compounds can be annotated using freeform columns and in Spotfire, rows can be annotated using tags. These two functionnalities can be synchronized through the Connector in order to annotate your data no matter the context.

The compatible freeform columns are automatically imported as tags when LiveReport data are loaded into Spotfire through the panel, at import time or when reloading. It is optional in the data source. Note that they are never deleted at import time even if there is no corresponding freeform column in the imported LiveReport, in order to avoid to break the template.
These tags can be modified, or new tags can be created (see official documentation). In order to save these modifications in LiveDesign, a user input is required.

1. Click on Synchronize Tags

   • This button is available from the LiveDesign Connector home page in the Edit LiveReport card
   • This will open the Synchronize Tags page

2. Select the data table from which to export tags

   • This data table must have been imported from a LiveReport

3. Choose the tags to export as freeform columns

   • By default all existing and new tags are exported
   If you choose to not export some of the modified tags and reload the data, the modifications will be overwritten by the freeform columns coming from LiveDesign.

4. Configure new tags

   • Choose weither the corresponding new freeform columns are published in the associated project or not
     • If published, choose the freeform columns folder

5. Click on Export

Explanation:
The ID column coming from LiveDesign is used as key column and is mandatory in order to associate values to the good rows. Note that if this column is hidden in the LiveReport, it is temporarily displayed at import time.
When a tag is created from a freeform column, the identifier of this column is retrieved and saved in the tags column properties. This identifier is then used for the synchronization, in order to make it work even if the freeform column or tags column are renamed. When a new freeform column is created from a tags column, the newly created identifier is also retrieved from LiveDesign and applied to the tags column properties in Spotfire.