The CONNX for Amazon Redshift module provides secure, real-time, read/write access to Amazon Redshift – Amazon's fully managed, petabyte-scale data warehouse solution in the AWS cloud. The CONNX solution delivers a high performance data loader with incrementals, data replication and synchronization from cloud or from any data source into multiple Amazon Redshift nodes. In conjunction with other CONNX modules, you can perform seamless joins between Amazon Redshift, Amazon RDS and more than 110 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 Data Sync, Amazon Redshift and RDS data can be synced with on-premise data, or vice versa. Additionally, DataSync facilitates replicating data between two or more Amazon RDS data sources or Redshift nodes.