TrustRadius: an HG Insights company

InterSystems Caché (legacy product)

Score10 out of 10

15 Reviews and Ratings

What is InterSystems Caché (legacy product)?

InterSystems Caché® was a multi-modal operational database for transaction processing applications, that provided several APIs to operate with same data simultaneously: key-value, relational, object, document, and multidimensional.

Media

The structure of InterSystems Caché Database Engine

Not for all but good for some

Use Cases and Deployment Scope

Platform for a clinical laboratory middleware software. Using InterSystems solutions for frontend (ZEN), backed (COS) and storage (Caché DB). Communication interfaces to other hosts/instruments not using embedded communication solutions. Installed on-premise to manage communication and transformations between instruments and multiple hosts, with the possibility of doing limited LIS functions.

Pros

  • Performance
  • Robustness
  • Reliable

Cons

  • Resource intensive
  • Deployment
  • Complexity

Most Important Features

  • Reliable
  • Robust
  • Support

Return on Investment

  • Large technical debt
  • Great support and resolutive team

Other Software Used

Oracle Java SE

Cache Is Great and InterSystems Wants You to Be Great Too

Pros

  • It's an object oriented database with relational access, making the vast volume of data ETL fast and as efficient as we are able to make it.
  • Easy to install and doesn't take a lot of time to get a test environment running.
  • CSP is a fascinating web development technology that easily connects a user application to the Cache handled data.

Cons

  • The great functionality hides behind an old UI that can be cumbersome to navigate, making Cache configurations take more time.
  • The easy installs of Cache need specific setups to work well, and if yours is unique or if your servers are highly specialized on a networking level in terms of ports, VMs, or otherwise, then there may be some difficulties getting things to work.

Return on Investment

  • Because Cache offers so much, then the specialized development on our end is reduced dramatically. It can be the complete package for certain organizations, and in terms of ROI, Intersystems products have no equal.

Alternatives Considered

IBM DB2, Microsoft SQL Server and Oracle

Other Software Used

PyCharm, Eclipse, Visual Studio IDE

Non relational DB - yes you can!

Pros

  • Rapid development
  • Integration with other systems using SQL, WS, FTP, eMail, etc.
  • A complete solution that includes not only the DB itself but also all the other management tools, development tools, IDE, source control etc.

Cons

  • The IDE IntelliSense needs to be improved.

Return on Investment

  • A fast ROI due to its rapid programing language allowing the developers to write reliable code in a very short period of time.

Other Software Used

GitHub, Microsoft Office 365

Simple review about InterSystems Cache

Pros

  • Fast development
  • the language light to learn.
  • Different ways to access data
  • Good internal documentation, which is also available online.

Cons

  • Popularity should be better, after so many years.

Return on Investment

  • Implementation time could be speeded up
  • It is very flexible and attractive