Skip to main content

Hands-on quick tour

This section of the documentation is being updated.

Viewing dashboards

This section of the documentation is being updated.

Creating sources and caches using Source Preview

This section of the documentation is being updated.

Modifying an application using Flow Designer

This section of the documentation is being updated.

Browsing data with ad-hoc queries

Ad-hoc queries let you do free-form queries on WActionStores, caches, or streams in real time by entering select statements in the Tungsten console. The syntax is the same as for queries in TQL applications (see CREATE CQ (query)) .

The following example assumes you performed the steps in Modifying an application using Flow Designer including deploying and starting the application.Modifying an application using Flow Designer

  1. Open a terminal window and start the Tungsten console. If Striim is installed in /opt, the command is: /opt/Striim/bin/console.sh

  2. Log in with username admin and the password you provided when you installed Striim.

  3. At the W (admin) > prompt, enter the following: select * from PosSourceNS.PosSourceData; You should see something like the following:

    [
   MerchantId = Mpc6ZXJBAqw7fOMSSj8Fnlyexx6wsDY7A4E
   DateTime = 2607-11-27T09:22:53.210-08:00
   Amount = 23.33
   Zip = 12228
   City = Albany
   State = NY
   LatVal = 42.6149
   LongVal = -73.9708
]
[
   MerchantId = Mpc6ZXJBAqw7fOMSSj8Fnlyexx6wsDY7A4E
   DateTime = 2607-11-27T09:22:53.210-08:00
   Amount = 34.26
   Zip = 23405
   City = Machipongo
   State = VA
   LatVal = 37.4014
   LongVal = -75.9082
]

  4. Press Enter to exit the query.

  5. If you prefer, you can see the data in a tabular format. To try that, enter: set printformat=row_format;

  6. Press cursor up twice to recall the query, then press Enter to run it again. You should see the following (if necessary, widen the terminal window to format the table correctly):

Query results as displayed in the console.

To switch back to the default format:

set printformat=json;

Continue with Creating a dashboard Creating a dashboard

Creating a dashboard

This section of the documentation is being updated.

Exporting applications and dashboards

This section of the documentation is being updated.

What next?

See Web UI Overview for a look at additional Striim features.

Run the CDC demo applications to explore Striim's data migration capabilities (see Running the CDC demo apps).

If you do not plan to write Striim applications but would like to create or modify dashboards, continue with the Dashboard Guide  and PosAppDash in the Programmer's Guide.

Note

The Striim platform's TQL programming language is in many ways similar to SQL, particularly as regards SELECT statements. The Programmer's Guide assumes basic knowledge of SQL.

To learn to write Striim applications, continue with Programmer's Guide.