Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 conne...
General Question
pipelines
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I will check on this and update the same 

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      2 years ago

      Hi Anonymous 

       

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

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