Default join database

When running an information link a join database is used for creating temporary tables and joining the final result. When you specify a default join database, this is one possible join database. Spotfire can also search the information link query for a writable data source that can be used as a join database, or use any writable information services data source in the library.

Configure a default join database when you know that your data sources are read-only.

You might also want to configure a default join database, for example, if you prefer to run these operations as a specific user on a certain database, or if you want to use a database that is optimized for temporary tables.

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

When you do not configure your own default join database, the Spotfire database is set as the default.

CAUTION: The possibility to use the Spotfire database as the default join database will be removed in a future release. To ensure that you are able to join multiple data sources in future versions, make sure that a writable data source is available in the library for the current user, or that a custom default join database is configured. To learn more about different options for configuring join databases, see Changing the default join database on the TIBCO Community.

Table 1. 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.