Importing a library to Spotfire Analyst for analyzing action logs

The installation kit includes a downloadable .zip file containing Information Links and a sample analysis file so that you can create a visualization to analyze your user action logs.

Prerequisites

Procedure

  1. In the installation kit that you downloaded from the TIBCO eDelivery site, browse to the directory containing the scripts to create a new database and schema.
    • For Oracle, this directory is /scripts/oracle_install/actionlog.
    • For SQL Server, this directory is /scripts/mssql_install/actionlog.
  2. In the installation kit directory, find the .zip file.
    • For Oracle, this file is logged_user_actions_ora.part0.zip.
    • For SQL Server, this file is logged_user_actions_mssql.part0.zip.
  3. On Spotfire Server, open a command line as administrator and go to the <server installation dir>/tomcat/bin directory.
  4. On the command line, type the command config import-library-content, specifying the options needed to import the .zip file. Example
    config import-library-content --tool-password=<password> --file-path=/scripts/oracle_install/actionlog/logged_user_actions_ora.part0.zip --conflict-resolution-mode=KEEP_BOTH --user=jdoe
    See import-library-content for more information.
  5. Open Spotfire Analyst.
  6. From the menu, click Tools > Information Designer, and then open the Data Source tab.
  7. Provide information to connect to the data source, and then save the changes.
    You must provide the Type, the Connection URL, the Username, and the Password.

Result

The analysis is ready to start reading logging from the database, and the Spotfire Analyst should reflect data read from the system monitoring and the user action logs.