Striim 4.0.4 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

Targets include

  • Amazon S3

  • Azure Blob Storage

  • HDFS

  • Incremental Batch Reader

  • MariaDB Initial Load (using Database Reader)

  • MSJet (for initial load for MSJet, use SQL Server Initial Load)

  • MariaDB Initial Load (using Database Reader)

  • MongoDB CDC (using MongoDB Reader in Incremental mode)

  • MongoDB Initial Load (using MongoDB Reader in Initial Load mode)

  • MySQL CDC

  • MySQL Initial Load (using Database Reader)

  • Oracle CDC

  • Oracle Initial Load (using Database Reader)

  • PostgreSQL CDC

  • PostgreSQL Initial Load (using Database Reader)

  • Salesforce

  • SQL Server CDCC

  • SQL Server Initial Load (using Database Reader)

  • Amazon Kinesis Data Streams

  • Amazon Redshift

  • Amazon S3

  • Apache Cassandra

  • Apache Hive - Cloudera

  • Apache Kudu

  • Azure Blob Storage

  • Azure Cosmos DB (after you configure the source and select schemas and tables, the wizard will prompt you to select the SQL, Cassandra, or MongoDB API)

  • Azure Data Lake Store Gen1

  • Azure Data Lake Store Gen2

  • Azure Event Hubs

  • Azure PostgreSQL

  • Azure SQL Database

  • Azure Synapse Analytics

  • BigQuery

  • Cloud SQL for MySQL

  • Cloud SQL for PostgreSQL

  • Cloud SQL for SQL Server

  • Database (see Database Writer for supported databases)

  • File (using File Writer)

  • Google Cloud Storage

  • Hazelcast Writer

  • HBase

  • HDInsight HDFS

  • HDInsight Kafka

  • Hortonworks Hive

  • JMS

  • JPAWriter

  • Kafka 0.8.0, 0.9.0, 0.10.0, 0.11.0, 2.1.0

  • MapR Streams

  • MariaDB

  • MongoDB

  • MQTT

  • MySQL (using DatabaseWriter)

  • Oracle Database (using DatabaseWriter)

  • PostgreSQL (using DatabaseWriter)

  • SAP HANA (using DatabaseWriter)

  • Singlestore (MemSQL)

  • Snowflake

  • Spanner

  • SQL Server (using DatabaseWriter)

  • Striim (app contains only the source)