Thanks Shankar! We do have a bunch of videos comparing many aspects of Power BI, Tableau and Cognos. You can see the playlist here ua-cam.com/play/PLSE78O-gW10KKRzy7XLsBpwpcmiVR9jOg.html
On the synapse pipeline/ADF I agree on connectivity, in fact that's why I first went to ADF. However I feel in NO WAY does ADF compete with SSIS. SSIS can do thousands of activities very fast. ADF cannot. "almost instaneous" was mentioned. That "almost" times several thousands = something that takes minutes in SSIS may take days in ADF. Seriously. So if you have big dataflows then both are capable. But ADF can't survive death by a thousand cuts if that's the bulk of your normal operation like it is for our EDW.
Thanks for sharing your insights! You make a valid point about SSIS's speed for smaller, repetitive tasks. ADF does have its strengths in orchestration and scalability, especially for large data operations. It can be a trade-off depending on the specific use case.
@@SenturusInc I've never worked on a DW project that didn't have the same use case. I'd argue ADF does have superior orchestration - in fact functionality wise all around it's superior but I'd argue I could do anything with SSIS faster than with ADF. I've done lots of scaling with ADF IRs just to get it to perform like I'm used to with SSIS default settings. The ADF mapping function when I tested it was so slow it was unusable so have done workarounds with copy activities. Nice functionality for things like parsing json but couldn't handle any kind of volume. Then there's the layering limitation of just ADFs (which don't talk to eachother) with it's pipelines. SSIS offers it's solutions-projects-packages layering that seems to make it easier to organize workloads than ADF offers. In the end I just don't see how ADF will ever serve a major role in for DW operations except as an orchestration tool. I would love to be proved wrong.
Thanks for the detailed and practical case based comparison. Would love to see more of such videos
Thanks Shankar! We do have a bunch of videos comparing many aspects of Power BI, Tableau and Cognos. You can see the playlist here ua-cam.com/play/PLSE78O-gW10KKRzy7XLsBpwpcmiVR9jOg.html
Thank you so much. This is great info. This is exactly what I was looking for. Great comparison info on both tools.
So glad you enjoyed it! Thanks for taking the time to tell us.
Very nice presentation , well done ! I have one question , can we add a link services to a Snowflake from Azure Synapse Workspace ?
Valentin, I don't fully understand your question. You can contact us at info@senturus.com to discuss it further.
@@SenturusInc please check your email
On the synapse pipeline/ADF I agree on connectivity, in fact that's why I first went to ADF. However I feel in NO WAY does ADF compete with SSIS. SSIS can do thousands of activities very fast. ADF cannot. "almost instaneous" was mentioned. That "almost" times several thousands = something that takes minutes in SSIS may take days in ADF. Seriously. So if you have big dataflows then both are capable. But ADF can't survive death by a thousand cuts if that's the bulk of your normal operation like it is for our EDW.
Thanks for sharing your insights! You make a valid point about SSIS's speed for smaller, repetitive tasks. ADF does have its strengths in orchestration and scalability, especially for large data operations. It can be a trade-off depending on the specific use case.
@@SenturusInc I've never worked on a DW project that didn't have the same use case. I'd argue ADF does have superior orchestration - in fact functionality wise all around it's superior but I'd argue I could do anything with SSIS faster than with ADF. I've done lots of scaling with ADF IRs just to get it to perform like I'm used to with SSIS default settings. The ADF mapping function when I tested it was so slow it was unusable so have done workarounds with copy activities. Nice functionality for things like parsing json but couldn't handle any kind of volume. Then there's the layering limitation of just ADFs (which don't talk to eachother) with it's pipelines. SSIS offers it's solutions-projects-packages layering that seems to make it easier to organize workloads than ADF offers. In the end I just don't see how ADF will ever serve a major role in for DW operations except as an orchestration tool. I would love to be proved wrong.