August 27, 2014 at 2:17 pm
Anyone using this and having good or bad experiences?
http://www.intersystems.com/our-products/cache/cache-overview/
As a SQL Server DBA I not extremely happy, but I am always open to new things. Can't find much on google, hoping someone out here has some real world experience.
August 28, 2014 at 8:17 am
Never heard of it.
September 4, 2014 at 7:12 am
I've deal with Cache although through an ODBC connection to a Credit Union core product called USERS/Datasafe. It's an odd duck, having evolved from MUMPS. (Try Google/Wikipedia for more details...)
I never really build nor do any admin work on the actual application or system, my interaction is limited to data extraction, so I do a lot of aggregation after the initial extraction.
September 5, 2014 at 10:14 am
It's a very odd database that has some quirks and few of the properties that you'd find in most relational databases, but it does have a reasonable enough SQL-like syntax.
My exposure to it is through an Avaya telephony product as a source for an ETL. We've had some issues with it where it'll throw unhandled exceptions if you try to run long running selects that join between tables that are being updated at the time, but other than that, it's been manageable!
Basically, if you know SQL, it's easy enough to set up a linked server and work with it through OPENQUERY if you just need to extract some data from some existing system. I wouldn't touch it with a barge pole as a database engine to develop with.
September 5, 2014 at 10:18 am
Thanks for the feedback. Upper management is looking for it to replace SQL Server. Hopefully between myself and the development team we will have enough information to talk them off the ledge.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply