Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

MS Fabric Data Flow Gen2. Can I write to an on-premise SQL Server?

I have setup a simple DataFlow to copy a table from an on-premise DB2 server.  Within the Power Query interface, I can add a data destination (for copying the data to), but there are only 4 options t...
Need Help
frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
2 years ago

This is not DFG2, but perhaps you can use Data Pipeline copy activity to write data to on-prem SQL Server? I've never tried but it seems to have a SQL Server connector.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks.  I did try that (and, yes, you can write to an on premise SQL Server) but ran into another issue where the Gateway version we are at does not support connecting to our DB2 database...whereas a Dataflow Gen2 connection to DB2 is able to use our existing Gateway.  That's a bit frustrating; I'd expect consistency across the Fabric platform when it comes to this connectivity.  😁