Forum Discussion
Power Query & M for Populating Any Database
I have been looking for an easy-to-use, cost-effective ETL tools to populate a typical, relational, star schema data warehouse. Recently, I think I read that the Get Data / Power Query / M experi...
Oh, I see.
Well, I wish "Get Data" could be a generic, cloud-based service...
- With all the same (and ever-increasing) options for data sources;
- And the same easy-to-use query interface, but also full power of M for more advanced users;
- And a variety of options for data targets -- the list of which might also be ever-increasing, but obvious ones would include:
- Analysis Services tabular (Azure and on-premises)
- SQL Server databases (Azure and on-premises)
- Other databases like MySQL, PostgreSQL, etc. (cloud and on-premises)
- Flat files like Excel and CSV
From what I've seen in my (cursory) research, Microsoft would have a(nother) market-leading ETL product to offer. Right?
Or, what else are you all using that you might recommend as a comparable alternative?
I would be interested to see what the community can share around this. I can see where a DB agnostic ETL tool would be very powerful to users, but also possibly detrimental to the DB providers as this would make their tech less sticky.