connx Generix
telephone +44 (0) 1924 500 151
products

evaluation

faq

support

contact

news

home

CONNX for Amazon Redshift

Move 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.



evaluation
overview

architecture

details

case studies

info request
C-ISAM

D-ISAM

DataFlex

DataSync

DB2

Desktop Adapter

infonaut

informix

microfocus

OLEDB Adapter

Oracle

DBMS

Rdb

powerflex

RMS

SQL

Sybase

VSAM