Striim Migration Service for Google Cloud Documentation

Create and test the initial load application

Before following these instructions, SMSGC, the Oracle source database, and the Cloud Spanner target database must be running.

You will need the following information to complete the wizard:

  • Oracle (source)

    • connection URL in the format <IP address>:<port>:<SID>, for example, 198.51.100.0:1521:orcl

    • login name and password

    • source table names

  • Google Spanner (target)

    • path and name of the service account key you uploaded to the SMSGC VM

    • SMSGC VM instance ID (note that this may not be the same as the instance name)

    • target table names

  1. Go to the SMSGC deployment page, copy the admin password (this randomly generated "temporary" password should be quite secure), click Visit the site, and log in using the username admin and the password from the deployment page.

  2. Find and select Oracle Database to Spanner.

  3. Enter the name for your application (for example, InitialLoadApp) and click Save.

  4. Upload the Oracle JDBC driver ojdbc8.jar. (You can download it from Oracle's JDBC downloads page.)

  5. Enter the following source properties, then click Next.

    • Hostname: the IP address or network name of the Oracle server, or, for Amazon RDS for Oracle, the endpoint (in AWS Management Console, you can find the endpoint name at Instance Actions > see details)

    • Port: the port for the Oracle server connection

    • Username: the login name for the user created as described in Create an Oracle user for SMSGC

    • Password: the password for that login

    • SID: the SID for the Oracle server connection, such as orcl or XE, or, if using Amazon RDS for Oracle, the database name. If using Oracle 12c with PDB, use the SID for the CDB service.

  6. If SMSGC's checks show that all properties are valid (this may take a few minutes), click Next. Otherwise, click Back and correct the properties.

  7. Select the schemas to migrate, then click Next.

  8. If the schemas' metadata validates correctly, click Next.

  9. Select the tables to migrate, then click Next.

  10. Enter the following target properties, then click Next.

    • Service Account Key: path and name of the service account key you uploaded to the SMSGC VM

    • Instance ID: the instance ID can be found on the Spanner Instance details page.

    • Tables: pairs of source and target tables separated by commas. This will be automatically set based on the source Tables setting. For example, if the source setting is HR.%, this will be set to HR.%,HR.%. If the source setting is HR.DEPARTMENTS;H4.EMPLOYEES, this will be set to HR.DEPARTMENTS,HR.DEPARTMENTS;H4.EMPLOYEES,H4.EMPLOYEES. If the target schema or table names are not the same as those in the source, edit this to match. If you prefer, you may finish creating the application and edit the Tables setting later.

  11. Click Next. SMSGC will create your application and open it in the Flow Designer.

  12. Deploy and start the application.

    deploy.png
    start.png

As described in the User Guide, you may Monitor application progress and if necessary troubleshoot the application. Stop the application whenever enough data has been written to verify that initial load is working as expected. The next step is to Create and test the initial load application.