Skip to main content

Common Striim use cases

Striim is a distributed data integration and intelligence platform that can be used to design, deploy, and run data movement and data streaming pipelines. The following are common business applications for the Striim platform. (Note that these examples include just a small fraction of the thousands of source-target combinations Striim supports.)

  • Cloud adoption, including database migration, database replication, and data distribution. Popular data pipelines for this scenario include:

    • RDBMS to RDBMS, including from MariaDB, MySQL, HP NonStop, Oracle Database, PostgreSQL, or SQL Server to homogeneous or heterogeneous databases running on AWS, Google Cloud Platform, Microsoft Azure, or Oracle Cloud.

    • RDBMS to data warehouse, including from MariaDB, MySQL, HP NonStop, Oracle Database, PostgreSQL, or SQL Server to Amazon Redshift, Azure Synapse, Databricks, Google BigQuery, or Snowflake.

  • Hybrid cloud data integration, including on-premise to cloud, on-premise to on-premise, cloud to cloud, and cloud to on-premise topologies. Popular data pipelines for this scenario include:

    • RDBMS to RDBMS, including from MariaDB, MySQL, HP NonStop, Oracle Database, PostgreSQL, or SQL Server to homogeneous or heterogeneous databases running on AWS, Google Cloud Platform, Microsoft Azure, or Oracle Cloud.

    • RDBMS to queuing systems, including from MariaDB, MySQL, HP NonStop, Oracle Database, PostgreSQL, or SQL Server to Kafka or cloud-based messaging systems such as Amazon Kinesis, Azure Event Hub, or Google PubSub.

    • Queuing systems to RDBMS, including from Kafka to MariaDB, MySQL, HP NonStop, Oracle Database, PostgreSQL, or SQL Server.

    • RDBMS to cloud-based storage systems, including from MariaDB, MySQL, HP NonStop, Oracle Database, PostgreSQL, or SQL Server to Amazon S3, Azure Data Lake Storage, or Google Cloud Storage.

    • Cloud-based storage systems to RDBMS, including from Amazon S3 to MariaDB, MySQL, HP NonStop, Oracle Database, PostgreSQL, or SQL Server.

  • Digital transformation, including real-time data distribution, real-time reporting, real-time analytics, stream processing, operational monitoring, and machine learning. Popular use cases for this scenario include:

    • Real-time alerting and notification for CDC workloads (see the discussion of alerts in Running the CDC demo apps).Running the CDC demo apps

    • Streaming analytics using data windows (see Sample applications for programmers).

    • Running SQL-based continuous queries on moving data pipelines.

    • Creating real-time dashboards on CDC or Kafka workloads.