InterSystems Caché® is an advanced database management system that offers lightning-fast performance, massive scalability, and robust reliability. As such, it drives some of the most mission-critical applications, including those used by governments, businesses, and health care organizations (such as the Epic EHR set of applications).
Like other enterprise database users, Caché users are faced with copy challenges. Whether trying to meet stringent data recovery requirements or delivering data sets for training, test, or development, organizations are struggling to meet the demand.
For this reason, Copy Data Management (CDM) is becoming a must-have solution for enterprises running InterSystems Caché. Catalogic ECX integrates storage array copy processes (snapshots, replication, clones) with InterSystems Caché, allowing users to leverage their existing storage infrastructure to automatically create, track and deliver fresh copies of Caché databases to those business units that require them.
By orchestrating the creation and use of storage snapshots and replicas with InterSystems Caché, ECX becomes a powerful, next generation copy solution, whether used for recovery scenarios or serving copies to data consumers. ECX integrates specifically with the Caché APIs, avoiding the need for pre-scripts/post-scripts for snapshotting, as well as for recovery mounts. Coupling this with the “in-place” copy data management benefits of Catalogic across multiple storage platforms, ECX is truly an industry leading solution for protecting and recovering Epic EHR and Caché environments.
Complete Copy Automation
With ECX, you assign easy-to-use policies to Caché workloads, and ECX does the rest. That includes snapshot and replication scheduling, copy retention cycles, copy location, and so on. All copies are application-aware.
Instant Database Recoveries
Instantly recover back to the original location (as in a DR scenario) or to alternate servers (for training, test-dev, etc.) without the need to configure and write pre- and post-mount scripts.
Automate Dev-Test Environments
Create a dev-test Caché instance from a bare Linux image within minutes. No more waiting for copies or using stale data.
Low-Impact Storage Snapshots
Because ECX uses storage array snapshots, the impact on Caché is near zero and the servers don’t need to participate in any data movement for protection or recovery. This is especially important for Epic EHR environments, because Epic imposes exacting standards on maintaining minimum I/O performance.
Full Stack Support
ECX includes full stack automation in addition to supporting Caché databases. For example, ECX supports SQL Server, Oracle, file systems, VMware VMs and so on, giving you a single solution across your infrastructure.
With ECX, users create copy policies that define key copy metrics: how often to make copies, where the copies will reside (local, remote or both), how long copies are retained and so on. Once a policy is created, it can be applied easily to any Caché workload. No more complex scripting or working with multiple tools; just click-and-apply ease of use.
The ECX copy process is agentless, giving you true application awareness without the maintenance headaches of agent-based solutions.
The meta-data catalog at the core of ECX tracks all copies, allowing you to search, audit and report on copy data. ECX also handles copy deletion, ensuring that you only retain the data you really need.
Automatic Discovery of Caché Instances, DB Paths, Journal Files, etc.
Unlike with scripted solutions which require you to know where all the databases reside on the storage, ECX automatically discovers database locations. It also picks up new databases when they are added, and drops databases that have been deleted. This is a dramatic reduction in management overhead compared to scripted tools. ECX also understands database paths, journal file locations and so on.
Support for AIX, Linux and pRDMs
Catalogic supports Cache on the IBM AIX operating system running on Power Systems servers. This configuration is particularly prevalent when Cache is used along with Epic EHR software. Catalogic also supports Linux environments, including virtual servers that use physical RDMs.
Automated Freeze and Thaw through API integration
ECX eliminates the need for pre- and post-snapshot scripts and integrates directly with the Caché APIs.
Automate GUID Handling
One of the challenges with using data copies is that if the same GUID (Global Unique Identifier) appears on a network, it can inadvertently take on a production profile when it’s meant for test or development. With Catalogic, you can bring up Caché instances and update the GUID automatically to avoid any disruption.
Integration with DevOps Tools
Organizations are increasingly moving toward a DevOps model of software development. To support this, all Catalogic features can be driven via our REST API. In addition, we have native plug-ins with popular tools such as Puppet, Jenkins, etc. Catalogic fits perfectly into your development automation.
In this discussion filmed at Pure //Accelerate 2017, Vik Nagjee, CTO of Healthcare for Pure Storage, and Sathya Sankaran, Director of Systems Engineering for Catalogic software, sit down with hosts Dave Vellante and Stu Miniman to discuss healthcare IT and the use of Pure Storage and Catalogic Software to support Epic EHR applications running with InterSystems Caché and SQL Server databases.
Copy Data Management is fast becoming a must-have solution for any Epic EHR environment. Catalogic ECX provides native application aware integration with InterSystems Caché and Clarity databases (SQL), VMs and file systems to automate the creation and use of Caché database copies — snapshots, clones and replicas – on your existing enterprise storage infrastructure. This allows you to meet Epic protection and recovery requirements as well as provide quick, easy and secure access to clones or full copies for development, testing, release, MDR, SUP, Build and training environments. ECX supports Caché on Red Hat Linux (virtual and physical) and AIX.
Healthcare IT is challenged by having to make quick and efficient copies of InterSystems Caché databases to support Epic EHR. Copies are needed for both recovery as well as use cases such as test-dev, analytics and training. This six minute video shows how easily Catalogic ECX can automate the creation, recovery and distribution of Caché database copies leveraging Pure Storage FlashRecover technology. Support is available for physical servers running AIX or Linux, and virtualized servers running Linux.