Forum Discussion

Mayumi_2021's avatar
Mayumi_2021
Frequent Visitor
1 year ago
Solved

Fabric SQL DB connector from Data Factory

I am trying to copy data from an on-premise SQL DB and to SQL DB on Fabric (which is in Preview). I am using Fabric Data Factory for the copy activity. I can preview data from the source which is usi...
data engineering
  • Mayumi_2021's avatar
    Mayumi_2021
    1 year ago

    Hi Anonymous 
    Unfortunately not resolved yet. As an workaround, I am landing my data in LH as a middle step and can do LH to SQL DB transfer.

  • v-veshwara-msft's avatar
    v-veshwara-msft
    1 year ago

    Hi Mayumi_2021 ,
    Thanks for getting back and sorry for late reply.

    Since your source is an on-premises SQL DB, the activity is running on a gateway. However, Fabric SQL DB is a cloud-based service, and cloud connections are not compatible with the gateway by default. To resolve this issue, you need to manually create a connection for Fabric SQL DB and enable the option "Allow this connection to be used with gateways" in the connection settings.

    Steps:

    1. Go to Settings --> Manage Connections and Gateways.
    2. Create a new connection for Fabric SQL DB.
    3. In the connection settings, enable "Allow this connection to be used with gateways."
    4. Save the changes and retry the pipeline execution.

    If the issue persists, check the error logs and ensure the correct authentication method is used. If further assistance is needed, consider raising a support ticket. 
    Microsoft Fabric Support and Status | Microsoft Fabric

    Hope this helps.
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

    Best Regards,
    Vinay.

v-veshwara-msft's avatar
v-veshwara-msft
Community Support
1 year ago

Hi Mayumi_2021 ,

Thanks for posting in the Microsoft Fabric Community.

You can find the "Allow this connection to be used with gateways" option in the Data Connections settings:

  1. Navigate to Settings-->Manage Connections and Gateways.
  2. Locate your data connection and open its settings.
  3. Enable the option to ensure compatibility with the gateway.

Once enabled, save the changes and retry your pipeline. This should resolve the issue and allow data to flow successfully from the on-premises SQL DB to Fabric SQL DB.

 



Please refer to this thread for further details:
Solved: Fabric - Microsoft Fabric Community

Let us know if you need any additional assistance!

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

Best Regards,
Vinay.



 



v-veshwara-msft's avatar
v-veshwara-msft
Community Support
1 year ago

Hi Mayumi_2021 ,
We haven't heard from you since last response and just wanted to check whether the solutions provided met your needs. If yes, please accept as solution to help others benefit. If not, please reach out.
Thank you.