Deploying Spotfire Middle Tier solution

    Integration with Spotfire® offers powerful data visualization and statistical analysis, especially in terms of speeding up analysis of large chemical libraries and non-chemical datasets. The Spotfire Integration tool plays an important role in setting up an interactive communication route between clients using open data communication protocol (OData). The new Spotfire integration relies on a middle tier server to provide data to Spotfire®. This middle tier capability is provided by Plexus Connect and the communication schema is best described by this image:

    images/download/attachments/1804882/SFMiddleTier.png

    The solution works with permanent lists that are created via IJC or Plexus Connect. Those permanent lists are stored in the IJC Schema and then read by Connect and provided to the Spotfire bridge to load the data from the IJC Schema.

    Prerequisites

    The integration with Spotfire® requires the following packages to be installed with matching (compatible) versions:

    Supported versions

    Currently supported versions of Spotfire server are: 7.x up to 10.10.

    Spotfire plugin deployment

    • open Spotfire deployment server and login

    • upload Spotfire bridge .spk file to deployment area

    • IJC.ODataConnection will be installed to the area (or overwrite already installed version of IJC.ODataConnection)

    • validate the deployment

    • save the deployment

    Spotfire plugin installation

    • start Spotfire client

    • log in into the deployment server

    • you will be offered update - the new IJC.ODataConnection plugin will be downloaded

    • let it install/update

    • Spotfire client will restart itself after successful install/update of the plugin

    • log in again, no updates should be offered as your application is up to date against Spotfire deployment server

    • Spotfire client will start up normally

    Spotfire plugin usage

    Prerequisites:

    • Plexus Connect instance deployed and connected to the database you want to work with

    • Plexus Connect's backend serves as a middle-tier data provider between Spotfire and the database

    • IJC – works with the same DB and can be used to create permanent lists

    • Plexus Connect's frontend works with the same DB and can be used to create permanent lists

    Create a permanent list from the desired data set that you want to work with in Spotfire. This can be achieved either via IJC or via Plexus Connect.

    • Open Spotfire with IJC.ODataConnection plugin installed

    • Click the "Import from Plexus..." menu item

    • define the URL where Plexus Connect instance is running

    • log in with your credentials

    • select the available Schema to work with

    • you will be offered with a collection of "Permanent lists" available to your login

      • each permanent list includes information about the name of the Data Tree they are present in

      • each permanent list also has expandable list of associated entities (multiple entities or just ROOT entity)

      • the collection of the permanent lists is sortable and searchable

    • select the desired permanent list and its entity from the collection

    • data will load into Spotfire

    The whole process, including several usage examples can be seen on the video here.