20 ms·
A huge sticking point for us right now is that Azure has no data warehousing capabilities. You're basically limited to "spin up a huge, expensive VM and instal
by rjbwork 12y ago
A huge sticking point for us right now is that Azure has no data warehousing capabilities. You're basically limited to "spin up a huge, expensive VM and install SSAS on it and make sure you have an expert DBA around that knows his way around all the little nuances of MS-SQL and SSAS".
It is honestly, in my opinion, Azure's current biggest failing. We use cutting edge features and marketplace offerings when we can and the space seems ripe for disruption with companies like Birst, Spotfire, and others really going on the offensive. Microsoft has one of the most mature Data Warehousing offerings for the traditional environment, and it seems crazy that after 5 years there's nothing built into Azure for it.
All that said, do you know of any plans, timelines, or similar services to a fully hosted SSAS-like Data Warehousing solution?
- mark_l_watson 12y agoThis might be what you are looking for, but I think Azure Marketplace has Cassandra, MongoDB, CouchDB, etc. AWS does offer some very special purpose data stores like DynamoDB and SimpleDB but I have not used them much.
- rjbwork 12y agoI may have to look into the Cassandra one, since there is apparently a Data Warehousing framework called Spark that is built on top of it. The others are not suitable to OLAP processing or data warehousing I believe.
- jd_hicks 12y agoAzure has multiple database-as-a-service offerings including SQL (azure.microsoft.com/en-us/services/sql-database/), DocumentDB (azure.microsoft.com/en-us/services/documentdb/), and Redis Cache (http://azure.microsoft.com/en-us/services/cache/ http://azure.microsoft.com/en-us/services/cache/).
- bduerst 12y agoThose aren't OLAP replacements though, right? You would still need to manually build an OLAP db from the lower level to report on them. Maybe I'm wrong since I haven't used Azure...
- rjbwork 12y agoYou're right, Azure SQL is very limited in terms of being quite different from non-hosted SQL offerings. You can't just throw OLAP on top.
- bduerst 12y agoAzure is a PAAS, right? OLAP should be one of the native offerings from Microsoft. Google has BigQuery and AWS has Redshift.
- rjbwork 12y agoYes they should. It's literally the only big thing lacking IMO at the moment...hell they even have a fully automated machine learning pipeline offering that can auto-generate APIs from trained models...But no OLAP :-/