Premium Feature — Available in the Professional Plus and Enterprise Editions. Learn more or contact LabKey.

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:

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

Discussion

Was this content helpful?

Log in or register an account to provide feedback


previousnext
 
expand all collapse all