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.