Skip to main content
Documentation
Troubleshooting
Feature Requests Status

Azure Service Bus Setup Guide Private Preview

Edit on GitHub
  • Updated
Fivetran System User Fivetranner

Follow our setup guide to connect Azure Service Bus to Fivetran.

Prerequisiteslink

To connect Azure Service Bus to Fivetran, you need an Azure account with a Service Bus namespace.

NOTE: For more information, see Microsoft’s Service Bus namespace documentation.

Setup instructionslink

Select authentication methodlink

Select whether you want to authenticate using Connection String or Azure Active Directory.

Connection String

  1. Open the Azure Service Bus service.

  2. Open the Service Bus namespace for which you want to create the connector.

    Shared Access Policy

  3. Go to Settings > Shared access policies.

    Shared Access Key

  4. Select a shared access key with the Manage, Send, and Listen scopes.

    NOTE: If you don’t have a shared access key, create one.

  5. Make a note of the Primary Connection String. You will need it to configure Fivetran.

    Connection string-primary key

Azure Active Directory

Add role assignment

  1. Log in to your Azure portal and go to Azure Service Bus homepage.

  2. Click Access control (IAM) and then click Add.

    Add IAM Role

  3. Select Azure Service Bus Data Receiver.

    Data Receiver

  4. Click +Select members and add the member you want to assign.

  5. Click Review+Assign.

    Assign IAM Role

Authorize Fivetran
  1. In the connector setup form, click Authorize. You will be redirected to your Microsoft login account to authorize Fivetran’s access.
  2. Log in to your Azure account which has the Azure Service Bus Data Receiver role.
  3. Click Accept to authorize Fivetran’s read access to your service bus data. Once you have finished, you will be redirected back to Fivetran.

(Optional) Configure Azure Private Link BETAlink

IMPORTANT: You must have a Business Critical plan to use Azure Private Link.

Azure Private Link allows Virtual Networks (VNets) and Azure-hosted or on-premises services to communicate with one another without exposing traffic to the public internet. Learn more in Microsoft’s Azure Private Link documentation.

Follow our Azure Private Link setup guide to configure Private Link for your service bus.

If you want to connect to Fivetran through Azure Private Link, contact Fivetran Support for help. Provide your namespace’s Resource ID in your message so we can set up your private endpoint.

Resource ID Service Bus NameSpace

Finish Fivetran configurationlink

  1. In the connector setup form, enter the Destination schema name of your choice.

  2. Select the Authentication Method you want to use:

    • If you choose Connection String, enter the Connection String you found in Step 1.
    • If you choose Azure Active Directory, enter the Namespace of your Service Bus.

  3. Select your message type: Json, Avro, Protobuf, or Text.

    • If you choose Json, select a sync type: Packed or Unpacked.

    • If you choose Avro or Protobuf, enter the following schema registry credentials:

      • Schema Registry URLs
      • Schema Registry Key
      • Schema Registry Secret

  4. (Optional) Set the Enable Advanced Options toggle to ON, and then select your Connection Method: Direct or Connect via Private Link.

    NOTE: The Enable Advanced Options toggle and the Connection Method options are only available for Business Critical accounts.

  5. Click Save & Test. Fivetran will take it from here and sync your Azure Service Bus data.

    NOTE: Fivetran creates a Service Bus subscription for every connector with the name format fivetran_sub_<schema> in your Azure namespace.

Related Contentlink

description Connector Overview

account_tree Schema Information

settings API Connector Configuration

home Documentation Home

Was this article helpful?
0 out of 0 found this helpful
Return to top

Related articles

Didn’t find what you need?

Contact support