You can configure action logging to write to an Oracle database, and then run the required additional scripts need for logging to a database. Sample scripts are included in the installation kit for
Spotfire Server.
This topic describes the steps required to configure the database and run the configuration scripts from the command line. Alternatively, you can enable and configure the action logging and system monitoring from the configuration tool. For more information, see the following topics.
-
Log in to
Spotfire Server, and in the file system, browse to the directory containing the installation kit files.
-
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.
-
Using a text editor, open the script file.
The script file to edit is named
create_actionlog_db.bat (or, for Linux,
create_actionlog_db.sh) .
-
In the script file, edit the section containing the database name
spotfire_actionlog, setting the variables to reflect your database environment.
You must provide the database password in this script. If you do not have the password, consult your DBA for assistance.
Note: If you want to use the information layer, do not change the user and name, unless you use the
Redirect dependent elements functionality in
Spotfire Analyst Information Designer. See the
Spotfire Analyst help topic "Redirecting the Information Model" for more information on this functionality.
- Optional:
If your database is running on Amazon RDS, also edit the script file
create_actionlog_db_rds.bat (or, for Linux,
create_actionlog_db_rds.sh), specifying the same information.
-
Run the script to create the database.
Information and error logs are written to a file named
actionlogs.txt in the directory from where you run the script. If the script takes a very long time, or if it fails, check this text file for more information.
The database is created on the server.
-
On
Spotfire Server, from the
Start menu, open a command-line window as administrator.
-
Browse to
<installation dir>\tomcat\bin.
-
Export the configuration: At the command prompt, type the command
config export-config.
config export-config --force
When prompted, supply the tools password. See
export-config for more information.
-
At the command prompt, type the command
config config-action-log-database-logger, passing in the arguments specifying the details of the database.
For example, to specify the Oracle database URL, driver class, user name, and password. The following example demonstrates the information you must provide.
config config-action-log-database-logger
--database-url="jdbc:tibcosoftwareinc:oracle://some.oraserver.com:1521;ServiceName=pdborcl.example.com"
--driver-class="tibcosoftwareinc.jdbc.oracle.OracleDriver" --username="spotfire_actionlog"
-
At the command prompt, type the command
config import-config.
config import-config --comment="adding database configuration for action logging."
When prompted, supply the tools password. See
import-config for more information.
-
Restart
Spotfire Server.
What to do next
Use the
Information Links and sample analysis file from the installation kit to create a visualization from the action logs.