Migrate data to Azure Cosmos DB for Apache Cassandra account using Striim

APPLIES TO: Cassandra

The Striim image in the Azure marketplace offers continuous real-time data movement from data warehouses and databases to Azure. While moving the data, you can perform in-line denormalization, data transformation, enable real-time analytics, and data reporting scenarios. It’s easy to get started with Striim to continuously move enterprise data to Azure Cosmos DB for Apache Cassandra. Azure provides a marketplace offering that makes it easy to deploy Striim and migrate data to Azure Cosmos DB.

This article shows how to use Striim to migrate data from an Oracle database to an Azure Cosmos DB for Apache Cassandra account.

Prerequisites

Deploy the Striim marketplace solution

  1. Sign into the Azure portal.

  2. Select Create a resource and search for Striim in the Azure marketplace. Select the first option and Create.

    Find Striim marketplace item

  3. Next, enter the configuration properties of the Striim instance. The Striim environment is deployed in a virtual machine. From the Basics pane, enter the VM user name, VM password (this password is used to SSH into the VM). Select your Subscription, Resource Group, and Location details where you’d like to deploy Striim. Once complete, select OK.

    Configure basic settings for Striim

  4. In the Striim Cluster settings pane, choose the type of Striim deployment and the virtual machine size.

    Setting Value Description
    Striim deployment type Standalone Striim can run in a Standalone or Cluster deployment types. Standalone mode will deploy the Striim server on a single virtual machine and you can select the size of the VMs depending on your data volume. Cluster mode will deploy the Striim server on two or more VMs with the selected size. Cluster environments with more than 2 nodes offer automatic high availability and failover.

    In this tutorial, you can select Standalone option. Use the default “Standard_F4s” size VM.
    Name of the Striim cluster <Striim_cluster_Name> Name of the Striim cluster.
    Striim cluster password <Striim_cluster_password> Password for the cluster.

    After you fill the form, select OK to continue.

  5. In the Striim access settings pane, configure the Public IP address (choose the default values), Domain name for Striim, Admin password that you’d like to use to login to the Striim UI. Configure a VNET and Subnet (choose the default values). After filling in the details, select OK to continue.

    Striim access settings

  6. Azure will validate the deployment and make sure everything looks good; validation takes few minutes to complete. After the validation is completed, select OK.

  7. Finally, review the terms of use and select Create to create your Striim instance.

Configure the source database

In this section, you configure the Oracle database as the source for data movement. Striim server comes with the Oracle JDBC driver that's used to connect to Oracle. To read changes from your source Oracle database, you can either use the LogMiner or the XStream APIs. The Oracle JDBC driver is present in Striim's Java classpath to read, write, or persist data from Oracle database.

Configure target database

In this section, you will configure the Azure Cosmos DB for Apache Cassandra account as the target for data movement.

  1. Create an Azure Cosmos DB for Apache Cassandra account using the Azure portal.

  2. Navigate to the Data Explorer pane in your Azure Cosmos DB account. Select New Table to create a new container. Assume that you are migrating products and orders data from Oracle database to Azure Cosmos DB. Create a new Keyspace named StriimDemo with an Orders container. Provision the container with 1000 RUs(this example uses 1000 RUs, but you should use the throughput estimated for your workload), and /ORDER_ID as the primary key. These values will differ depending on your source data.

    Create API for Cassandra account

Configure Oracle to Azure Cosmos DB data flow

  1. Navigate to the Striim instance that you deployed in the Azure portal. Select the Connect button in the upper menu bar and from the SSH tab, copy the URL in Login using VM local account field.

    Get the SSH URL

  2. Open a new terminal window and run the SSH command you copied from the Azure portal. This article uses terminal in a MacOS, you can follow the similar instructions using an SSH client on a Windows machine. When prompted, type yes to continue and enter the password you have set for the virtual machine in the previous step.

    Connect to Striim VM

  3. From the same terminal window, restart the Striim server by executing the following commands:

    Systemctl stop striim-node
    Systemctl stop striim-dbms
    Systemctl start striim-dbms
    Systemctl start striim-node
    
  4. Striim will take a minute to start up. If you’d like to see the status, run the following command:

    tail -f /opt/striim/logs/striim-node.log
    
  5. Now, navigate back to Azure and copy the Public IP address of your Striim VM.

    Copy Striim VM IP address

  6. To navigate to the Striim’s Web UI, open a new tab in a browser and copy the public IP followed by: 9080. Sign in by using the admin username, along with the admin password you specified in the Azure portal.

    Sign in to Striim

  7. Now you’ll arrive at Striim’s home page. There are three different panes – Dashboards, Apps, and SourcePreview. The Dashboards pane allows you to move data in real time and visualize it. The Apps pane contains your streaming data pipelines, or data flows. On the right hand of the page is SourcePreview where you can preview your data before moving it.

  8. Select the Apps pane, we’ll focus on this pane for now. There are a variety of sample apps that you can use to learn about Striim, however in this article you will create our own. Select the Add App button in the top right-hand corner.

    Add the Striim app

  9. There are a few different ways to create Striim applications. Select Start from Scratch for this scenario.

    Start the app from scratch

  10. Give a friendly name for your application, something like oraToCosmosDB and select Save.

    Create a new application

  11. You’ll arrive at the Flow Designer, where you can drag and drop out of the box connectors to create your streaming applications. Type Oracle in the search bar, drag and drop the Oracle CDC source onto the app canvas.

    Oracle CDC source

  12. Enter the source configuration properties of your Oracle instance. The source name is just a naming convention for the Striim application, you can use a name such as src_onPremOracle. Also enter other details like Adapter type, connection URL, username, password, table name. Select Save to continue.

    Configure source parameters

  13. Now, click the wave icon of the stream to connect the target Azure Cosmos DB instance.

    Connect to target

  14. Before configuring the target, make sure you have added a Baltimore root certificate to Striim's Java environment.

  15. Enter the configuration properties of your target Azure Cosmos DB instance and select Save to continue. Here are the key parameters to note:

    • Adapter - Use DatabaseWriter. When writing to Azure Cosmos DB for Apache Cassandra, DatabaseWriter is required. The Cassandra driver 3.6.0 is bundled with Striim. If the DatabaseWriter exceeds the number of RUs provisioned on your Azure Cosmos DB container, the application will crash.

    • Connection URL - Specify your Azure Cosmos DB JDBC connection URL. The URL is in the format jdbc:cassandra://<contactpoint>:10350/<databaseName>?SSL=true

    • Username - Specify your Azure Cosmos DB account name.

    • Password - Specify the primary key of your Azure Cosmos DB account.

    • Tables - Target tables must have primary keys and primary keys can not be updated.

    Screenshot that shows the configurable target properties.

    Configure target properties

  16. Now, we’ll go ahead and run the Striim application. In the upper menu bar select Created, and then Deploy App. In the deployment window you can specify if you want to run certain parts of your application on specific parts of your deployment topology. Since we’re running in a simple deployment topology through Azure, we’ll use the default option.

    Deploy the app

  17. Now, we’ll go ahead and preview the stream to see data flowing through the Striim. Click the wave icon and click the eye icon next to it. After deploying, you can preview the stream to see data flowing through. Select the wave icon and the eyeball next to it. Select the Deployed button in the top menu bar, and select Start App.

    Start the app

  18. By using a CDC(Change Data Capture) reader, Striim will pick up only new changes on the database. If you have data flowing through your source tables, you’ll see it. However, since this is a sample table, the source that isn’t connected to any application. If you use a sample data generator, you can insert a chain of events into your Oracle database.

  19. You’ll see data flowing through the Striim platform. Striim picks up all the metadata associated with your table as well, which is helpful to monitor the data and make sure that the data lands on the right target.

    Set up the CDC pipeline

  20. Finally, let’s sign into Azure and navigate to your Azure Cosmos DB account. Refresh the Data Explorer, and you can see that data has arrived.

By using the Striim solution in Azure, you can continuously migrate data to Azure Cosmos DB from various sources such as Oracle, Cassandra, MongoDB, and various others to Azure Cosmos DB. To learn more please visit the Striim website, download a free 30-day trial of Striim, and for any issues when setting up the migration path with Striim, file a support request.

Next steps