Jump to content
  • Access OData provider data from Spotfire® Cloud web clients


     

    Since May 2017, OData has been supported in Spotfire® Cloud Business Author and Consumer. This means that when you open an analysis file with data from OData in Spotfire Cloud Business Author and Consumer, you can load data directly from your OData instance. The OData connector supports in-memory data import.

    Analysis files with OData connections are authored in Spotfire Cloud Analyst, saved to the Spotfire Cloud Library and are then available for Spotfire Cloud Business Author and Consumer users.

    You can manually refresh data from individual data sources from Business Author's Source View.

    Note: You might have to allow the Spotfire Cloud servers to access your Odata providers by white listing the servers' IP addresses. More information is available in the TIBCO Spotfire Cloud help.

    Example of using a public OData provider

    In this example we will create and store an OData data connection in the Spotifre Cloud Library. This will allow us to reuse the data model in multiple analysis files.

    Launch the Spotfire Windows client Spotfire Analyst and navigate to the Tools menu. Select Manage Data Connection and add a new data connection to OData.

    01_create_odata_connection.png.fccfc2968319e1a890b43586a8aca64f.png

     

    Connect to the OData provider below. No username or password is needed.

     http://booking.cathay.com.sg/WSVistaWebClient/OData.svc/
     

     

    02_connect_to_odata.png.38f8df7070815d2832b7155251d5994f.png

     

    In the Views in Connection dialog, search for all tables containing the word "film" and double-click all four tables to add them to the view.

    03_select_tables_with_preview.thumb.png.82bde08f164e65b565c3bb5b6183ecce.png

     

    Save the data connection to the Library.

    04_save_data_connection_to_library.png.3569609f1b5a987c423ad502c9a0a724.png

     

    Create a new analysis file by opening the saved data connection.

    05_use_data_connection_in_dxp.thumb.png.af71e3250f2da07bcc38d8183127ec87.png

     

    Notice that the data has been loaded into four Spotfire data tables, which have been added to the analysis file.

    06_four_tables_added_to_dxp.thumb.png.5bdd2fa00431ba93517a6439001d284d.png

     

    To be able to analyze film genres we will join the data tables 'Films' and 'FilmGenres', by using Spotfire's Add Columns feature. To use Add Columns, select Insert > Columns....

    07_join.png.9099c009ce7f7252f5232e66c4aa3804.png

     

    Add columns to the data table 'Films' from the 'FilmGenres' data table, which is available under Select > From Current Analysis

    08_join2.png.43639b697cdefcd2d26a3b9c95a98f52.png

     

    Match the columns 'Films.GenreId' and 'FilmGenres.ID'.

    09_join3.png.e6e8c91a52a0d464065f43fcf5f45249.png

     

    Add all columns from the 'FilmGenres' data table.

    10_join4.png.2e0afdec3fd533d36844de61d3b0f3fe.png

     

    The result can be viewed in the Source View.

    11_join5.thumb.png.3caca7f5a4043929a18c2f5c1f95c0d5.png

     

    To make the column easier to identify, use the data panel to rename the column 'Name' to 'Genre'.

    12_rename_to_genre.png.3d180be425ef113478c6dfdc2780ab54.png

     

    We can now easily analyze, for example, films released over time, genre distribution and what's coming soon.

    13_analysis_in_analyst.thumb.png.5c6aeec839b38fa66e4b788574837c3b.png

    Save the analysis file to the Spotfire Cloud Library. Then browse to https://spotfire.cloud.tibco.com/spotfire/login.html#/ and login to your Spotfire Cloud web client. 

    14_analysis_in_ba1.png.c56afdff53fac1d84991cb225028d40c.png

    Click on the analysis file to open it in the web client Spotfire Consumer.

    Data will be loaded into the analysis file directly from the OData provider.

    15_analysis_in_ba2.thumb.png.eb27c57945ba3a5eb54ff520b2adc511.png

    Click the Edit button to enable authoring. This will enable the Business Author client and editing capabilities.

    16_enable_authoring.png.78635590948629f2b2421005b99920c6.png

    If you know that certain data tables are rarely updated with new data, you can consider to change how their data is loaded into Spotfire. Go to the Source View and click on the data source. You can choose to store the data in the analysis file (embed) and only refresh data manually when needed. There is also a fallback mode that will load new data when the data source is available.

    17_new_data_when_possible.png.65a56ba42c5d523d74b4bbbb4a552135.png

    If the OData provider used in this example is offline, or if you want to try with some other data, more examples are listed here.


    User Feedback

    Recommended Comments

    There are no comments to display.


×
×
  • Create New...