Forum Discussion
unable to connect Azure PostgreSQL running on different subscription
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 .
10 Replies
v-cboorla-msftMicrosoft Employee
Hi Anonymous
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 Anonymous
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
- v-cboorla-msft
Hi Anonymous
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.