connect azure blob storage to sharepoint online

Seamlessly Connect Azure Blob Storage to SharePoint Online

By Christopher Allen
AD

Seamlessly integrating Azure Blob Storage with SharePoint Online can enhance your data management, enabling you to leverage Microsoft's robust cloud services together. This cohesive setup allows for secure data storage in Azure while providing the collaborative and organizational features of SharePoint Online.

Due to the differences in these services - Azure Blob Storage for object storage and SharePoint Online for document management - a direct connection isn't natively supported. However, with the right tools and approaches, you can connect them to create a robust, efficient data ecosystem.

Understanding the Services

Before delving into the integration process, let's briefly understand the services involved.

AD
Move Data from On-Premise SQL Server to Azure Blob Storage Using Azure Data Factory | Towards Data Science
Move Data from On-Premise SQL Server to Azure Blob Storage Using Azure Data Factory | Towards Data Science
How to Connect Azure Blob Storage Artifacts to Spinnaker Pipelines
How to Connect Azure Blob Storage Artifacts to Spinnaker Pipelines
Create and access Blob Storage in Azure
Create and access Blob Storage in Azure

**Azure Blob Storage**: This service provides object storage, making it ideal for storing and serving images, videos, documents, and other unstructured data. It's scalable and cost-effective, storing data as blobs (large objects) in containers.

Blob Storage Types

Azure Blob Storage offers three types of blobs: block blobs (for files), append blobs (which can only be appended to), and page blobs (for disks and virtual hard disks).

Azure Storage Account And Storage Container For Blob Storage
Azure Storage Account And Storage Container For Blob Storage
Everything You Need to Know About Blob Storage in Azure
Everything You Need to Know About Blob Storage in Azure
Working With Blobs In Azure
Working With Blobs In Azure

**SharePoint Online**: This is a web-based collaborative platform that integrates with Microsoft Office for seamless document creation and sharing. It provides version control, change tracking, and permissions management, making it excellent for team collaboration and data sharing.

Connecting Azure Blob Storage to SharePoint Online

While SharePoint and Azure Blob Storage don't natively connect, there are workarounds using Azure Storage Explorer and PowerShell.

AD

A popular approach involves using Azure Storage Explorer to mount Azure Blob Storage as a network drive, which can then be mapped as a SharePoint library.

Copy Files From SharePoint To An Azure Blob Storage Using Microsoft Flow
Copy Files From SharePoint To An Azure Blob Storage Using Microsoft Flow
Azure Blob Storgae
Azure Blob Storgae
Building Snowpipe on Azure Blob Storage Using Azure Portal Web UI for Snowflake Data Warehouse | Towards Data Science
Building Snowpipe on Azure Blob Storage Using Azure Portal Web UI for Snowflake Data Warehouse | Towards Data Science
Searching Blob Documents with the Azure Search Service
Searching Blob Documents with the Azure Search Service
Push Blob Storage events to Azure Storage Table using Azure Function App | Microsoft Community Hub
Push Blob Storage events to Azure Storage Table using Azure Function App | Microsoft Community Hub
Azure Blob Storage setup for Veeam backup data
Azure Blob Storage setup for Veeam backup data

Mounting Azure Blob Storage as a Network Drive

Azure Storage Explorer allows you to work with studio blob storage using the File Explorer interface. Here's a basic breakdown:

1. Install and open Azure Storage Explorer.

AD

2. Connect to your Azure account.

Delete all the Azure Storage Blob content before N days using Logic App | Microsoft Community Hub
Delete all the Azure Storage Blob content before N days using Logic App | Microsoft Community Hub
Managing Large Files in Power Apps: Why Azure Blob Storage Is the Smarter Choice
Managing Large Files in Power Apps: Why Azure Blob Storage Is the Smarter Choice
Angular Dynamic CSS Loading from Azure Blob Storage
Angular Dynamic CSS Loading from Azure Blob Storage
An Overview Of Microsoft Azure Storage
An Overview Of Microsoft Azure Storage
How I Used Blob Storage to Host My Podcast | Envato Tuts+
How I Used Blob Storage to Host My Podcast | Envato Tuts+
How to Access Azure Storage Account File Shares from .NET Applications | CodeGuru
How to Access Azure Storage Account File Shares from .NET Applications | CodeGuru
How to Connect Azure AD Managed Identities to AWS Resources | Towards Data Science
How to Connect Azure AD Managed Identities to AWS Resources | Towards Data Science
How to Access Azure Storage Account File Shares from .NET Applications | CodeGuru
How to Access Azure Storage Account File Shares from .NET Applications | CodeGuru
How to create your own Deep Learning Project in Azure | Towards Data Science
How to create your own Deep Learning Project in Azure | Towards Data Science
Copy Data From Blob Storage To Cosmos DB Using Azure Data Factory
Copy Data From Blob Storage To Cosmos DB Using Azure Data Factory
Deploying a Storage Account in Azure using Asure Portal
Deploying a Storage Account in Azure using Asure Portal
How to Access Azure Storage Account File Shares from .NET Applications | CodeGuru
How to Access Azure Storage Account File Shares from .NET Applications | CodeGuru
Exploratory Data Analysis with Azure Synapse Analytics | Towards Data Science
Exploratory Data Analysis with Azure Synapse Analytics | Towards Data Science
Understanding Blob Storage - Part Nine - Implementing Blob Leasing
Understanding Blob Storage - Part Nine - Implementing Blob Leasing

3. Select your storage account.

4. Right-click on a container and select 'Mount.' This will mount the blob storage as a network drive.

AD

Mapping the Network Drive to SharePoint Online

Once the Azure Blob Storage is mounted, you can map it as a SharePoint library. To do this:

1. In SharePoint Online, create a new document library.

2. Click on 'From a local path,' then browse and select the mounted network drive.

3. Follow the prompts to finish setting up the library.

With these steps, you've successfully connected Azure Blob Storage to SharePoint Online, allowing for seamless data management and collaboration. This setup leverages the strength of both services, providing object storage with Azure and document management with SharePoint.

Looking ahead, consider exploring other integration options like using Azure Files for a similar setup, or implementing Azure Data Factory for more complex data pipelines. Regularly review and optimize your setup to ensure it continues to meet your organization's evolving needs.

AD