topic Re: Connecting to Azure SQL Managed Instance Read-Only Replica in Dataflow

Connecting to Azure SQL Managed Instance Read-Only Replica

gcarvalho — Wed, 14 Aug 2024 03:46:26 GMT

Hello,

I was wondering if there's a way to connect to a read-only replicate on an Azure SQL Managed Instance via Fabric Dataflow Gen2. I can connect to a read-only replicate using SSMS as shown here https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql , but I'm not sure if there's a way to do it from a Dataflow.

Thanks!

lbendlin — Wed, 14 Aug 2024 22:30:58 GMT

If the ApplicationIntent value is ReadOnly, the connection is routed to a read-only replica.

I don't think that attribute is supported by the default SQL database connector

It is also not mentioned for the ODBC connector.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

Anonymous — Thu, 15 Aug 2024 01:35:26 GMT

Thank you very much lbendlin for your prompt reply.

This forum is used to discuss Fabric related content.

Since this is a product issue beyond the scope of this forum, I recommend that you post this query on the Azure Data Factory Community Forum.

The following links:

If you have any Fabric related questions, please continue to use this forum to contact us!

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.