IT Brief UK - Technology news for CIOs & IT decision-makers
Story image
Amazon enhances data access with four new Zero-ETL integrations
Thu, 30th Nov 2023

Amazon Web Services (AWS) has announced the launch of four new zero extract, transform, and load (Zero-ETL) integrations aimed at enhancing data access and analysis across a wide range of data stores. The integrations poised to achieve this added efficiency are Amazon Aurora PostgreSQL, Amazon DynamoDB, and Amazon RDS for MySQL with Amazon Redshift. The perceived benefit to customers is a seamless ability to scrutinise data from an array of sources without having to build and manage custom data pipelines.

The fourth integration allows Amazon DynamoDB with Amazon OpenSearch Service to enable full-text and vector search on operational data nearly in real-time. Companies such as Grabyo, iCIMS, Kaplan, Inc., Muzz, Orion Advisor Solutions, and United Airlines are key among customers keen to benefit from the new AWS zero-ETL capabilities.

Dr. Swami Sivasubramanian, Vice President of Data and Artificial Intelligence at AWS, emphasises the value of these integrations in tapping into diverse data outlets across an organisation and unlocking their potential. "From integrating the data that is spread across their organisations to accelerating innovation, we're investing in a zero-ETL future," he attested. Expounding further, the VP revealed that the new integrations form part of AWS's commitment towards enhancing data integration and easing the tediousness associated with labour-based effort, therefore allowing firms to derive new insights.

Understanding that different organisations have unique data types from varied sources and scales, AWS has sought to provide an assortment of tools to cater for these variables. AWS has recognised the challenges of moving data, including the cost, complexity, and error-prone nature of architecting one's own ETL pipelines. As such, it has introduced capabilities to remove the burden of manually moving data and promote ease of data access from any location.

AWS’s new Zero-ETL integrations will allow quick access to data from commonly used relational and non-relational databases in Amazon Redshift. This will enable customers to analyse transactional data from multiple high-performance databases. These integrations will also allow data to be available in Amazon Redshift almost immediately after it is written in other databases like Aurora MySQL, promising a comprehensive analysis of company data.

In another development, the DynamoDB Zero-ETL integration with OpenSearch Service will facilitate a near real-time full-text and vector search on transactional data. This integration will enable customers to comfortably analyse their DynamoDB data, through automated data replication into the OpenSearch Service within a matter of seconds.

Leading industry players are already excited about taking advantage of the benefits brought by the integrations. Mun Wai Kong, CTO at Grabyo, noted that the new Amazon DynamoDB zero-ETL integration with Amazon Redshift will result in rapid transition from transactions to insights, relieving the data engineering team of the burden of pipeline management. Ben Barresi, VP of Cloud Hosting and Engineering at iCIMS, anticipates that the Aurora PostgreSQL Zero-ETL integration with Amazon Redshift will ease the burden of data pipeline management for their engineering team.

Throughout the industry, the consensus is that these new Zero-ETL integrations will not only help businesses improve reliability, scalability, and cost efficiency, but also free engineers to concentrate on strategic projects. From facilitating user experience optimisation to powering real-time data processing solutions, the new integrations appear poised to help transform various industries. It seems that these advanced AWS data integrations are a step forward in the future of data management and analysis.