Back to blog

Why Document Storage Matters in Dynamics 365

A side-by-side look at the three places Dynamics 365 documents can live—native attachments, SharePoint and Azure Blob Storage—with a feature matrix and guidance on when to use each.

Dec 19, 2023 10 min read

Overview of Document Storage Options in Dynamics 365

Microsoft Dynamics 365 data record with document attachments
A Dynamics 365 data record — the unit of work that drives every document-storage decision.

There are three ways to save Dynamics 365 documents.

1. Attachments in Dynamics 365

Attachments in Dynamics 365 provide a straightforward way to manage documents and files directly within the platform. For larger volumes, a Dynamics 365 SharePoint integration scales far better. One of the key strengths of the attachment feature is its ease of use. Users can quickly attach files to records without needing extensive training or technical knowledge. This built-in functionality allows teams to streamline their workflows, ensuring that relevant documents are readily accessible alongside critical data.

However, while the convenience of attachments is undeniable, there are notable limitations to consider. One major drawback is poor scalability; as the volume of attachments grows, performance can suffer, leading to slower load times and potential accessibility issues. Additionally, the searchability of attachments can be lacking, making it difficult for users to locate specific documents quickly. This can hinder productivity, especially in larger organizations where efficient information retrieval is crucial.

Moreover, the current attachment system lacks robust collaboration tools. While users can share files, the absence of integrated features for real-time collaboration can limit teamwork and communication. As businesses increasingly rely on collaborative efforts, this limitation can pose challenges in maintaining efficiency and cohesion among team members.

In summary, while attachments in Dynamics 365 offer a user-friendly solution for document management, organizations should weigh these strengths against the limitations of scalability, searchability, and collaboration. Understanding these factors can help teams make informed decisions about how best to utilize attachments within their Dynamics 365 environment.

2. Using SharePoint for Document Storage in Dynamics 365

Using SharePoint for document storage in Dynamics 365 can significantly enhance how organizations manage their files, particularly in terms of collaboration, organization, and searchability. SharePoint is especially ideal for teams that require seamless collaboration, as it allows multiple users to work on documents simultaneously. This real-time collaboration fosters a more dynamic workflow, enabling teams to gather feedback and make updates quickly, regardless of their physical locations.

The hierarchical structure that SharePoint offers is another compelling advantage. Users can create organized folders and subfolders, which helps maintain a clear and logical arrangement of documents. This structure not only simplifies the process of storing files but also makes it easier for team members to locate the documents they need without unnecessary hassle. Coupled with SharePoint's powerful search functionality, users can efficiently find files using keywords or metadata, significantly reducing the time spent searching for important documents.

However, there are challenges associated with using SharePoint for document storage in Dynamics 365. One notable issue is the dependency on the Document Management feature. For organizations to fully utilize SharePoint's capabilities, they must ensure that this feature is properly configured and understood by users. If not, teams may struggle to leverage the full potential of SharePoint, leading to frustration and inefficiencies.

Additionally, potential costs can be a concern. Implementing SharePoint may require additional investment, especially if advanced features or increased storage capacity are needed. Organizations must carefully evaluate these costs against the benefits to determine if the investment aligns with their overall business strategy.

By enabling the Document Management feature of D365, documents can be stored in SharePoint through the Dynamics 365 user interface. The standard feature of Dynamics 365 can be set up within a few minutes. There are a few points to consider before you activate the feature.

In summary, while SharePoint offers robust solutions for document storage in Dynamics 365, organizations should weigh its collaborative strengths and organizational capabilities against the challenges of dependency and costs. By doing so, they can make informed decisions that enhance their document management processes.

3. When to Use Azure Blob Storage for Dynamics 365 Documents

Azure Blob Storage is an excellent choice for organizations looking to manage their documents within Dynamics 365, particularly when it comes to archiving and addressing cost-sensitive needs. One of the primary reasons Azure Blob is suitable for archiving is its ability to handle large volumes of unstructured data efficiently. This makes it ideal for storing documents that may not require frequent access but need to be retained for compliance or historical purposes. Additionally, Azure Blob Storage operates on a pay-as-you-go pricing model, which can significantly reduce costs for businesses that need to store large amounts of data without incurring hefty upfront expenses.

However, there are downsides to consider when using Azure Blob Storage. One significant challenge is the requirement for custom development. Integrating Azure Blob with Dynamics 365 often necessitates additional coding and configuration to ensure that documents are stored and retrieved effectively. This can lead to increased development time and costs, particularly for organizations without in-house technical expertise.

Moreover, Azure Blob Storage may not be the best option for collaborative tasks. While it excels in storage capabilities, it lacks the built-in collaboration features found in platforms like SharePoint. This limitation can hinder teamwork, as users may find it challenging to work together on documents stored in Azure Blob without additional tools or processes in place.

In summary, Azure Blob Storage is a powerful solution for archiving and cost-sensitive document storage in Dynamics 365, but organizations should be mindful of the custom development requirements and the limited usability for collaborative tasks. By weighing these factors, businesses can make informed decisions that align with their document management strategies.

Attachments in Dynamics 365: Pros and Cons

Attachments in Dynamics 365 provide a convenient way to manage documents and files directly within the platform. However, like any feature, they come with their own set of advantages and disadvantages.

Pros

  1. Ease of Use: One of the standout benefits of attachments in Dynamics 365 is their user-friendly nature. Users can easily attach files to records without needing extensive training, making it accessible for everyone in the organization.
  2. Integration with Records: Attachments are directly linked to specific records, such as customer accounts or sales opportunities. This integration ensures that relevant documents are always available in context, enhancing workflow efficiency.
  3. Version Control: Dynamics 365 allows for basic version control of attachments, enabling users to track changes and revert to previous versions if necessary. This feature is crucial for maintaining the integrity of important documents.
  4. Centralized Storage: By storing attachments within Dynamics 365, organizations can keep all relevant information in one place, simplifying document management and retrieval.

Cons

  1. Limited Scalability: As the volume of attachments grows, performance can suffer. Large numbers of files can lead to slower load times and difficulties in accessing documents, which can hinder productivity.
  2. Searchability Issues: The search functionality for attachments in Dynamics 365 is relatively basic. Users may find it challenging to locate specific documents quickly, especially in environments with extensive data.
  3. Lack of Collaboration Tools: While attachments can be shared, the system lacks robust collaboration features. This limitation can be a drawback for teams that need to work together on documents in real-time.
  4. Storage Limitations: Depending on the Dynamics 365 plan, there may be restrictions on the amount of storage available for attachments. Organizations with high storage needs might find this limiting.

Alternatives for Storing Static Documents in Dynamics 365

When it comes to managing static documents in Dynamics 365, organizations have several alternatives to consider, each with its own strengths and ideal use cases.

When to Choose Dynamics 365

Choosing to store static documents directly within Dynamics 365 can be advantageous when you need seamless integration with your existing workflows. This option is particularly suitable for documents that are closely tied to specific records, such as invoices, contracts, or customer communications. By keeping these documents within Dynamics 365, users can easily access them alongside relevant data, enhancing visibility and context.

Moreover, using Dynamics 365 for static documents simplifies compliance and auditing processes. Since all documents are stored within the same system, it becomes easier to track changes and maintain a comprehensive history of interactions. This is especially beneficial for organizations that require strict adherence to regulatory standards, as it ensures that all documentation is readily available for review.

When Azure Blob Storage is Preferable Over SharePoint

While SharePoint is a robust option for document management, there are scenarios where Azure Blob Storage may be the better choice for static documents. Azure Blob is particularly advantageous for organizations with large volumes of data that require cost-effective storage solutions. Its pay-as-you-go model allows businesses to scale their storage needs without incurring significant upfront costs, making it ideal for archiving purposes.

Additionally, Azure Blob is well-suited for scenarios where documents do not require frequent access or collaboration. For instance, if your organization needs to store large amounts of historical data, such as old project files or completed reports, Azure Blob can efficiently handle this without the complexities of SharePoint's collaborative features. This makes it a streamlined option for static documents that are primarily for archival purposes rather than active use.

In summary, the choice between Dynamics 365, Azure Blob Storage, and SharePoint for storing static documents depends on your organization's specific needs. By evaluating the context in which these documents will be used, you can select the most effective storage solution to enhance your document management strategy.

Understanding Document Types in Dynamics 365: Active vs. Static

There are two types of documents in Microsoft Dynamics 365.

Active Documents: Designed for Collaboration

Active documents in Dynamics 365 are specifically designed to facilitate collaboration among team members. These documents allow for real-time editing, enabling multiple users to work on the same file simultaneously. This feature is particularly beneficial in scenarios where teams need to brainstorm ideas, draft proposals, or create reports together. For instance, a marketing team might use an active document to collaboratively develop a campaign strategy, allowing team members to contribute their insights and make adjustments on the fly.

Additionally, active documents support version control, ensuring that all changes are tracked and that team members can revert to previous versions if necessary. This capability not only enhances teamwork but also fosters a more dynamic and responsive work environment, where ideas can be shared and refined in real time.

Document consumption: It often happens that a document is elaborated by several parties. For example, an individualized quote with high amount needs days or weeks until it can be finalized. In this case it is not sufficient to attach a document to a record. Instead, you need a collaboration platform where you can work on the quote with multiple collaborators. These are called "Active Documents," which play a role in the collaboration.

Static Documents: Archival and Logging

In contrast, static documents serve a different purpose within Dynamics 365. These are typically final forms, such as PDFs, emails, or receipts, that do not require further modifications. Static documents are ideal for archival and logging purposes, as they capture information in a fixed format that is easy to store and retrieve. For example, a completed invoice or a signed contract can be saved as a static document, ensuring that the original content remains unchanged for compliance and record-keeping.

Static documents are essential for maintaining a clear historical record of transactions and communications. They provide a reliable way to document important business activities without the risk of alterations, making them invaluable for audits and legal purposes. By understanding the distinction between active and static documents, organizations can better manage their document workflows in Dynamics 365, ensuring that they leverage the right type of document for each specific need.

Document consumption: Compared to active documents, static documents are the output of active documents. A sales team may be working on a quote. At some point, this quote needs to be converted into a PDF and sent to the customer. The PDF files sent to the customer need to be stored in the system for logging purposes. These are referred to as "Static Documents." Static documents include emails and email attachments.

Comparing Storage Options: Dynamics 365 vs SharePoint vs Azure Blob Storage

When it comes to choosing the right storage solution for your documents, understanding the strengths and weaknesses of Dynamics 365, SharePoint, and Azure Blob Storage is essential.

Dynamics 365

Use Case Example: Storing customer contracts or invoices directly linked to customer records.

  • Storage Costs: Typically included in your Dynamics 365 subscription, but additional costs may arise for extra storage beyond the allocated limit.
  • Permissions: Integrated with Dynamics 365 security roles, allowing for granular control over who can view or edit documents.
  • Search Capabilities: Basic search functionality within the Dynamics 365 interface, but may be limited compared to dedicated document management systems.

Pros:

  • Seamless integration with existing records.
  • Simplified compliance and auditing processes.

Cons:

  • Limited scalability for large volumes of documents.
  • Basic search capabilities may hinder quick retrieval.

SharePoint

Use Case Example: Collaborative project documents where multiple team members need to edit and provide feedback.

  • Storage Costs: Costs vary based on the SharePoint plan; typically, it offers a certain amount of storage per user.
  • Permissions: Advanced permission settings allow for detailed control over document access and sharing.
  • Search Capabilities: Robust search functionality, including metadata and content search, making it easy to find documents.

Pros:

  • Excellent for collaboration and real-time editing.
  • Hierarchical storage structure enhances organization.

Cons:

  • Can become complex to manage as the number of documents grows.
  • Requires training for users to navigate effectively.

Azure Blob Storage

Use Case Example: Archiving large volumes of historical data, such as completed projects or old reports.

  • Storage Costs: Cost-effective, pay-as-you-go model; ideal for large data volumes with infrequent access.
  • Permissions: Basic access control, but may require additional configuration for detailed permissions.
  • Search Capabilities: Limited search functionality; primarily relies on external tools or applications for effective retrieval.

Pros:

  • Highly scalable and cost-efficient for large data storage.
  • Suitable for static documents that do not require frequent access.

Cons:

  • Requires custom development for integration with Dynamics 365.
  • Limited usability for collaborative tasks.

Flat vs. Hierarchical Storage

Flat Storage

  • Pros: Simplicity in structure; easy to implement and manage for smaller datasets.
  • Cons: Can become unwieldy as the number of documents increases, making it difficult to locate specific files.

Hierarchical Storage

  • Pros: Better organization through folders and subfolders; enhances searchability and retrieval of documents.
  • Cons: More complex to set up and manage; may require user training to navigate effectively.

Choosing the right storage option for your documents in Dynamics 365 depends on your specific needs, such as collaboration requirements, cost considerations, and the volume of data.

FeatureDynamics 365SharePointAzure Blob Storage
Flat document storage+++++++++
Hierarchical document storage-++++
Search++++-
Document permission management+++++
Navigation++++-
Central access (like DMS)-+++-
Storage costs-+++++
Keywording documents-+++-
Information security (sensitivity labels)-+++-

How to Choose the Right Document Storage Solution

Choosing the right document storage solution involves several key considerations. First, assess your organization's specific needs, such as the volume of documents, frequency of access, and collaboration requirements. If your team often collaborates on documents, a solution like SharePoint may be ideal due to its robust sharing and editing features.

Next, consider scalability and cost. Solutions like Azure Blob Storage are excellent for large volumes of data and can be more cost-effective for archival purposes. Additionally, evaluate the integration capabilities with your existing systems, such as Dynamics 365, to ensure a seamless workflow.

Finally, think about security and compliance. Ensure that the solution you choose offers the necessary permissions and protections to keep your sensitive information safe. By carefully weighing these factors, you can select a document storage solution that aligns with your organizational goals and enhances productivity.

Steps to Enable Document Storage in Dynamics 365

This is the journey of an application manager for document management in Dynamics 365.

Step 1: You discover Dynamics 365 Attachments and try to store the documents as attachments.

Step 2: Identify the challenges in storing the files as attachments and come up with the idea of enabling SharePoint integration through the Document Management feature.

Step 3: One finds out that the Document Management feature of Dynamics 365 does not meet most of the requirements and will identify that the standard feature of D365 needs to be enhanced through customization.

Step 4: One finds out that there is no added value in storing all documents blanketly in SharePoint.

Step 5: An attempt is made to categorize the documents and to store only those documents in SharePoint that are created through collaboration in teams. In this way, the goal is achieved. Until you find the right way, you lose a lot of time and energy along the way.

Conclusion

Selecting the right Dynamics 365 document storage option is vital for enhancing your organization's efficiency and collaboration. Whether you choose to utilize Dynamics 365 SharePoint document location for robust file management or opt for Dynamics 365 Azure Blob integration for scalable storage solutions, each method offers unique advantages tailored to different business needs. Understanding where attachments are stored in Dynamics 365 and how to manage multiple files effectively can significantly streamline your workflows. By leveraging Dynamics 365 document storage and Dynamics 365 attachments storage, you can ensure that your critical documents are not only secure but also easily accessible to your team.

As you explore these options, consider your specific requirements and how each solution aligns with your operational goals. With the right approach, you can transform your document management strategy into a powerful asset that drives productivity and supports your business's growth. Embrace the possibilities within Dynamics 365, and take your document management to the next level.

Frequently asked questions about document storage in Dynamics 365

  • What are the document storage options in Dynamics 365?

    There are three ways to save Dynamics 365 documents: attachments directly in Dynamics 365, storage in SharePoint via the Document Management feature, and Azure Blob Storage. Attachments are easy to use but scale poorly; SharePoint excels at collaboration, organization, and searchability; Azure Blob Storage suits archiving and cost-sensitive storage of large data volumes.

  • When should you use Azure Blob Storage for Dynamics 365 documents?

    Azure Blob Storage is suited to archiving and cost-sensitive needs, such as large volumes of unstructured data that are accessed infrequently but must be retained for compliance or historical purposes. Its pay-as-you-go model reduces costs. The downsides are the requirement for custom development to integrate it with Dynamics 365 and the lack of built-in collaboration features.

  • What is the difference between active and static documents?

    Active documents are designed for collaboration - they support real-time editing and version control, for example an individualized quote several parties work on over days or weeks. Static documents are the output of active documents: final forms such as PDFs, emails, or receipts that require no further changes and are stored for archival and logging purposes.

  • Why are Dynamics 365 attachments unsuitable for large document volumes?

    As the volume of attachments grows, performance can suffer, leading to slower load times and accessibility issues. Searchability is also relatively basic, making specific documents hard to locate quickly, and the system lacks robust real-time collaboration tools. Depending on the Dynamics 365 plan, there may also be storage limitations.

See Valprovia live
in 30 minutes

Your use cases, one demo, one pricing proposal. No sales pressure - directly from the Valprovia team.