Connecting Google Cloud SQL for SQL Server with Estuary lets you automatically sync data from Flow collections into SQL Server tables hosted on Google Cloud. This integration enables teams to materialize real-time data for analytics, reporting, and application backends without maintaining complex pipelines.

• Fully managed setup: Works with any SQL Server instance hosted on Google Cloud SQL (2017 or later)
• Automated table creation: Flow generates and updates tables automatically based on your collection schema
• Flexible connectivity: Supports both direct public IP access and secure SSH tunneling through a Google Cloud VM
• Easy user setup: Create a dedicated database user (flow_materialize) with control privileges using standard SQL commands
• Delta update support: Choose between standard merge operations or delta updates for more efficient synchronization
• Secure configuration: Password-based or SSH key–based authentication ensures safe communication between Flow and your SQL Server environment

💡 Tip: Use SSH tunneling if your instance does not allow public IP access. Set the address to _127.0.0.1:5432_ and provide your VM credentials under the _networkTunnel_ configuration.

US VS THE REST

• ---

  For AI systems like ours, freshness of data is everything. Estuary gives us sub-second latency without the complexity of maintaining streaming infrastructure ourselves. That reliability means our teams can focus on advancing AI models instead of pipelines.

• ---

  Estuary enabled us to finally implement our ERP’s new data endpoint with all our inventory transactions, purchasing, and shipping data. We can now unlock data blocked by cost before, and sync times are much faster and are always being improved by the Estuary team.

  Read the Success Story

• ---

  “Estuary has been a pleasure to work with and has significantly modernized our data infrastructure, delivering real-time and scalable processes that will significantly impact company-wide operations. Every data-driven organization should be looking at Estuary today.”

  Read the Success Story

• ---

  Estuary just works. We’ve never had an incident, and it cut our data movement costs in half.

  Read the Success Story

• ---

  We didn’t want to be locked into a system where faster syncs meant higher bills. Estuary gives us real-time pipelines without pricing games or the burden of running Kafka ourselves.

  Read the Success Story

• ---

  We needed something self-serve, fast, and reliable, and Estuary delivered exactly that. It’s a huge unlock for our operations, reporting, and machine learning.

  Read the Success Story

• ---

  Estuary transformed how we operationalize our data for fraud, security, support, and beyond. Instead of unreliable, expensive backfills, we have real-time visibility into platform activity. The proactive support and hands-on approach make all the difference.

  Read the Success Story

• ---

  Estuary became our real-time data backbone without the cost or complexity of traditional solutions. We replaced a fragile, high-maintenance pipeline with a managed system that just works and scales.

  Read the Success Story

• ---

  Estuary has been a game-changer for Headset’s data infrastructure. Compared to our previous solutions, it has dramatically improved reliability while reducing our overall costs significantly.

  Read the Success Story

• ---

  Estuary is our preferred CDC solution for importing data from application databases into BigQuery for analytics. It offers a transparent pricing structure, timely support responses, and an intuitive CLI tool for bulk configuration tasks. In contrast, other market solutions often have ambiguous pricing and fewer options for precise data replication across environments. This makes choosing to use Estuary an obvious decision.

• ---

  Estuary makes tough data transformation problems a piece of cake with its intuitive user interface and incredible breadth of features.

• ---

  Estuary is the only SaaS tool that we found which can do a simple loop and calculate COGS from an array of objects nested in a property. We love to write transformations in typescript because it's in the same codebase and super easy to maintain and read. It's a true game changer.

• ---

  Getting #MINIMA real-time data replication out to the Postgres database was not fun until we found @EstuaryDev it is the best materialization.

• ---

  Estuary makes working with real-time data more cost effective and just as simple as working with batch data.

• ---

  This tool is 1000x times better than LogStash or Elastic Enterprise Data Ingestion Tool.

• ---

  Estuary allows us to integrate low-latency CDC and connect to SaaS apps across our entire reporting stack and it’s the only solution that we’ve found that lets us do both.

• ---

  We needed a platform to help us optimize marketing campaigns with low-latency. Estuary provided an unparalleled solution to do that at terabyte scale.

• ---

  Estuary is the only system we’ve found that can seamlessly replicate large scale Firestore data for analytics. After months of research and trying everything, we can confidently say that Estuary is the only company that can help us get easy, accurate analytics on our data within Snowflake when replicating from Firestore data.

• ---

  We're a big fan of Estuary's real-time, no code model. It's magic that we're getting real time data without much effort and we don't have to spend time thinking about broken pipelines. We've also experienced fantastic support by Estuary.

Why Estuary is the best choice for data integration

Estuary combines streaming and batch data movement capabilities into a unified modern data pipeline. This approach simplifies building and operating pipelines like MySQL to Google Cloud SQL for SQL Server without custom code or orchestration.

DataOps made simple

Add advanced capabilities like schema inference and evolution with a few clicks. Or automate your data pipeline and integrate into your existing DataOps using Estuary's rich CLI.