AWS Announces 4 Zero-ETL Integrations to Make Data Access and Analysis Faster and Easier Across Data Stores

LAS VEGAS, Nov. 29, 2023 — At AWS re:Invent, Amazon Web Services, Inc. (AWS), an Amazon.com, Inc. company (NASDAQ: AMZN), today announced new integrations that enable customers to quickly and easily connect and analyze data without building and managing complex extract, transform, and load (ETL) data pipelines. New Amazon Aurora PostgreSQL, Amazon DynamoDB, and Amazon Relational Database Service (Amazon RDS) for MySQL integrations with Amazon Redshift make it easier to connect and analyze transactional data from multiple relational and non-relational databases in Amazon Redshift.

Credit: Michael-Vi/Shutterstock

Customers can also now use Amazon OpenSearch Service to perform full-text and vector search on DynamoDB data in near real time. By making it easier to connect to and act on their data, no matter where it lives, these zero-ETL integrations help customers leverage the breadth and depth of AWS’s leading database and analytics services to discover new insights, innovate faster, and make better data-driven decisions. To learn more about unlocking the value of data using AWS, visit aws.amazon.com/data.

“To help customers fuel innovation with data, AWS offers the industry’s broadest and deepest set of data services for storing and querying any type of data at scale,” said Dr. Swami Sivasubramanian, vice president of Data and Artificial Intelligence at AWS. “In addition to having the right tool for the job, customers need to be able to integrate the data that is spread across their organizations to unlock more value for their business and innovate faster. That is why we are investing in a zero-ETL future, where data integration is no longer a tedious, manual effort, and customers can easily get their data where they need it. The new integrations announced today move customers toward this zero-ETL future, and we are continuing to invest in this vision to make it easy for customers to integrate data from across their entire system, so they can focus on driving new insights.”

Data is any organization’s differentiator. However, organizations have different types of data coming from different origins at varying scales and speeds, and the uses for this data are just as varied. For organizations to make the most of their data, they need a comprehensive set of tools that accounts for all of these variables, along with the ability to integrate and combine data spread across multiple sources.

To help customers derive value from their data, AWS offers a comprehensive set of data services, so customers always have the right tool for the job. But to put data at the center of their businesses, customers need to be able to connect all of their data, regardless of where it lives. That is why AWS has invested in zero-ETL capabilities that remove the burden of manually moving data.

This includes federated query capabilities in Amazon Redshift and Amazon Athena—which enable customers to directly query data stored in operational databases, data warehouses, and data lakes—and Amazon Connect analytics data lake—which makes it easier for customers to access contact center data for analytics and machine learning. It also includes new zero-ETL integrations between Salesforce Data Cloud and AWS storage, data, and analytics services to enable customers to easily and seamlessly unify their data across Salesforce and AWS for better, faster insights.

The integrations announced today build on AWS’s zero-ETL foundation to remove the burden of building and maintaining data pipelines, so customers can quickly and easily connect all of their data, no matter where it lives.

• New Amazon Aurora PostgreSQL, Amazon DynamoDB, and Amazon RDS for MySQL zero-ETL integrations with Amazon Redshift make it easier to analyze transactional data without building and maintaining data pipelines.
• Amazon DynamoDB zero-ETL integration with Amazon OpenSearch Service enables full-text and vector search on transactional data in near real time.

About Amazon Web Services

Since 2006, Amazon Web Services has been the world’s most comprehensive and broadly adopted cloud. AWS has been continually expanding its services to support virtually any workload, and it now has more than 240 fully featured services for compute, storage, databases, networking, analytics, machine learning and artificial intelligence (AI), Internet of Things (IoT), mobile, security, hybrid, virtual and augmented reality (VR and AR), media, and application development, deployment, and management from 102 Availability Zones within 32 geographic regions, with announced plans for 15 more Availability Zones and five more AWS Regions in Canada, Germany, Malaysia, New Zealand, and Thailand. Millions of customers—including the fastest-growing startups, largest enterprises, and leading government agencies—trust AWS to power their infrastructure, become more agile, and lower costs. To learn more about AWS, visit aws.amazon.com.

Source: AWS