Striim Azure Synapse Analytics Marketplace Offering Install Guide

This quickstart assumes that you already have a preexisting instance of Azure Synapse Analytics.

1. Search for Striim in the Azure Marketplace, and select the "Striim for Data Integration to Azure Synapse Analytics (Staged)" option.

2. Configure the Striim Azure Virtual Machine (VM) with specified properties, noting down the Striim cluster name, password, and admin password.

3. Once deployed, select <VM Name>-masternode in the Azure portal, select Connect, and copy the sign in using VM local account.

4. Download the Microsoft JDBC Driver for SQL Server. Use the latest supported version specified by Striim. Install to your local machine.

5. Open a command-line window, and change directories to where you downloaded the JDBC driver. SCP the driver file to your Striim VM, getting the address and password from the Azure portal.

6. Open another command-line window, or use an ssh utility to ssh into the Striim cluster.

   

7. Execute the following commands to move the file into Striim's lib directory, and start and stop the server.

   1. sudo su
   2. cd /tmp
   3. mv sqljdbc42.jar /opt/striim/lib
   4. systemctl stop striim-node
   5. systemctl stop striim-dbms
   6. systemctl start striim-dbms
   7. systemctl start striim-node

   

8. Now, open your favorite browser and navigate to <DNS Name>:9080.

   

9. Sign in with the username and the password you set up in the Azure portal, and select your preferred wizard to get started, or go to the Apps page to start using the drag and drop UI.

   

Related content

• Blog: Enabling real-time data warehousing with Azure SQL Data Warehouse
• Blog: Announcing Striim Cloud integration with Azure Synapse Analytics for continuous data integration