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