Striim 3.10.2 documentation

Table of Contents

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)

  • MariaDB CDC (MariaDB Reader)

  • MongoDB CDC (Mongo Reader)

  • MySQL CDC (MySQL Reader)

  • MySQL JDBC (Database Reader)

  • Oracle CDC (Oracle Reader)

  • Oracle JDBC (Database Reader)

  • PostgreSQL CDC (PostgreSQL Reader)

  • PostgreSQL JDBC (Database Reader)

  • SQL Server CDC (MSSQL Reader)

  • SQL Server JDBC (Database Reader)

Targets include:

  • Azure Blob storage

  • Azure Cosmos DB

  • Azure Cosmos DB using Cassandra API

  • Azure Event Hub

  • Azure PostgreSQL

  • Azure SQL DB

  • Azure SQL Data Warehouse

  • Azure Data Lake Storage Gen1

  • Azure Data Lake Storage Gen2

  • Azure Database for PostgreSQL

  • Azure SQL Database

  • Azure Synapse Analytics

  • Cassandra

  • Cloudera Hive

  • database (see Database Writer for supported DBMSes)

  • file (using FileWriter)

  • Google BigQuery

  • Google Cloud SQL for MySQL

  • Google Cloud SQL for PostgreSQL

  • Google Cloud Storage

  • Hadoop (using HDFSWriter)

  • Hazelcast

  • HBase

  • Hive

  • Hortonworks Hive

  • JMS

  • JPA

  • Kafka 0.8, 0.9, 0.10, 0.11, 2.1.0

  • Kinesis

  • Kudu

  • MapR Streams

  • MariaDB

  • MemSQL

  • MongoDB

  • MQTT

  • MySQL (using DatabaseWriter)

  • Oracle (using DatabaseWriter)

  • PostgreSQL (using DatabaseWriter)

  • Amazon Redshift

  • Amazon S3

  • SAP HANA

  • Snowflake

  • Google Cloud Spanner

  • SQL Server (using DatabaseWriter)

  • Striim (app contains only the source)