Setting up a Spotfire Data source

Set up a data source for Spotfire.

1. Within TIBCO Spotfire Professional, open the Information Designer from the menu bar as: Tools -Information Designer.
2. Click the Setup Data Source link.
3. Input the Data Source fields, as appropriate.

   For MySql database, example values are shown as follows:

   Name: asgstat

   Type: MySQL5

   Connection URL: jdbc:mysql://database host:port/database

   Where database host is the machine database server runs, by default the port is 3306, and database is the database name such as asgstat.

   No. of connections:

   • Min: 1
   • Max: 10

   Username: asguser

   Password: asgpass

   For Oracle database, example values are shown as follows:

   Name: asgstat

   Type: Oracle

   Connection URL: jdbc:oracle:thin:@database host:port:service name

   Where database host is the machine database server runs, by default the port is 1521, and the service name is the Oracle service name.

   No. of connections:

   • Min: 1
   • Max: 10

   Username: asguser

   Password: asgpass

   For SQL Server database, example values are shown as follows:

   Name: asgstat

   Type: SQL Server

   Connection URL:jdbc:sqlserver://database host:1433/database

   Where database host is the machine database server runs, by default the port is 1433, and database is the database name such as asgstat.

   No. of connections:

   • Min: 1
   • Max: 10

   Username: asguser

   Password: asgpass

4. Click Save.
5. Click Save again, if pop window appears.
6. Verify that this data source appears in the left panel of the Information Designer dialog with a plus (+) sign next to it.