question

chetankela-0605 avatar image
0 Votes"
chetankela-0605 asked SumanthMarigowda-MSFT edited

Store Blob storage as structured data

Hi

I am searching for way on how to stored the structured data in Azure blob storage

Requirement is, i need to move the document present in Dynamics CRM ( annotations ) to azure blob in structured manner.
Like for example, if there is Case record in dynamics CRM D365 and it has document attached to it, I need to move the case record as well as document present in annotations to Azure blob storage in structured manner and maintain the relationship of it like how it is maintain in SQL database of parent child record.
Once this data is setup in azure, the link of the uploaded document and this case record (which is moved to Azure) should be maintain in Contact record in CRM

Please help if any solution available for this, let me know

Thanks

azure-blob-storage
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SumanthMarigowda-MSFT avatar image
0 Votes"
SumanthMarigowda-MSFT answered chetankela-0605 commented

@chetankela-0605 Welcome to Microsoft Q&A Forum, Thank you for posting your query here!

Azure Blob storage can be accessed from Hadoop (available through HDInsight). HDInsight can use a blob container in Azure Storage as the default file system for the cluster. Through a Hadoop distributed file system (HDFS) interface provided by a WASB driver, the full set of components in HDInsight can operate directly on structured or unstructured data stored as blobs. Azure Blob storage can also be accessed via Azure Synapse Analytics using its PolyBase feature.

Azure Blob Storage structures: Object store with flat namespace

This topic compares options for data storage for big data solutions — Choosing a big data storage technology in Azure

This article will provides detailed information on Data store model(On Relation ship with the database) which gives idea for your scenario. If you still find any difficulties, please let us know we would like to work closer on this issue.

Hope this helps!


Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi

I want to move the entire "Case" entity record from CRM to Azure. Please let me know if there is any to move it ?

Also want to move the attachments to azure blob, please let me know how to do this. ?

Once above two steps performed, i want to create some relationship in azure which tells which record has which attachment. ( like referential key in SQL )

Please let me know.

Thanks

0 Votes 0 ·
SumanthMarigowda-MSFT avatar image
0 Votes"
SumanthMarigowda-MSFT answered SumanthMarigowda-MSFT edited

@chetankela-0605 This article will help you to Automate the migration of on-premise Dynamics CRM to the cloud

5 steps to move to a cloud CRM, This is mainly related to Microsoft CRM Migration, I would recommended to post your query in Microsoft Dynamics CRM Forum These forum community members could provide their expert guidance on your scenario based on their experience. .

If you still find any difficulties, I would recommend you to contact support, so If you have a support plan, I request you file a support ticket, else please do let us know, we will try and help you get a one-time free technical support. In this case, could you send an email to AzCommunity[at]Microsoft[dot]com referencing this thread as well as your subscription ID. Please mention "ATTN subm" in the subject field. Thank you for your cooperation on this matter and look forward to your reply.


Hope this helps!

Kindly let us know if the above helps or you need further assistance on this issue.


Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.