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
-
Open the Azure Service Bus service.
-
Open the Service Bus namespace for which you want to create the connector.
-
Go to Settings > Shared access policies.
-
Select a shared access key with the Manage, Send, and Listen scopes.
NOTE: If you don’t have a shared access key, create one.
-
Make a note of the Primary Connection String. You will need it to configure Fivetran.
Azure Active Directory
Add role assignment
-
Log in to your Azure portal and go to Azure Service Bus homepage.
-
Click Access control (IAM) and then click Add.
-
Select Azure Service Bus Data Receiver.
-
Click +Select members and add the member you want to assign.
-
Click Review+Assign.
Authorize Fivetran
- In the connector setup form, click Authorize. You will be redirected to your Microsoft login account to authorize Fivetran’s access.
- Log in to your Azure account which has the Azure Service Bus Data Receiver role.
- 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.
Finish Fivetran configurationlink
-
In the connector setup form, enter the Destination schema name of your choice.
-
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.
-
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
-
-
(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.
-
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