Forum Discussion
Fabric SQL DB connector from Data Factory
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.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:- Go to Settings --> Manage Connections and Gateways.
- Create a new connection for Fabric SQL DB.
- In the connection settings, enable "Allow this connection to be used with gateways."
- 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.
Hi,
This problem is still not solved. The SQLDB connection name is automatically appearing while choosing the connection (Like the Lakehouse and warehouse in the same workspace), I have not created the connection so that I can change any parameter on it.
Even though I create a connection for the sql DB, it does not appear in the connection dropdown in pipeline.
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:
- Go to Settings --> Manage Connections and Gateways.
- Create a new connection for Fabric SQL DB.
- In the connection settings, enable "Allow this connection to be used with gateways."
- 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.