CONNX for Amazon RedshiftMove and synchronize data between Amazon Redshift and our 120+ supported databases.
CONNX for Amazon Redshift provides secure, real-time, read/write access to Amazon Redshift - Amazon's fully managed, petabyte-scale data warehouse solution in the AWS cloud. CONNX for Amazon Redshift delivers a high performance data loader using incremental updates to replicate and synchronize data from our 120+ supported databases into multiple Amazon Redshift nodes.
In conjunction with other CONNX modules, you can perform seamless joins between Amazon Redshift, Amazon RDS and more than 120 supported data sources. Amazon Redshift delivers fast query performance by using columnar storage technology to improve I/O efficiency and parallelizing queries across multiple nodes.
With CONNX for Amazon Redshift, a single metadata model can be created that spans all enterprise data sources and applications requiring data access. The result is an enterprise-wide view of data that provides a reusable, standards-based framework for information access.
CONNX for Amazon Redshift supports the creation of views, which facilitates hiding table relationships from the end user. CONNX views facilitates the creation of heterogeneous joins between multiple disparate databases.
In conjunction with CONNX DataSync Amazon Redshift data can be synchronized with on-premise data, or vice versa. Additionally, DataSync facilitates replicating data between Amazon RDS data sources or Redshift nodes.