Exam DP203 Hybrid Transactional Analytical: Difference between revisions
No edit summary |
No edit summary |
||
| Line 11: | Line 11: | ||
Alternatively this can be done in the Azure CLI by running: | Alternatively this can be done in the Azure CLI by running: | ||
<pre> | |||
az cosmosdb update --name my-cosmos-db --resource-group my-rg --enable-analytical-storage true | |||
</pre> | |||
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:
az cosmosdb update --name my-cosmos-db --resource-group my-rg --enable-analytical-storage true