Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 .
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.
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.
I will check on this and update the same
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
Pipeline copy activity we can't select connection using Vnet / Onprem gateway. So it still pending.
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.
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
Nothing working. Raised ticket with support team. They are working on this since 3 days but no luck.
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.
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
Check out the November 2024 Fabric update to learn about new features.
User | Count |
---|---|
6 | |
5 | |
2 | |
2 | |
1 |
User | Count |
---|---|
16 | |
11 | |
7 | |
6 | |
6 |