Striim Migration Service for Google Cloud Documentation

Start streaming integration

  1. Select App Settings, enter 10 as the Recovery Interval, and click Save.

    RecoveryInterval.png
  2. Select the source, click Show optional properties, set the Start LSN to the value you recorded before creating the target tables, and click Save.

    StartLSN.png
  3. If the initial load included open transactions, the application might attempt to write rows that already exist in the target, which would cause it to crash. To avoid this, select the target, click Show optional properties, set Ignorable Exception Code to 23505, NO_OP_UPDATE, and click Save. (23505 is the PostgreSQL error code for unique_violation.)

    PGTargetIgnorableExceptionCode.png
  4. Select Created > Deploy App > Deploy., then when deploying is complete select Deployed > Start App.

  5. If you set Ignorable Exception Code, when you know all open transactions have completed and been written to the target, undeploy and stop the application, edit the target, clear the Ignorable Exception Code value, save, and deploy and start the application. Since recovery is enabled, writing will resume where it left off, and there will be no missing or duplicate rows.

Streaming integration is now complete.