How do i migrate quickbooks desktop data to an azure database?

Question

what is best way to migrate quickbooks desktop 21 data to azure database?

Answer 1

Hi
Alexander Oliver •,

Welcome to Microsoft Q&A forum.

As I understand, you want to migrate quickbooks desktop data to an azure database.

This can be achieved using Azure Data Factory by following the tutorial mentioned here: https://learn.microsoft.com/en-us/azure/data-factory/connector-quickbooks?tabs=data-factory

Note:

The Copy Activity in the service cannot copy data directly from Quickbooks Desktop. To copy data from Quickbooks Desktop, export your Quickbooks data to a comma-separated-values (CSV) file and then upload the file to Azure Blob Storage. From there, you can use the service to copy the data to the sink of your choice.

Hope this helps. Let us know if you have further queries.

Thanks

Answer 2

Hi
Alexander Oliver •,

In Azure Data Factory, you can automate the pipeline using Triggers.

Refer https://learn.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers

Also, you can write you own custom code in Python/Java/C# to perform the same.

Export of your Quickbooks data to a comma-separated-values (CSV) file and then upload the file to Azure Blob Storage has to be done which also you can automate.

Hope this helps, thanks.