Requirements

Datastream offers a variety of source options, destination options, and networking connectivity methods.

In this quickstart, we assume that you're using a standalone Oracle database and a destination Cloud Storage service. For the source database, you should be able to configure your network to add an inbound firewall rule. The source database can be on-premises or in a cloud provider. Because the destination is Cloud Storage, it should be in Google's cloud provider.

Because we can't know the specifics of your environment, we can't provide detailed steps when it comes to your networking configuration.

For this quickstart, you'll select IP allowlisting as the connectivity method. IP allowlisting is a security feature often used for limiting and controlling access to the data in your source database to trusted users. You can use IP allowlists to create lists of trusted IP addresses or IP ranges from which your users and other Cloud services such as Datastream can access this data. To use IP allowlists, you must open the source database or firewall to incoming connections from Datastream.

Create connection profiles

By creating connection profiles for a source database and a destination, you're creating records that contain information about the source and the destination.

In this quickstart, you'll select Oracle as the profile type for your source connection profile, and Cloud Storage as the profile type for your destination connection profile. Datastream uses the information in the connection profiles to migrate data from the source Oracle database into a destination bucket in Cloud Storage.

Create a source connection profile for Oracle database

1. Go to the Connection profiles page for Datastream in the Google Cloud Console.

   Go to the Connection profiles page

2. Click CREATE PROFILE.

3. In the Create a connection profile page, click the Oracle profile type (because you want to create a source connection profile for Oracle database).

4. Supply the following information in the Define connection settings section of the Create Oracle profile page:

   • Enter My Source Connection Profile as the Connection profile name for your source database.
   • Keep the auto-generated Connection profile ID.

   • Select the Region where the connection profile will be stored.

   • Enter Connection details:

     • In the Hostname or IP field, enter a hostname or public IP address that Datastream can use to connect to the source Oracle database. You're providing a public IP address because IP allowlist will be used as the network connectivity method for this quickstart.
     • In the Port field, enter the port number that's reserved for the source database. For an Oracle database, the default port is typically 1521.
     • Enter a Username and Password to authenticate to your source database.
     • In the System identifier (SID) field, enter the SID or service name that identifies the database instance. For Oracle databases, this is typically ORCL.

5. In the Define connection settings section, click CONTINUE. The Define connectivity method section of the Create Oracle profile page is active.

6. Choose the networking method that you'd like to use to establish connectivity between Datastream and the source database. For this quickstart, use the Connectivity method drop-down menu to select IP allowlisting as the networking method.

7. Configure your source database to allow incoming connections from the Datastream public IP addresses that appear.

8. In the Define connectivity method section, click CONTINUE. The Test connection profile section of the Create Oracle profile page is active.

9. Click RUN TEST to verify that the source Oracle database and Datastream can communicate with each other.

10. Verify that the "Test passed" status appears.

11. If the test fails, you can address the problem in the appropriate part of the flow, and then return to re-test. Refer to the Diagnose issues page for troubleshooting steps.

12. Click CREATE.

Create a destination connection profile for Cloud Storage

1. Go to the Connection profiles page for Datastream in the Google Cloud Console.

   Go to the Connection profiles page

2. Click CREATE PROFILE.

3. In the Create a connection profile page, click the Cloud Storage profile type (because you want to create a destination connection profile for Cloud Storage).

4. Supply the following information in the Create Cloud Storage profile page:

   • Enter My Destination Connection Profile as the Connection profile name for your destination Cloud Storage service.
   • Keep the auto-generated Connection profile ID.
   • Select the Region where the connection profile will be stored.
   • In the Connection details pane, click BROWSE.

   • In the Select bucket pane, select the destination bucket in Cloud Storage into which Datastream will transfer data from the source database, and then click SELECT.

     Your bucket appears in the Bucket name field of the Create Cloud Storage profile page.

   • Optionally, in the Connection profile path prefix field, you can provide a prefix for the path that will be appended to the bucket name when Datastream transfers data to the destination.

5. Click CREATE.

After creating a source connection profile for Oracle database and a destination connection profile for Cloud Storage, you can use them to create a stream.

Create a stream

In this section, you create a stream. Datastream uses this stream to transfer data from a source Oracle database to a destination bucket in Cloud Storage.

Creating a stream includes:

• Defining settings for the stream.
• Selecting the connection profile that you created for your source database (the source connection profile). For this quickstart, this is My Source Connection Profile.
• Configuring information about the source database for the stream by specifying the tables and schemas in the source database that Datastream:
  • Can transfer into the destination.
  • Is restricted from transferring into the destination.
• Determining whether Datastream will backfill historical data, as well as stream ongoing changes into the destination, or stream only changes to the data.
• Selecting the connection profile that you created for Cloud Storage (the destination connection profile). For this quickstart, this is My Destination Connection Profile.
• Configuring information about the destination bucket for the stream. This information includes:
  • The folder of the destination bucket into which Datastream will transfer schemas, tables, and data from a source Oracle database.
  • The output format of files written to Cloud Storage. Datastream currently supports two output formats: Avro and JSON. For this quickstart, Avro is the file format.

Define settings for the stream

1. Go to the Streams page for Datastream in the Google Cloud Console.

   Go to the Streams page

2. Click CREATE STREAM.

3. Supply the following information in the Define stream details panel of the Create stream page:

   • Enter My Stream as the Stream name.
   • Keep the auto-generated Stream ID.
   • From the Region menu, select the region where you created your source connection profile.
   • From the Source type menu, select the Oracle profile type.
   • From the Destination type menu, select the Cloud Storage profile type.

4. Review the required prerequisites that are generated automatically to reflect how your environment must be prepared for a stream. These prerequisites can include how to configure the source database and how to connect Datastream to the destination bucket in Cloud Storage.

5. Click CONTINUE. The Define Oracle connection profile panel of the Create stream page appears.

Specify information about the source connection profile

1. From the Source connection profile menu, select your source connection profile for Oracle database.

2. Click RUN TEST to verify that the source database and Datastream can communicate with each other.

   If the test fails, then the issue associated with the connection profile appears. Refer to the Diagnose issues page for troubleshooting steps. Make the necessary changes to correct the issue, and then retest.

3. Click CONTINUE. The Configure stream source panel of the Create stream page appears.

Configure information about the source database for the stream

1. Use the Objects to include menu to specify the tables and schemas in your source database that Datastream can transfer into a folder in the destination bucket in Cloud Storage. The menu only loads if your database has up to 5,000 objects.

   For this quickstart, you want Datastream to transfer all tables and schemas. Therefore, select All tables from all schemas from the menu.

2. Click CONTINUE. The Define Cloud Storage connection profile panel of the Create stream page appears.

Select a destination connection profile

1. From the destination connection profile menu, select your destination connection profile for Cloud Storage.

2. Click CONTINUE. The Configure stream destination panel of the Create stream page appears.

Configure information about the destination for the stream

1. In the Stream path prefix field, enter the folder of the destination bucket into which Datastream will transfer schemas, tables, and data from a source Oracle database.

   For this quickstart, you want Datastream to transfer data from the source database into the /root/tutorial folder in the destination bucket of Cloud Storage. Therefore, enter /root/tutorial in the Stream path prefix field.

2. In the Output format field, select the format of files written to Cloud Storage. For this quickstart, Avro is the file format.

3. Click CONTINUE. The Review stream details and create panel of the Create stream page appears.

Create the stream

1. Verify details about the stream as well as the source and destination connection profiles that the stream will use to transfer data from a source Oracle database to a destination bucket in Cloud Storage.

2. Click RUN VALIDATION to validate the stream. By validating a stream, Datastream checks that the source is configured properly, validates that the stream can connect to both the source and the destination, and verifies the end-to-end configuration of the stream.

3. After all validation checks pass, click CREATE.

4. In the Create stream? dialog box, click CREATE.

After creating a stream, you can start it.

Start the stream

In the previous section of the quickstart, you created a stream, but you didn't start it. You can do this now.

For this quickstart, you create and start a stream separately in case the stream creation process incurs an increased load on your source database. To put off that load, you create the stream without starting it, and then start the stream when the load can be incurred.

By starting the stream, Datastream can transfer data, schemas, and tables from the source database to the destination.

1. Go to the Streams page for Datastream in the Google Cloud Console.

   Go to the Streams page

2. Select the check box to the left of the stream that you want to start. For this quickstart, this is My Stream.

3. Click START.

4. In the dialog box, click START. The status of the stream changes from Not started to Starting to Running.

After starting a stream, you can verify that Datastream transferred data from the source database to the destination.

Verify the stream

In this section, you confirm that Datastream transfers the data from all tables of your source Oracle database into the /root/tutorial folder of your Cloud Storage destination bucket.

1. Go to the Streams page for Datastream in the Google Cloud Console.

   Go to the Streams page

2. Click the stream that you created. For this quickstart, this is My Stream.

3. In the Stream details page, click the link that appears below the Destination write path field. The Bucket details page of Cloud Storage opens in a separate tab.

4. Verify that you see folders that represent tables of your source Oracle database.

5. Click one of the table folders and drill down until you see data that's associated with the table.