Forum OpenACS Q&A: OT: ConnX real-time OLAP
I don't have any use for it myself, but I stumbled across the company because Dann Corbit <DCorbit@connx.com> seemed to be saying various smart things about sort algorithms on the PostgreSQL Hackers mailing list. Anyway, it sounds kind of interesting. Support for 11 different databases, Oracle, PostgreSQL, Sybase, SQL Server, etc. From their website:
"The CONNX Oracle module provides secure, real-time, read/write access to Oracle databases running on any platform."
"The CONNX SQL Server module provides secure, real-time, read/write access to SQL Server."
"In conjunction with other CONNX modules, you can perform seamless joins between two or more supported disparate databases. With CONNX a single metadata model can be created that spans all enterprise data sources and applications requiring data access."
... and then they ask about Europe and he says it needs an adapter.
Jon Udell keeps writing glowing reviews about this product, but I have my doubts. I've never seen a project where a simple, periodic synchronization script (or replication, if you're gutsy) wasn't preferable to
1) running an ISV's sales force gauntlet, and
2) creating a major new architectural dependency.