Set Up

LabKey's JDBC driver allows Spotfire to query the server and use the results to build visualizations. To configure Spotfire to use the LabKey JDBC driver, do the following:

• In Spotfire Server, copy the LabKey JDBC driver jar to the directory

<tibco-server-install>/tomcat/lib/

• Launch the Spotfire Server Configuration Tool.
• Click the Configuration tab.
• On the lefthand pane click DataSource Templates.
• Add a New LabKey data source using the following template:

<jdbc-type-settings>
    <type-name>LabKey</type-name>
    <driver>org.labkey.jdbc.LabKeyDriver</driver>
    <connection-url-pattern>jdbc:labkey:http&lt;s&gt;://&lt;host&gt;:&lt;port&gt;/&lt;context&gt;</connection-url-pattern>
    <ping-command></ping-command>
    <use-ansii-join>true</use-ansii-join>
    <connection-properties>
        <connection-property>
            <key>rootIsCatalog</key>
            <value>true</value>
        </connection-property>
    </connection-properties>
</jdbc-type-settings>

For more details, see the Spotfire documentation:

• Adding the JDBC driver and Data Source Template
• TIBCO Spotfire® JDBC Data Access Connectivity Details

Using LabKey Data

• In the Spotfire Information Designer add a data source of type 'labkey'. (Once you have successfully added the driver above, 'labkey' will be available in the Type dropdown.
• You must also provide a Connection URL, Username, and Password. See an example screen shot below.

• Now you will be able to see the LabKey Server folder heirarchy and exposed schemas.

Logging

In Spotfire Server, add the following to Spotfire’s tomcat/conf/logging.properties:

org.labkey.jdbc.level = FINE

In Spotfire’s tomcat’s default logging config, this will result in logging into the stderr log file appender.

Note that unimplemented JDBC methods get logged as SEVERE (java.util.logging) / ERROR (log4j/slf4j).

Logging options:

• org.labkey.jdbc.level = FINE (Provides java.util.logging levels)
• org.labkey.jdbc.level = DEBUG (Provides log4j or slf4j logging levels)

Related Topics

• LabKey JDBC Driver