Microsoft Teams Setup Guide Lite Private Preview

Follow our setup guide to connect Microsoft Teams to Fivetran.

Prerequisites

To connect Microsoft Teams to Fivetran, you need:

• a Microsoft Teams account
• a Microsoft Entra ID account
• a Microsoft Azure account with one of the following roles:
  • Application Administrator
  • Application Developer
  • Cloud Application Administrator

Setup instructions

Register application

1. Log in to the Microsoft Entra admin center.

2. On the navigation menu, go to Identity > Applications > App registrations.

3. Click + New registration.

4. Enter a Name for your application.

5. In the Supported account types section, select Accounts in this organizational directory only.

6. In the Redirect URI (optional) section, select Web in the drop-down menu.

   NOTE: Do not specify any redirect URI.

7. Click Register.

8. Make a note of the Application (client) ID and Directory (tenant) ID. You will need them to configure Fivetran.

Add API permissions

1. In the App registrations page, select the application you registered.

2. Click API permissions.

3. Click + Add a permission.

4. In the Microsoft APIs tab, click Microsoft Graph.

5. Click Application permissions.

6. Select the checkboxes for all the permissions that are mandatory for the connection.

   Expand for the list of mandatory permissions

   • User.Read.All
   • Directory.Read.All
   • CallRecords.Read.All
   • Calls.AccessMedia.All
   • Calls.Initiate.All
   • Calls.InitiateGroupCall.All
   • Calls.JoinGroupCall.All
   • Calls.JoinGroupCallAsGuest.All
   • Channel.ReadBasic.All
   • ChannelMember.Read.All
   • ChannelMessage.Read.All
   • ChannelSettings.Read.All
   • Chat.Read.All
   • Chat.ReadBasic.All
   • ChatMember.Read.All
   • ChatMessage.Read.All
   • Group.Read.All
   • GroupMember.Read.All
   • Presence.Read.All
   • OnlineMeetings.Read.All
   • OnlineMeetingArtifact.Read.All
   • OnlineMeetingTranscript.Read.All
   • OnlineMeetingRecording.Read.All
   • VirtualEvent.Read.All
   • Team.ReadBasic.All
   • TeamSettings.Read.All
   • TeamsTab.Read.All
   • TeamMember.Read.All
   • TeamworkTag.Read.All
   • User.Read.All
   • User.ReadBasic.All

7. Click Add permissions.

8. Click Grant admin consent for <application_name> and then select Yes.

Create client secret

1. In the App registrations page, select the application you registered.
2. Click Certificates & secrets.
3. Click + New client secret.
4. Enter a Description for the client secret.
5. In the Expires drop-down menu, select the expiry period for the client secret.
6. Click Add.
7. Make a note of the client secret Value. You will need it to configure Fivetran.

Finish Fivetran configuration

1. In the connection setup form, enter your chosen Destination schema name.
2. Enter the Tenant ID and Client ID of the application you registered.
3. Enter the Client secret you found.
4. (Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected in the Select an existing agent drop-down menu. To use a different agent, select the agent of your choice and then select the same agent for your destination.
5. Click Save & Test. Fivetran will take it from here and sync your Microsoft Teams data.

Related articles

description Connector Overview

account_tree Schema Information

settings API Connection Configuration

home Documentation Home