search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.2k stars 21.34k forks source link

How can I connect to a read-only replica from Fabric? #119167

Closed carlos-carcapital closed 7 months ago

carlos-carcapital commented 7 months ago

This article explains the read-only replicas available under the premium capacity. How can I connect to this read-only replica from Fabric for my ETLs?

Thank you.

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

AjayBathini-MSFT commented 7 months ago

@carlos-carcapital Thanks for your feedback! We will investigate and update as appropriate.

shaktisingh-msft commented 7 months ago

Hi @rajeshsetlem,

Could you please look into this, thanks.

WilliamDAssafMSFT commented 7 months ago

assign:WilliamDAssafMSFT

WilliamDAssafMSFT commented 7 months ago

Thanks @carlos-carcapital. Currently, the only way to do this would be through Fabric Data Factory, to copy the data into your own Warehouse via an ETL process: https://learn.microsoft.com/fabric/data-factory/connector-azure-sql-database Connecting to SQL Database replicas is covered here: https://learn.microsoft.com/azure/azure-sql/database/read-scale-out?view=azuresql#connect-to-a-read-only-replica

However, keep an eye on the Fabric release plan, because there are new and better solutions coming for bringing SQL Server and Azure SQL Database data into Fabric on the roadmap, without an ETL: https://learn.microsoft.com/fabric/release-plan/data-warehouse There will be easier solutions available in the future.

If you have any deeper technical questions, this is not the best forum, as this space is for documentation updates. Product questions and feature capability questions are best addressed elsewhere: I recommend https://ideas.fabric.microsoft.com/, the Microsoft Fabric Community, Microsoft Support, or your support partners. Regardless, thanks again for this feedback, your suggestions help improve our documentation.

please-close