Creating an Information Services data source template using Kerberos login

The default Information Services Data Source templates that are included with Spotfire Server are not configured to use Kerberos. You must therefore create a new data source template based on one of the default templates.

Procedure

List the existing data source templates by using the list‐ds‐template command and select one that matches the database you are setting up, for example Oracle.
Export the definition of the selected data source template by using the export‐ds‐template command.
Open the exported definition file in a text editor.

Add the JDBC connection property key spotfire.connection.pool.factory.data.source with the value kerberos.data.source within the connection-properties element. If there is no connection-properties element, create one.

There may also be other connection properties you must add; consult the documentation of the database server for more information. For general instructions about adding connection properties, see JDBC connection properties.

Example:

<jdbc-type-settings>
 <type-name>oracle</type-name>
 <driver>oracle.jdbc.OracleDriver</driver>
 <connection-urlpattern>jdbc:oracle:thin:@&lt;host&gt;
:&lt;port1521&gt;:&lt;sid&gt;</
connection-url-pattern>
 <ping-command>SELECT 1 FROM DUAL</ping-command>
<connection-properties>
 <connection-property>
 <key>spotfire.connection.pool.factory.data.source</key>
 <value>kerberos.data.source</value>
 </connection-property>
<connection-property>
 <key>oracle.net.authentication_services</key>
 <value>(KERBEROS5)</value>
 </connection-property>
</connection-properties>

Use the add‐ds‐template command to add the new data source template with a suitable name, such as "oracle_kerberos", using the modified template definition.
Import the configuration and restart the server.

What to do next

Verify the data source template