I personally like using third party tools to make my life easier, but I can see having control over every bit of pieces of a solution would be a benefit.
That means you may need to have the vendors' support/engineering team to troubleshoot when your data pipelines break. Dec 2020 release of PBI Desktop Windows 10 ARM preview So we need to install Microsoft Power BI Consistently exceed goals and expectations by ability to. One big downside, though, is that these low-code tools can be a black box. They make your development cycle a lot faster than developing custom pipelines from scratch.Īnd that typically involves not only developing data pipelines, but also building scheduling and monitoring pieces.īut the question is, are low-code ETL/ELT tools worth the price?Įven if the licensing cost seems expensive, if you look at the reduction in the labor cost and the speed to production, hours needed to maintain the solutions, ROI may be justifiable.Īnd I believe that's what cloud computing and using third party solutions are all about, which is to increase your ROI. If you have Power BI Premium, the CDATA plugin might be able to connect to the xmla endpoint of the dataset. In my opinion, it makes sense for most companies to use low-code ETL/ELT tools like Fivetran, Portable, etc. You can connect to OLAP sources like SQL Server Tabular using this paid for option, but only for On-premise SSAS, or Azure Analysis Service.
0 kommentar(er)
