unable to connect Azure PostgreSQL running on different subscription

[vishalsawant]

I have 2 different subscription

subcription 1 Hosing Azure PostgreSQL database

subscription 2 runing Azure Fabric

Tried to connect with Azure PostgreSQL using Data Factory but not able to connect.

Can some one  let me know is this even possible? If yes let me know the steps .

[vishalsawant]

both subscription in same Teanant. I have already done using Dataflow but it's tremendously slow. Is there anything we can use in Data Pipeline.

[v-cboorla-msft]

Hi @vishalsawant 

Thanks for your response.

Yes, PostgreSQL is a connector that is supported in Data Pipeline with the Copy Activity, so they can explore using that as well. With regards to the Dataflows Gen2 one thing they could test if they are simply doing a straight copy from source to target is disabling staging on the query and see if that helps to reduce the duration. (right-click on the query and from the context menu deselect the 'enable staging' option) This guidance is discussed in the blog post here when it used to be called 'enable load' Data Factory Spotlight: Dataflow Gen2 | Microsoft Fabric Blog | Microsoft Fabric

I hope this helps. Please do let us know if you have any further questions.

[vishalsawant]

I will check on this and update the same 

[v-cboorla-msft]

Hi @vishalsawant 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks

[vishalsawant]

Pipeline copy activity we can't select connection using  Vnet / Onprem gateway. So it still pending.

[v-cboorla-msft]

Hi @vishalsawant 

Apologies for the issue that you are facing here.

The below procedure might help you to resolve your ask.

In order to connect from on-prem SQL server to Fabric, you need to install an on-premises gateway. Please find the related documentation - Install and configure an on-premises data gateway 

For server connection from on-prem SQL server to Microsoft Fabric please refer :

On Premise SQL Server 2022 Data into Microsoft Fabric

Getting On-Premises SQL Server Data to Fabric Lakehouse 

I hope this information is helpful. If problem still persists please do let us know.

[v-cboorla-msft]

Hi @vishalsawant 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.

In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks

[vishalsawant]

Nothing working. Raised ticket with support team. They are working on this since 3 days but no luck.

[v-cboorla-msft]

Hi @vishalsawant 

Hi Apologies for the issue you have been facing.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

Please provide the ticket number here as we can keep an eye on it.

Thank you.

[v-cboorla-msft]

Hi @vishalsawant 

Are the subscriptions in the same tenant? Have you reviewed the documentation? Set up your PostgreSQL database connection - Microsoft Fabric | Microsoft Learn. If you have the username/password you should be able to create the connection from Dataflows Gen2 to the PostgreSQL database, based on the pre-reqs you will need to have a gateway with the provider installed.

I hope this helps. Please do let us know if you have any further questions. Glad to help.

Thanks