< Previous

Using LiveView as a Front-End

TIBCO StreamBase LiveView Data Mart can connect to other tools as data sources. LiveView can use the following backends:

Other LiveView servers in a federated system.
TIBCO ActiveSpaces spaces and metaspaces.
JBDC tables.

LiveView backends 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	LiveView	SNAPSHOT, CONTINUOUS, SNAPSHOT_AND_CONTINUOUS, DELETE	*, exact field name, aggregate expression	Time-delay, Time-window	Top-N
ActiveSpaces	LiveView	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. All result sets from an ActiveSpaces query always append the primary key fields, even if they are not specified in the projection.	None	None
JDBC Tables	SQL	SNAPSHOT	SQL projections	None	None

Backend Type

Query Language

Query Type

Projections

Streaming Modifiers

Query Modifiers

Foreign LiveView

LiveView

SNAPSHOT, CONTINUOUS, SNAPSHOT_AND_CONTINUOUS, DELETE

*, exact field name, aggregate expression

Time-delay, Time-window

Top-N

ActiveSpaces

LiveView

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.

All result sets from an ActiveSpaces query always append the primary key fields, even if they are not specified in the projection.

None

JDBC Tables

SQL

SNAPSHOT

SQL projections

None

LiveView backends support specific LiveView capabilities.

Backend Type	Publish	Alert	External host
Foreign LiveView	Y	Y	Y
ActiveSpaces	Y	N	N
JDBC	N	N	N

LiveView ships an ActiveSpaces sample that you can use to get started with ActiveSpaces.

Load and run the LiveView ActiveSpaces sample as delivered with LiveView. Follow these steps:

Start StreamBase Studio in the SB Authoring perspective.
Load the ActiveSpaces sample.
1. Select File → Load StreamBase Sample from Studio's top-level menu.
2. In the Load StreamBase Projects dialog, open the StreamBase LiveView category.
3. Select the sample whose description is Connect to an ActiveSpaces MetaSpace.
4. Select the check box for Open selected sample's README or cheat sheet after importing.
5. Click OK.
The ActiveSpaces sample loads into Studio with the project name sample_lv-activespaces.