Exam DP203 Hybrid Transactional Analytical: Difference between revisions
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
Azure Synapse Link for Dataverse. Where Dataverse (the Power Platform database) is the OLTP database. Note that here the data goes into Gen2, not a dedicated pool for some reason. | Azure Synapse Link for Dataverse. Where Dataverse (the Power Platform database) is the OLTP database. Note that here the data goes into Gen2, not a dedicated pool for some reason. | ||
== CosmosDB == | |||
First need to '''Enable Azure Synapse Link''' in CosmosDB in the Portal. | |||
Alternatively this can be done in the Azure CLI by running: | |||
Revision as of 20:16, 20 November 2024
Hybrid Transactional / Analytical Processing (HTAP). This is where Azure Synapse Link replicates transactional data into an analysis data store.
From CosmosDB: Azure Synapse Link for CosmosDB
For Azure SQL Database or a SQL Server instance: Azure Synapse Link for SQL (to a dedicated pool, and a spark pool can connect to that dedicated pool).
Azure Synapse Link for Dataverse. Where Dataverse (the Power Platform database) is the OLTP database. Note that here the data goes into Gen2, not a dedicated pool for some reason.
CosmosDB
First need to Enable Azure Synapse Link in CosmosDB in the Portal.
Alternatively this can be done in the Azure CLI by running: