Collecting required information

To set up the Spotfire database, and install and configure Spotfire Server, you must have certain information about the IT system at your site and how you want Spotfire Server to interact with the existing system.

About this task

Before you begin

A database server must be up and running before you can install Spotfire Server, preferably on a separate computer. The Spotfire Server installer will not install a database server. The Spotfire environment supports a couple of different database systems.

Procedure

Collect the following information about your database server:

Note: You may need to contact your database administrator.


Required information	Notes	Your information
Database server type	MSSQL,Oracle or PostgreSQL
Database server hostname
Administrator user name
Administrator password
Connection identifier	For Oracle only

For PostgreSQL, you should also take note of the path to the bin directory of the PostgreSQL command line tools (on the computer from which you will run the scripts).

Decide on the following information for the Spotfire database:


Required information	Notes	Your information
Spotfire database name	For MSSQL and PostgreSQL. The default is spotfire_server.
Spotfire database user name	If the databases uses Integrated Windows authentication, note this user. If you use Integrated authentication, Spotfire Server must run as this Windows Domain user.
Spotfire database password

Decide on the following for Spotfire Server:


Required information	Notes	Your information
Spotfire Server front-end port	Used for communication with Spotfire clients. The default is 80. If another application on the same computer uses port 80, select a different port number.
Back-end registration port	Used for key exchange to set up trusted communication between the Spotfire Server and nodes. The default is 9080.
Back-end communication port (TLS)	Used for encrypted traffic between nodes. The default is 9443.
Spotfire Server login method	Knowledge about your organization's IT infrastructure is required to set up any login method other than Spotfire database. Available login methods: Username and password: Spotfire database, LDAP, Custom JAAS, Windows NT Domain Single sign-on: NTLM, Kerberos, X.509 Client Certificate, web authentication
Spotfire Server user directory	Knowledge about your organization's IT infrastructure is required to set up any user directory other than Spotfire database. Valid options are: Spotfire database, LDAP, and Windows NT Domain.
Spotfire Server operating system
Spotfire Servers hostnames
Hostname of load balancer, if applicable

What to do next

Spotfire database setup