How to Use Microsoft Graph Data Connect to Extract Data from Office 365 and Push to Azure Blob Storage – Part 1


Sathish Nadarajan
SharePoint MVP
Published On :   31 Oct 2018
Visit Count
Today :  7    Total :   312



In the earlier article, we saw what is a graph data connect and how to configure our tenant. In this article, let us walk through the simple steps to extract the data from Office 365 and push to blob storage.

As usual, let us see the step by step procedures.

1. Login to the Azure Portal with your Office 365 account.

clip_image002

2. Click on “Azure Active Directory”

clip_image004

3. Select “App registrations”

4. Click on “New App Registrations”

clip_image006

5. Enter the Values and Click on Create.

clip_image007

6. Once, got created, click on the “Settings”

clip_image009

7. Click on Owners and add the User Group which we created on the Earlier article.

clip_image011

8. In my case, I have added two users who has tenant admin access.

clip_image013

9. Go to Required Permissions Section.

clip_image015

10. Click on Add

clip_image017

11. Click on “Select API”

clip_image019

12. Select Graph on the list.

clip_image021

13. Select the appropriate permissions. In my case, I have selected all.

clip_image023

14. Now, the newly added permission will be listed. Now, click on the “Grant Permission”

clip_image025

clip_image027

15. Now, click on the “Keys” – This is very important as we are going to use these keys through out this exercise.

16. Enter the Description and the Expiry period and choose Save.

clip_image029

17. Copy the Keys to a Notepad, as we may not be able to see this Key once, we navigate out of this page.

clip_image031

18. Make a note of the Application ID as well.

clip_image033

19. With this, we are done with the Azure Active Directory Application Creation.

The first step is to create an Azure Active Directory Application which we have done just now. The next step is to create an Azure Blob Storage. Hope that does not require much explanation. The high-level steps are, create a Blob Storage and assign the Application which we created with required permissions. Hence, I am going with the screen shots.

clip_image035

clip_image037

clip_image039

clip_image041

Once, got created, select the Access Control.

clip_image043

Add appropriate users on it And the app which we created earlier.

clip_image045

clip_image047

Click on the Blobs and Create a new container.

clip_image049

clip_image051

With this, we are done with the Target.

Now, we are going to create the Azure Data Factory, which is the core engine.


image


We will see the Azure Data Factory Creation in the upcoming article.

Happy Coding,

Sathish Nadarajan.

Categories