Easily Create, Manage and Deliver Copies of InterSystems Caché

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.

How Catalogic Helps with InterSystems Caché and Epic EHR

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. 

Among the powerful features ECX delivers are:

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. 

How It Works: No More Scripting

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.

Copy Data Management for Epic/Caché

Instant SQL, Oracle, and Cache Aware snaps in one GUI Deliver training and test copies in minutes Integration with Power Systems and DevOps tools

In addition, ECX provides deep integration with Caché which delivers a good deal of high-level functionality generally not found in competing solutions:

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. 

Coverage Details

ECX supports both physical and virtual instances of InterSystems Caché. Support is provided for the following:

  • InterSystems Caché 2015, 2016 and 2017
  • Physical Servers:  AIX 6.1 TL9+, AIX 7.1+
  • Virtual Servers (VMware): Red Hat Enterprise Linux 6.5+

For the latest supported systems and complete support matrix and configuration requirements, consult the InterSystems Caché support page. 

Health Care IT: A #CUBEConversation with Pure Storage and Catalogic Software

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 for InterSystems Caché and Epic EHR

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.

InterSystems Caché with Epic EHR Backup and Recovery Using Pure Storage Snapshots and Replication - Video

InterSystems Caché with Epic EHR Backup and Recovery Using Pure Storage Snapshots and Replication

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.