Difference between revisions of "Data export"
Jump to navigation
Jump to search
(Created page with "This page describes different ways to get data out of Microsoft Dataverse. With Data Export Service you can replicate data to Azure SQL. In Maker Portal you can use the opt...") |
|||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
This page describes different ways to get data out of Microsoft Dataverse. | This page describes different ways to get data out of Microsoft Dataverse. | ||
| − | With Data Export Service you can replicate data to Azure SQL. | + | * From withing [[model-driven apps]] there is a possibility to Export to Excel from any view. |
| + | * Export data to .csv file from [https://make.powerapps.com Maker Portal]. | ||
| + | * In Maker Portal you can also use the option Export to data lake. | ||
| + | * With Data Export Service you can replicate data to an Azure SQL database or SQL Server instance running in an Azure virtual machine. | ||
| − | + | You can also use Azure Data Factory for data import/export. Other common ways to get data out of Dataverse is to use a third party tool, e.g. Kingswaysoft or Scribe. | |
== Microsoft Resources == | == Microsoft Resources == | ||
* [https://docs.microsoft.com/en-us/powerapps/maker/data-platform/export-to-data-lake Export table data to Azure Data Lake Storage Gen2] | * [https://docs.microsoft.com/en-us/powerapps/maker/data-platform/export-to-data-lake Export table data to Azure Data Lake Storage Gen2] | ||
* [https://docs.microsoft.com/en-us/powerapps/developer/data-platform/data-export-service Data Export Service] | * [https://docs.microsoft.com/en-us/powerapps/developer/data-platform/data-export-service Data Export Service] | ||
| + | * [https://docs.microsoft.com/en-us/azure/data-factory/connector-dynamics-crm-office-365 Copy data from and to Dynamics 365 (Common Data Service) or Dynamics CRM by using Azure Data Factory] | ||
| + | |||
| + | [[Category:Maker]] | ||
| + | [[Category:Admin]] | ||
Latest revision as of 13:43, 29 January 2021
This page describes different ways to get data out of Microsoft Dataverse.
- From withing model-driven apps there is a possibility to Export to Excel from any view.
- Export data to .csv file from Maker Portal.
- In Maker Portal you can also use the option Export to data lake.
- With Data Export Service you can replicate data to an Azure SQL database or SQL Server instance running in an Azure virtual machine.
You can also use Azure Data Factory for data import/export. Other common ways to get data out of Dataverse is to use a third party tool, e.g. Kingswaysoft or Scribe.