What's new in Striim Cloud 4.2.0

Looking for the Striim Platform documentation? Click here.

Striim Cloud Mission Critical is now available in Google Cloud and Microsoft Azure. See Introducing Striim Cloud Mission Critical.

The following features are new in Striim Cloud 4.2.0.4.

MariaDB Reader, MariaDB Xpand Reader, and MySQL Reader's Connection URL properties support the zeroDateTimeBehavior option.
When using MariaDB Xpand Reader, SkySQL's binlog_format can be default in the global configuration (see MariaDB setup.
Database Writer's Tables property supports the keycolumns() option.
In Azure Databricks, Databricks Writer supports serverless compute (see Learn / Azure Databricks documentation / Serverless compute) and personal staging locations in Azure (see Using an Azure personal staging location).

The following features are new in Striim Cloud 4.2.0.

Web UI

Resource usage policies can help prevent web UI slowdown (see Resource usage policies).
The Apps page has improvements in filtering, sorting, monitoring, and organizing apps.
ROUTER components may be created in the Flow Designer (see CREATE ROUTER).

Wizards support initial schema creation for Salesforce, Salesforce Pardot, and ServiceNow sources.
Schema evolution supports TRUNCATE TABLE for additional sources and targets (see Handling schema evolution).
Schema evolution supports ALTER TABLE ... ADD PRIMARY KEY. and ALTER TABLE ... ADD UNIQUE for MariaDB and MySQL (see Handling schema evolution).

Database Reader can use Azure private endpoints for Azure Database for MySQL (see Using Azure private endpoints).Database Reader
GCS Reader reads from Google Cloud Storage.
Salesforce Pardot Reader reads Salesforce Pardot sObjects.
Salesforce Reader supports JWT Bearer Flow authentication.
Azure Event Hub Writer can use Azure private endpoints (see Using Azure private endpoints).
ADLS Gen2 Writer can use Azure private endpoints (see Using Azure private endpoints).
BigQuery Writer supports parallel requests when using the Storage Write API and allows specifying HttpTransportOptions timeouts in TQL (see BigQuery Writer properties).
BigQuery Writer supports parallel requests when using the Storage Write API and allows specifying HttpTransportOptions timeouts in TQL (see BigQuery Writer properties).
Database Writer can use Azure private endpoints for Azure Database for MySQL (see Using Azure private endpoints).Database Writer
MongoDB Cosmos DB Writer can use Azure private endpoints (see Using Azure private endpoints).
MongoDB Writer:
- Supports exactly-once processing (see notes for the Checkpoint Collection property).
- Shard key updates have been added to the available Ignorable Exception Code property values.
- Can use Azure private endpoints (see Using Azure private endpoints).
ServiceNow Writer writes to tables in ServiceNow.

MongoDB Reader:
- Supports MongoDB versions up to 6.3.x.
- In Incremental mode, a single MongoDB Reader can read from an entire cluster using a +srv connection URL.
- With MongoDB 4.2 and later, reads from change streams (see MongoDB Manual > Change Streams) instead of the oplog.
- When reading from change streams, supports transactions and unset operations, and provides additional metadata.
- Can select documents based on queries (see Selecting documents using MongoDB Config).
- Can use Azure private endpoints (see Using Azure private endpoints).
MSJet supports compressed tables and indexes (see Learn / SQL / SQL Server / Enable Compression on a Table or Index).
MySQL Reader can use Azure private endpoints (see Using Azure private endpoints).
Oracle Reader supports Oracle Database 21c.

Resource usage policies can help prevent issues such as running out of memory or disk space to cause applications to halt (see Resource usage policies).
Cluster-level Smart Alerts can be modified in the web UI (see Managing Smart Alerts).
Vaults support Google Secrets Manager (see Using vaults).
You can configure access to the following endpoints using Google Private Service Connect (see Using Private Service Connect with Google Cloud adapters and Connecting to VMs or databases in Google Cloud using Private Service Connect):
- BigQuery
- Cloud SQL for MySQL
- Cloud SQL for Postgres
- Google Cloud Storage
- Spanner