Tag: SSIS

AdaptX clinical management software uses electronic medical records (EMRs) to derive insights—enabling providers and clinical leaders to efficiently leverage real-world data to transform patient care. This post explores how AdaptX built a modern data architecture using Amazon Athena, AWS Lambda, and AWS Step Functions to automate the extraction, transformation, and loading (ETL) of clinical data from provider EMR systems. Results included improved accuracy, scalability, and a better end-customer experience.

Many Windows solutions have used Microsoft SQL Server Integration Services (SSIS) as a method for performing ETL operations. Legacy SSIS packages that have been handed down to different developers over the years can be complex, cumbersome, and difficult to support. See an architecture and several techniques Cognizant uses to help clients with ETL operations based on legacy SSIS packaging move their applications to the AWS Cloud.