Microsoft Entra ID Setup Guide Lite

Follow our setup guide to connect Microsoft Entra ID to Fivetran.

Prerequisites

To connect Microsoft Entra ID to Fivetran, you need:

An active Azure account with any of the following roles:
- Application administrator
- Application developer
- Cloud application administrator role
An active Microsoft Entra ID account

Log in to your Microsoft Entra admin center.
On the navigation menu, go to Identity > Applications > App registrations.
Click +New registration.
Enter a Name for your application.
In the Supported account types section, select Accounts in this organizational directory only.
In the Redirect URI (optional) section, from the dropdown menu, select Web and enter a URI.
Click Register and make a note of the Application (client) ID and Directory (tenant) ID. You will need it to configure Fivetran.
On the app navigation menu, click API Permissions.
Click Add a permission, and select Microsoft Graph.
In the Request API permissions pane, click Azure Batch.
Click Application permissions.
Scroll down and select the following required permissions:
- User.Read.All
- GroupMember.Read.All
- TeamMember.Read.All
- Channel.ReadBasic.All
- Team.ReadBasic.All
- RoleManagement.Read.Directory
Click Add permissions.
Click Grant admin consent for <Application_name>, and then select Yes.

Select the application you registered in Step 1.
On the navigation menu, click Certificates & secrets and then click + New client secret.
In the Add a client secret pane, enter a Description for the client secret.
In the Expires drop-down menu, select an expiry period for the client secret.
Click Add.
Make a note of the client secret value. You will need it to configure Fivetran.

In the connector setup form, enter your chosen Destination schema name.
Enter the Tenant ID and Client ID you found in Step 1.
Enter the Client Secret you found in Step 2.
(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.
Click Save & Test. Fivetran will take it from here and sync your data from your Microsoft Entra ID account.