News for hackers. Stuff that matters.

A comment on Microsoft Wants To Buy Love In Silicon Valley. Parent comment

Re:Microsoft Wants To Buy Love In Silicon Valley by rjbwork on Wednesday February 11, 2015 @04:44PM (#9035913)
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?

[ Parent | on HN ]
Re:Microsoft Wants To Buy Love In Silicon Valley by jd_hicks on Wednesday February 11, 2015 @05:55PM (#9036249)
Azure 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/).
[ Parent | on HN ]
Re:Microsoft Wants To Buy Love In Silicon Valley by bduerst on Wednesday February 11, 2015 @06:14PM (#9036335)
Those 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...
[ Parent | on HN ]
Re:Microsoft Wants To Buy Love In Silicon Valley by rjbwork on Wednesday February 11, 2015 @09:38PM (#9037053)
You'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.
[ Parent | on HN ]
Re:Microsoft Wants To Buy Love In Silicon Valley by bduerst on Thursday February 12, 2015 @12:44PM (#9040065)
Azure is a PAAS, right? OLAP should be one of the native offerings from Microsoft.

Google has BigQuery and AWS has Redshift.

[ Parent | on HN ]
Re:Microsoft Wants To Buy Love In Silicon Valley by rjbwork on Friday February 13, 2015 @06:19PM (#9047840)
Yes 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 :-/
[ Parent | on HN ]
Re:Microsoft Wants To Buy Love In Silicon Valley by mark_l_watson on Wednesday February 11, 2015 @04:53PM (#9035967)
This 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.

[ Parent | on HN ]
Re:Microsoft Wants To Buy Love In Silicon Valley by rjbwork on Thursday February 12, 2015 @10:01AM (#9039007)
I 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.
[ Parent | on HN ]