Jim Ericson of DM Review emailed the excellent questions:
Does DATAllegro give MSFT full-service high end data warehousing capability? If not, what is missing?
My quick answers are:
- Two things:
- Hard-core multi-user concurrency.
- Support for more esoteric analytic tools and functionality
Both are largely a matter of product maturity, and as a young company DATAllegro isn’t quite there yet.
That said, integration with Microsoft SQL Server is apt to be a big help in addressing both issues. This seems pretty obvious in the case of feature support – if the features already are integrated with SQL Server, and SQL Server is integrated with DATAllegro, then a kind of transitivity should entail, in which most of the features quickly work well with DATAllegro/SQL Server too.
And I think this optimistic scenario will hold true for multi-user concurrency as well. I don’t know whether DATAllegro can do a good job for more than a dozen or two concurrent users today, but even if it can’t, the natural next-generation iteration of that would be good support for a few hundred. But suppose an enterprise wants to put 1000s or even 10s of 1000s of users on a data warehouse at once. It almost certainly will want to do so against a database of fairly limited size, probably no larger than the couple of terabytes SQL Server does an OK job on today. And DATAllegro has done some work to make hub-spoke architectures pretty simple to implement, allowing one to split out a data mart for demanding access while keeping it synchronized automagically with the main data warehouse.
Thus, I think that within a couple releases, only a few enterprises will be unsatisfied with the enterprise data warehouse capabilities of the Microsoft/DATAllegro combination.