Setting Up Azure Synapse Analytics as a Target

Overview

Welcome to Getting Started with Rivery and Azure Synapse Analytics.

This guide will show you how to prepare your Azure environment for Rivery, create an Azure Blob storage for Azures's stage area, and how to set the right credentials for using Rivery. At the end of this guide, you will be able to connect to Azure Synapse Analytics from Rivery.

Preparing your Azure environment for Rivery

To set Azure Synapse Analytics as a target, Rivery requires creating or managing some Azure resources.

Prerequisites:

If you are missing one of the prerequisites above, use the guide below to fill in the gaps.

This guide will cover the following:

1. Creating an Azure account:
If you don't have an Azure account, you can follow the steps detailed here to create one.

2. Creating Subscription:
Azure subscription is the main billing and tiers accounts. You must have one to work with any resource at Azure portal or environment.

If you do not have a subscription in Azure, you can create it:

3. Creating a Resource Group
Resource Group is a semantic group in Azure, which lets you manage and define your permissions, users and the resources under it. Rivery requires the use of a Resource Group. If you don't have one already, please create it by following the below steps.

Important: Create a specific new Resource Group for Rivery. It will let you manage the users, permissions, and resources that Rivery will use, and watch the capacity and usage of the resource. The Resource Group name must be Rivery .

4. Create a Blob Storage Account and Blob Storage Container

Follow the instructions here to set your own custom blob storage account.

5. Create an Azure Synapse Analytics

Follow the instructions detailed here to create your warehouse. Use the information detailed in the previous steps such Subscription and Resource group when needed.

Setting up the Azure Synapse Analytics

Create a Rivery user on the Azure Synapse Analytics

Using a client or via the Azure portal, connect to your Microsoft Azure Synapse Analyticsinstance.

Navigate to the master database and execute the following command (don't forget to replace the <password> with a strong password value):

CREATE LOGIN rivery WITH PASSWORD = '<password>';
CREATE USER rivery FOR LOGIN rivery;

Navigate to the warehouse and enter the following commands:

CREATE USER rivery FOR LOGIN rivery;
GRANT CONTROL ON DATABASE::<DATABASE_NAME> to rivery;

Whitelist Rivery IP addresses on Azure
If you are not using a connection via an SSH Tunnel you will need to Whitelist our IPs.

Create a connection in Rivery

To find your host name, do the following:

1. Sign in to the Azure portal .

2. Select SQL Data warehouses from the left-hand menu, and click your data warehouse on the SQL data warehouses page.

3. In the Essentials pane in the Azure portal page for your database, locate and then copy the Server name .

Additional information can be found here .

Creating the connection :

1. Log into Rivery.

2. Create a new connection for Azure Synapse Analytics:

   1. Go to Connections.

   2. Click on New Connection .

   3. From the source list, choose ** Azure Synapse Analytics **

   4. Enter the credential information created in the prior steps.
      * Host.
      * Database.
      * Azure Synapse Analytics user name.
      * Azure Synapse Analytics password.

5. You can either set a Custom File Zone to have the data save in your own staging area or use our default FileZone.

6. You can test your connection by clicking Test Connection.

7. Save the connection .

Limitations

Connecting to Azure serverless instance is currently not supported.