Move Real-Time Data to Azure Database for PostgreSQL

Striim runs in Azure Cloud and simplifies the real-time collection and movement of data from a wide variety of on-premises sources, including enterprise databases, log files, messaging systems, sensors, Hadoop and NoSQL solutions into Azure Database for PostgreSQL.

For real-time data ingestion from enterprise databases (including Oracle, SQL Server, HPE NonStop, MySQL, PostgreSQL, MongoDB, Amazon RDS for Oracle, and Amazon RDS for MySQL), Striim uses low-impact Change Data Capture (CDC). Striim can also process the data-in-motion before delivering to Azure Database for PostgreSQL with sub-second latency, providing full context for any downstream operations, such as reporting, analytical, and transactional processing.

Why Striim for Azure Database for PostgreSQL

Designed for high-volume environments, Striim offers a secure, reliable, and scalable service for continuous real-time data collection, preparation, and delivery to Azure Database for PostgreSQL. Striim uses low-impact CDC to avoid any modification or performance impact on source production systems.

It enables in-flight data filtering, transformation, aggregation, masking, and enrichment to increase productivity, minimize latency and on-premises ETL efforts. By rapidly setting up automated, real-time data pipelines, Azure customers can use their PostgreSQL database services for their business applications as well as for operational data stores and data marts in their analytical solutions. Striim enables users to synchronize partial data sets for reporting use cases and helps avoid batch movement inefficiencies.

Continuous Data Synchronization For

Zero Downtime Migration

  • Modernize legacy systems by continuously moving on-prem data to Azure databases for an eventual cut over for migration
  • Run the old on-prem and new Azure systems in parallel for a phased transition
  • Minimize migration risks via on-going testing of the new environment
  • Avoid data loss by using built-in database consistency verification
  • Receive alerts immediately when databases diverge