Zero-ETL integrations

Zero-ETL is a set of fully managed integrations by Amazon that minimizes the need to build ETL data pipelines for common ingestion and replication use cases. It makes data available in Lakehouse architecture of Amazon SageMaker and Amazon Redshift from multiple operational, transactional, and application sources. Currently Amazon Glue Zero-ETL supports DynamoDB, Oracle Database@Amazon and SaaS sources like Salesforce, SAP, Zendesk as sources. With zero-ETL integration, you have fresher data for analytics, AI/ML, and reporting. You get more accurate and timely insights for use cases like business dashboards, optimized gaming experience, data quality monitoring, and customer behavior analysis. You can make data-driven predictions with more confidence, improve customer experiences, and promote data-driven insights across the business.

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools.

Lakehouse architecture of Amazon SageMaker unifies all your data across Amazon Simple Storage Service (Amazon S3) data lakes and Amazon Redshift data warehouses, helping you build powerful analytics and AI/ML applications on a single copy of data. Lakehouse architecture of Amazon SageMaker gives you the flexibility to access and query your data in-place with all Apache Iceberg compatible tools and engines. With SageMaker Lakehouse, you also have the flexibility to access and query your data in-place with Apache Iceberg compatible tools and engines. Additionally, you can secure your data with integrated, fine-grained access controls, that are enforced across all your data in all analytic tools and engines. Define permissions once and confidently share data across your organization.

Zero-ETL capabilities in Amazon Glue

Zero-ETL integrations in Amazon Glue simplify data ingestion and replication from Amazon data services and third-party applications to Amazon destinations.

Amazon services supported as zero-ETL sources in Amazon Glue include:

Third-party applications supported as zero-ETL sources in Amazon Glue include:

Self-managed databases supported as zero-ETL sources in Amazon Glue include:

For more information about zero-ETL integrations from self-managed sources, see Amazon zero-ETL integration for self-managed database sources.

Amazon services supported by Zero-ETL targets in Amazon Glue include: