Take control of your data with InterSystems IRIS® Cloud SQL and IRIS® IntegratedML®

By Saurabh Mishra, Sr. Partner Solutions Architect – AWS
By Dimitri Restaino, Sr. Solutions Architect – AWS
By Luca Ravazzolo, Product Manager – InterSystems 

InterSystems

Organizations often struggle to make sense of their disconnected data sources. Bringing this information together can be complex and costly, involving data ingestion, transformations, and integration. Gaining insights, into complex data sets, requires expensive data manipulation exercises involving complex Extract Transform Load (ETL) processes and integration with Machine Learning (ML) and Artificial Intelligence (AI) patterns.

InterSystems’ data management solutions powered by AWS enables customers to rapidly deploy and scale applications, gain insights, drive innovation, and transform business operations leading to better outcomes.

InterSystems IRIS Cloud SQL and InterSystems IRIS Cloud IntegratedML are fully managed cloud-native Software as a service (SaaS) offerings that offer customers the fastest time to value for InterSystems data management software. Customers can select the services, Cloud IntegratedML or Cloud SQL, that they require and InterSystems handles the underlying software and infrastructure operations, management, and maintenance.

InterSystems delivers a unified foundation for next-generation applications for customers in over 80 countries. Their approach revolves around a cloud-first data platform that integrates high-performance database management, smart data services, and analytics capabilities. For more than 40 years, InterSystems has delivered the healthcare data integration engine for the world’s most proven electronic medical record used by health systems and governments.

Why use Cloud SQL & IntegratedML

Cloud SQL and Cloud IntegratedML are two offerings from InterSystems that are part of a series of services that can assist in your data fabric and data mesh architectures. InterSystems provides additional products, like InterSystems IRIS data platform, for those organizations that are seeking to build and maintain a coherent, centralized, and unified view of data with embedded interoperability and analytics.

Underlying Architecture

InterSystems leverages AWS Cloud to deploy, run and maintain InterSystems services. Cloud SQL deployment runs on Amazon Elastic Kubernetes Service (Amazon EKS) managed service. The Amazon EKS cluster runs across Availability Zone (AZs) in order to provide the expected service resiliency.

You can select deployment sizes, then get up and running by loading your SQL schemas with various dialects supported (MySQL, Oracle, Microsoft SQL Server, Sybase, Informix, Interbase). Your data can be uploaded through the browser or from an Amazon Simple Storage Service (Amazon S3) bucket.

InterSystems client drivers enable secure access to deployments and supplied from a dedicated location. Developers are guided through the experience through message boxes and links for a comprehensive and optimal user experience.

Cloud SQL and Cloud IntegratedML comprise a series of AWS Lambda functions and Amazon EKS jobs that support the life cycle of an instance from initial provisioning, backups, stopping, and terminating the instances. Figure 1 is a high-level architecture of InterSystems IRIS Cloud SQL and InterSystems IRIS Cloud IntegratedML services

Figure 1 – InterSystems IRIS Cloud SQL and InterSystems IRIS Cloud IntegratedML

How to deploy

You will need an AWS account with a valid AWS Marketplace subscription to access the offering on AWS Marketplace. Once you have subscribed to the listing, you will be redirected to the InterSystems product portal to register and access the service.

In the main InterSystems portal overview page, the deployment details are shown together with notifications and fundamental monitoring metrics. The user can consider upgrading to more performant tiers if necessary for this page. The solution comes with hardened containers with no root access, network policies to sustain secure, audited communication and native Kubernetes Customer Resource Definition (CRD) for low-latency monitoring and storage.

From the InterSystems portal, you select the “Create Deployment” option. You will see a wizard to provision an instance of Cloud SQL with or without the IntegratedML option. Figure 2 below shows the Deployment Details tile with the details of what was provisioned and provides options to shut the instance down, upgrade to include the InterSystems IRIS IntegratedML or go directly to check out the deployment metrics of the running instance.

Figure 2 – Deployment Detail page in InterSystems Cloud Services Portal

You can download the appropriate client drivers and the X.509 certificate from the connection panel like in Figure 3. You can also change the default user password for Cloud SQL in this panel.

Figure 3 – Connecting to InterSystems Cloud SQL

In the same portal you will see the observability metrics as in example Figure 4.

Figure 4 – Built-in Observability in InterSystems Cloud SQL

Conclusion

By using AWS and InterSystems Cloud SQL and Cloud IntegratedML, you can remove the undifferentiated heavy lifting of infrastructure management, and focus on innovation on behalf of your customers. Explore more about Cloud SQL & IntegratedML or head straight to the AWS Marketplace to get started with InterSystems IRIS Cloud SQL.

Contact InterSystems | Partner Overview | AWS Marketplace