Default join database

The default join database is used for creating temporary tables and joining the final result when running an information link.

Most often using the standard Spotfire database for the default join database will work fine. However, in certain situations you may want to configure another database to be used. For example, if you prefer to run these operations as a specific user on the database, or if you want to use a database that is specifically optimized for temporary tables.

To set up a default join database use the command create-join-db.

Default join database settings
Option Description
Type Sets the type of database and driver you want to use as the default join database. Refers to a data source template.
Connection URL The connection URL to the database.
Number of Connections A minimum and maximum number of connections to use when accessing the database.
Username and Password The username and password that will be used to access the database.