Striim 3.10.1 documentation

Creating apps using templates

Templates can make creating Striim applications faster and easier. Apps created with templates may be modified using Flow Designer or by exporting TQL, editing it, and importing the modified TQL.

Striim has templates for many source-target combinations. Which are available in your installation will vary depending on which licenses you have (contact Striim support for more information).

When you use a template, the app's exception store is enabled automatically. If you do not want an exception store, turn it off after you create the app (see CREATE EXCEPTIONSTORE).

Use the Search Templates tool on the App Wizard page to see which templates are available for a particular source or target.

Sources include:

  • file (FileReader)

  • Incremental Batch Reader (MySQL, Oracle, PostgreSQL, SQL Server using JDBC)

  • MongoDB (MongoReader)

  • Oracle CDC (OracleReader

  • PostgreSQL CDC (PostgreSQL Reader)

  • SQL Server CDC (MSSQLReader)

Targets include:

  • Azure Blob storage

  • Azure Cosmos DB

  • Azure Event Hub

  • Azure PostgreSQL

  • Azure SQL DB

  • Azure SQL Data Warehouse

  • Cassandra (using DatabaseWriter)

  • Cloudera Hive

  • database (see Database Writer for supported DBMSes)

  • file (using FileWriter)

  • Google BigQuery

  • Google Cloud SQL MySQL

  • Google Cloud SQL PostgreSQL

  • Google Cloud Storage

  • Hadoop (using HDFSWriter)

  • Hazelcast

  • HBase

  • Hive

  • Hortonworks Hive

  • JMS

  • JPA

  • Kafka 0.8, 0.9, 0.10, or 0.11

  • Kinesis

  • Kudu

  • MapR Streams

  • MemSQL

  • MQTT

  • MySQL (using DatabaseWriter)

  • Oracle (using DatabaseWriter)

  • PostgreSQL (using DatabaseWriter)

  • Amazon Redshift

  • Snowflake

  • Google Spanner

  • SQL Server (using DatabaseWriter)

  • Striim (app contains only the source)