Striim Product Demo – PostgreSQL To Cloud SQL For PostgreSQL

In this demo, you are going to see how you can use Striim to continuously move data from PostgreSQL on-premise to Google Cloud SQL for PostgreSQL. We will show you how to use Striim’s wizards and intuitive UI to build data flows; run the data flows to collect data from PostgreSQL using Change Data Capture, and deliver it in real-time to Cloud SQL for PostgreSQL; and see continuous monitoring of your cloud migration solution.

Video Transcription:

In this demo, you are going to see how you can use Striim to continuously move data from PostgreSQL on-premise to Google Cloud SQL for PostgreSQL. We will show you how to use Striim’s wizards and intuitive UI to build data flows; run the data flows to collect data from PostgreSQL using Change Data Capture, and deliver it in real-time to Cloud SQL for PostgreSQL; and see continuous monitoring of your cloud migration solution.

Performing streaming data integration with Striim starts with our wizards. We will select PostgreSQL as the source, and Cloud SQL for PostgreSQL as the target. After clicking the wizard and entering a name for our data flow, you just need to complete a few simple steps.

First, you will configure the source. Enter the necessary information to connect to the source and click on next. Don’t worry, any secure information like passwords is encrypted. The wizard will check that the connection information is correct, and that the connection has the correct privileges and supports change data capture. Finally you need to configure the target connection information, including how the source data is mapped to target tables. 

When you complete the wizard, a data flow is created from the information you entered. You can see the source and target configuration here. To start the data flow, first deploy it to get it ready to run, then start it to begin collecting data from PostgreSQL and delivering it to Cloud SQL for PostgreSQL

Initially, there is no data flowing, because we are not generating any new data in PostgreSQL. You can see from the UI for Cloud SQL for PostgreSQL that there is no data present in any of the target tables. 

Now we will run a data generator for PostgreSQL that creates a set of inserts, updates and deletes. You can see the data in the data flow preview window, and view the rate of data collection and delivery in the UI. We can also look at the application progress here to see a summary view of your tables. After a number of operations have been generated, we can check back with the Cloud SQL for PostgreSQL UI and see the data in the target tables.

Of course, Striim can perform initial loads as well through similar data flows. Here we are moving a million rows from tables in PostgreSQL to Cloud SQL for PostgreSQL using our smart delivery pipeline. You can monitor the progress through the Striim UI, and, if we switch to the Cloud SQL for PostgreSQL UI, you can see the data in the target.

We can also use the Striim monitor UI to look at overall metrics, and drill down to see the application statistics, and detailed information for each of the application components.

This has been a quick demo of using Striim to deliver data continuously from PostgreSQL to Cloud SQL for PostgreSQL. Please go to our website to try Striim yourself, find Striim in the Google Cloud Marketplace, or contact us to learn more.