Forum Discussion

IanKeogh's avatar
IanKeogh
New Member
2 years ago
Solved

Connect FDF To Azure SQLMI

Hi, So I am totally new to FDF (Fabric Data Factory). I am using app.fabric.microsoft.com to access Fabric Data Factory. I am creating a pipline, I am able to connect to Azure blob and injest my flat...
General Question
Pipelines
  • NandanHegde's avatar
    NandanHegde
    2 years ago

    Hey,

    The reason why you are able to access blob without issue is because it is not encassed within any firewall.

    Whereas in case of SQL MI, the database is within a VNET; so fabric is unable to access it directly.

    You would need to access the SQL MI via a data gateway

AmadouBari's avatar
AmadouBari
Frequent Visitor
1 year ago

Hi Nandan - why would i need a gateway to access the MI from a SAAS Fabric? I am not on-prem and they are in the same tenant.

 

NandanHegde's avatar
NandanHegde
Super User
1 year ago

A gateway act as a bridge between Fabric and any source which is hosted within a VNet.

Note : The tenant doesnt ideally matter in decision whether to use a gateway or not.

 

As the SQL MI is within a VNet, Fabric wont be able to directly access objects within the VNet because of which you would need a gateway

  • AmadouBari's avatar
    AmadouBari
    Frequent Visitor
    1 year ago

    Thank you, Nandan. In case of just mirroring the MI into fabric, i am not even getting an option to select a gateway.