Using LiveView as a Front-End

TIBCO LiveView can connect to other tools as data sources. LiveView can use the following back ends:

  • Other LiveView servers in a federated system.

  • TIBCO StreamBase Query Tables.

  • TIBCO ActiveSpaces spaces and metaspaces.

  • JBDC tables.

  • A user-written Custom Table Provider can provide access to an arbitrary source. See the TableProvider interface in the Java Client API Documentation for more information.

LiveView back ends allow specific queries, based on their own capabilities. All table types can accept all simple predicates in queries.

Backend Type Query Language Query Type Projections Streaming Modifiers Query Modifiers
Foreign LiveView Server LiveQL SNAPSHOT, CONTINUOUS, SNAPSHOT_AND_CONTINUOUS, DELETE *, exact field name, aggregate expression Time-delay, Time-window Top-N
StreamBase Query Tables LiveQL SNAPSHOT, CONTINUOUS, SNAPSHOT_AND_CONTINUOUS, DELETE *, exact field name, aggregate expression Time-delay, Time-window Top-N
ActiveSpaces ActiveSpaces query language

SNAPSHOT, CONTINUOUS, SNAPSHOT_AND_CONTINUOUS, DELETE

SNAPSHOT_AND_CONTINUOUS queries to an ActiveSpaces table can have their result sets truncated without an error indication if the result set size is larger then the configured ActiveSpaces space QueryLimit. SNAPSHOT-only and DELETE queries will correctly report an error if the result set has been truncated by the configured ActiveSpaces space QueryLimit. See the ActiveSpaces documentation on how to configure the QueryLimit on a space.

*, exact field name.

ActiveSpaces query language does not accept single quotes around strings. Any strings must be delimited with double quotes.

None None
JDBC Tables SQL SNAPSHOT SQL projections None None

LiveView back ends support specific LiveView capabilities.

Backend Type Publish Alert External host
Single Foreign LiveView Server Y Y Y
Multiple Foreign LiveView servers N Y Y
TIBCO StreamBase Query Table N N Y
TIBCO ActiveSpaces Y N N
JDBC N N N

LiveView ships with an ActiveSpaces sample that you can use to get started with the integration of LiveView and TIBCO ActiveSpaces.