How to Create an Azure App for SharePoint/OneDrive Connector in Match Data Pro (On-Prem)

This step-by-step guide helps Microsoft 365 administrators configure an Azure application for Match Data Pro’s SharePoint and OneDrive connector. This app allows you to securely connect your data sources using the Microsoft Graph API.

What You’ll Need

• A Microsoft Azure account with admin access

• Access to Azure Active Directory (Azure AD)

• The MDP On-Prem instance ready for configuration

 

Step 1: Go to Azure Portal

1. Open https://portal.azure.com

2. On the main page locate the  “App registrations” icon

 

Step 2: Register a New Application

1. Under Manage, click “App registrations”

2. Click “New registration”

3. Fill in the following:

   1. Name: MDP Onedrive_Sharepoint

   2. Supported account types: Choose Accounts in this organizational directory only

   3. Redirect URI (optional for now): Leave blank

4. Click Register

 

Step 3: Capture the Credentials

After registration, you will be taken to the app overview page. Copy and save:

• Application (client) ID → This is the App Key

• Directory (tenant) ID → This is the Tenant ID

You will enter these values in Match Data Pro later.

 

Step 4: Create a Client Secret

1. In the app page sidebar, click “Certificates & secrets”

2. Under Client secrets, click “New client secret”

3. Description: MDP SharePoint Connector

4. Expiry: Choose your preferred option (e.g., 12 months)

5. Click “Add”

6. Copy the Value immediately. This is your App Secret. Save it securely!

Step 5: Set Required API Permissions

1. In the app page sidebar, click “API permissions”

2. Click “Add a permission” → Choose Microsoft Graph

3. Select Delegated permissions and add:

   • User.Read

   • openid

   • profile

   • offline_access

   • Files.ReadWrite

   • Sites.Read.All

   • Sites.ReadWrite.All

   • Directory.Read.All

4. Click “Add permissions”

Step 6: (Optional) Grant Admin Consent

1. Back on the API permissions page

2. Click “Grant admin consent for [Your Org]”

This is required if your tenant doesn’t allow users to self-consent.

Step 7: Enter Credentials in Match Data Pro

1. Log in to your Match Data Pro On-Prem instance

2. Go to Settings → Cloud Integrations → Microsoft Onedrive

3. Enter:

   • Tenant ID

   • App Key (Application ID)

   • App Secret (Client secret value)

4. Click Validated

5. Click Save

Once validated, you can now connect to any public or private SharePoint file using a shareable link or Microsoft Graph access.

Troubleshooting

• If you get permission errors, ensure admin consent is granted.

• Double-check that you copied the correct client secret value, not its ID.

• The user signing in via MDP must have permission to access the SharePoint file or folder.

• For additional help, please contact support@matchdatapro.com and we will be happy to assist

You’re All Set

You have successfully set up the Azure app for use with the MDP SharePoint/OneDrive connector.

Let us know if you want to generate a JSON config or automate token acquisition with MSAL.