Solución de gestión de archivos adjuntos para Dynamics 365

Reducir los costos de almacenamiento de la base de datos Dynamics 365 con SharePoint, Azure Blob o Azure File Storage

Anastasia Mazur Noticias de la empresa, Productos y soluciones 4 Comentarios

All organisations reach the free storage limit in Dynamics 365 sooner or later. In this article, we will examine possible scenarios of dealing with the issue of exhausting the available storage limit in the cloud CRM – at minimal cost and maximum benefit.

Typical issue with D365 storage space

In order to add a practical standpoint to this research, here is one of the requests to IT experts dealing with Dynamics 365 issues.

One of our clients is having a problem with increasing database size very quickly. The huge database size is also becoming a performance issue. Besides, the client is looking for decreasing the storage costs. Current database size is 530GB. We have checked the free add-on from Microsoft but we are reluctant about bringing it in our org full scale. Besides, looking for more functionality like extracting old and new documents.

Aquí hay una sorpresa: tenemos documentos sensibles, así que preferiríamos que no pasaran por ningún servicio externo.

We also cannot employ anything outside the constraints of what we currently have in our Azure tenancy, that being: Dynamics 365 with the option of uploading custom plugins and/or custom workflow tasks or currently paid-for PaaS facilities, notably Flow. This eliminates the option of having a console-based application, or even a web app.

This request from a D365 admin reflects a typical constraint of the cloud CRM: free storage 10GB provided as part of a Plan 1 subscription run out sooner or later. And if you are a mid-size organisation, your 100+ GB database eats up the storage in the blink of an eye pushing you to pay for extra storage or look for alternative solutions.

Intenta reducir el espacio de almacenamiento en D365

Monitoring D365 health is important. By doing that, you ensure system’s optimal performance and enough space for growth.

When you have reached 80% of your total storage capacity, the system should send you an alert so that you could take actions.

Here is what one can do to reduce storage space:

  • Eliminar los registros obsoletos, como los casos y la oportunidad
  • Eliminar los archivos adjuntos innecesarios de correos electrónicos y notas mediante la búsqueda avanzada y la eliminación masiva
  • Evaluar y eliminar los flujos de trabajo suspendidos
  • Eliminar los trabajos de detección de duplicados en masa y las copias asociadas de los registros duplicados
  • Suprimir las instancias de importación masiva
  • Borrar instancias de trabajo de eliminación masiva usando un trabajo de eliminación masiva
  • Eliminar los registros de auditoría

Although these recommendations are sensible, we can’t guarantee their effectiveness for all organisations. The problem is, according to various estimates, 70% of storage space in Dynamics 365 is occupied with documents and attachments. If your organisation tracks emails in the CRM system like most companies do, free storage shrinks quickly – beyond reversible with traditional measures.

Aprovechamiento de los sistemas de gestión de documentos

Because Dynamics 365 just like every other cloud CRM system has been primarily designed to manage customer relations and not store documents, the best proven practice of avoiding extra costs for document storage is forwarding them to systems with cheaper storage.

Entre los más populares están los sistemas de gestión de documentos (DMS) como SharePoint, Mancha azul, Azure File Storage etc. They have much more storage available for only a fraction of a cost compared to Dynamics 365.

Azure Blob is a cloud-based storage solution provided by Microsoft Azure that can be used to store and retrieve Binary Large Objects (BLOBs). It allows users/organizations to expose their unstructured data to customers anywhere through REST-based object storage.

En cuanto al SharePoint, con un almacenamiento más barato, las organizaciones reciben inmensas oportunidades de colaboración. Algunas de las cuales exploramos en este SharePoint Structure Creator poste.

Cómo sincronizar el Dynamics 365 con el SharePoint o Azure Blob

Before a D365 user can send documents and attachments to a DMS storage, the two systems need to be synchronized. Of course, extracting documents manually is possible too, but it will crumble all the productivity.

Currently the software market offers several solutions for extracting attachments from Dynamics 365 with various features and functionality.

Una de ellas es una solución gratuita de los laboratorios Microsoft. Gestión de los anexos es un complemento del Dynamics 365 CRM. Crea un archivo adjunto en Azure when se añade una nota o un archivo adjunto de correo electrónico a Dynamics 365 y se borra el archivo en Dynamics después de que se haya creado el archivo en el almacenamiento Azure Blob.

However, D365 experts recommend this free add-on with caution. Firstly, because it is not officially supported by Microsoft. “The purpose is to show the possibility of an alternate storage platform for Dynamics 365 (…) This solution should not be used in a Production instance as this is not officially supported. It should only be used in a Non-Production instance such Dev or a Test”, writes CRMTipoftheday.

Secondly, tech support for free apps is usually limited so in case of friction you may have to rely on yourself. And finally, the solution works only for Azure Blob, so should you choose SharePoint with its document collaboration advantages, you need to look for other synchronization options.

CB Dynamics 365 Seamless Attachment Extractor

At Connecting Software, we have been working on synchronization solutions since 2009, and have noticed that the limited storage space is a chronic pain in many cloud CRM systems. We started with the Document Extractor which solves the super expensive storage space issue for Salesforce and Dynamics CRM, and continued with SugarCRM to SharePoint Stubbing.

Now, having collected our best expertise, we’re launching within weeks the CB Dynamics 365 Seamless Attachment Extractor.

The solution resolves the problem with expensive storage space in Dynamics365. It transfers seamlessly any attachment files from CRM to other configured storage but mimics the presence of the attachment files in CRM.

It means that the actions of the solution are transparent to end-user. Attachments still appear as stored in CRM and the user can still work with them the same way as if they are stored in CRM, but they are off-loaded to another file storage such as SharePoint, Azure File Storage, Azure Blob Storage etc.

As our experts point out, with this solution you can be sure that each document will not occupy storage space in D365 and at the same time will be reachable to users who have access to the respective record in Dynamics365 without any modification of their workflows with D365 files. Any additional modification of the Dynamics365 files will be projected to the configured external file storage automatically.

What is special about the CB Dynamics 365 Attachment Extractor

Its most outstanding feature is security. Unlike with some solutions on the market, with CB Dynamics 365 Seamless Attachment Extractor add-on, your documents are not leaving the CRM and attachment storage systems. There is no external service in between. This is important for companies which take care of sensitive data or want to protect themselves against GDPR violations.

Otra característica útil y exclusiva del mercado es que puede comprimir/descomprimir archivos sobre la marcha y como encriptarlos/desencriptarlos con el cifrado AES256, que fue adoptado por the U.S. government and se utiliza ahora en todo el mundo.

On the top of that, if you have actually reached the 80% of the storage space limit, this add-on will automatically go through the attachments which existed prior to installing the app and move them to SharePoint, Azure Blob or other location to your choice.

Más sobre las características técnicas del extractor de accesorios CB D365

El software está extrayendo cualquier entidad de actividad y anotación de D365. Significa que puedes configurarlo para extraer adjuntos de cualquier tipo de entidad:

  • Suscripción a la alerta
  • Invitar a la redención
  • Comentario del portal
  • Cita
  • Campaña rápida
  • Actividad de la campaña
  • Respuesta de la campaña
  • Actividad de chat
  • Correo Electrónico
  • Fax
  • Resolución de casos
  • Carta
  • inMail
  • Mensaje
  • Presentación de PointDrive creada
  • Presentación de PointDrive vista
  • Aprobación
  • Alerta de reserva
  • Actividad de la encuesta
  • Oportunidad Cerrar
  • Orden Cerrar
  • Llamada telefónica
  • Cita Cerrar
  • Cita recurrente
  • Actividad de servicio
  • Actividad social
  • Tarea
  • UntrackedEmail

La solución funciona entre Dynamics 365 en línea y:

  • SharePoint 2013
  • SharePoint 2016
  • SharePoint 2019
  • SharePoint Online
  • Office 365
  • Almacenamiento de archivos azules
  • Azure blob storage

We encourage you to request more information about this soon to be released product. Allow this software to take care of the health of your Dynamics 365 while you are concentrating on more important tasks.

Más información sobre el almacenamiento en la nube de CRM:

Salesforce y Protección de Datos: Cómo permanecer en la cloud y cumplir con la normativa

Azúcar a SharePoint File Stubbing: Matar los costos de almacenamiento de CRM

Share this Post

Comentarios 4

  1. ¿Pueden las herramientas también mover la literatura de ventas? ¿Puede informar del coste de 2 x licencias de producción para D365 Online?


  2. Post

    Hola Alan, gracias por contactarnos. La versión actual no toca el artículo de literatura de ventas. Pero la buena noticia es que funciona como otros accesorios, así que no debería llevar más de un día extender el software. Por favor, contacta con Eduardo Coreixo, - puede aconsejarte sobre el precio y los siguientes pasos.

  3. Gracias por compartir este artículo. Muchos puntos únicos que nunca antes se habían cruzado por la mente. ¡Muy bien resumidos!

Deja una respuesta