CONNX Data Replication
for Snowflake®
Synchronize all your data sources to the cloud with one tool
Realize all the benefits of moving your data warehouse to the cloud while keeping all your diverse
data sources in sync with CONNX. With more than 150+ database adapters and a distributed SQL
Engine, CONNX is the only tool you need to maintain your Snowflake data warehouse.
You have made the smart decision to stop paying exorbitant fees and move your data warehouse to Snowflake— the data warehouse built for the cloud. Now you need to ensure your data in the cloud is reliable and up-to-date while not compromising your source systems’ up-time and performance. With CONNX, you can replicate your enterprise data from virtually any source to the cloud, capturing changes from single or multiple data sources. In one integrated environment, CONNX provides connectivity to a wide spectrum of databases—from legacy, non-relational and relational databases to data marts and big data warehouses —residing on diverse platforms such as IBM® mainframe, HP® OpenVMS, iSeries® (AS/400), UNIX®, Linux®, Windows® and the cloud. With more than 150 database adapters, CONNX is the only tool you need to unlock your enterprise data wherever it resides.
Key benefits
• Seamlessly replicate data across legacy, RDBMS, big data and the cloud
• Save costs by using only one tool to connect data across cloud and on-premises environments
• Transform legacy data sources, such as VSAM™, IMS™ or Db2®,and connect to a data warehouse environment like Snowflake
• Integrate data in near real time
• Get up and running fast, within hours of connecting source and target
• Reduce manual operations
• Quickly adapt data transformation to changing requirements
Features
Seamless data replication
Maintain your data warehouse in the cloud by synchronizing your data sources with minimal effort and minimal system requirements.
Widest range of database adaptors
Connect to 150+ data sources on mainframe, midrange, desktop and cloud platforms with standard SQL connectivity. CONNX DB Adapters provide read/write SQL data access supporting ODBC, OLE DB, JDBC®, J2EE® and .NET® technologies.
Unique support for legacy data
Synchronize your cloud-based data warehouse with legacy and non-relational data sources such as Adabas, VSAM, IMS, Rdb and RMS in an easy, standardized way without disrupting operations.
Metadata management
Through metadata management, you create a lexicon that combines all your data into a single, comprehensible structure without altering the source structures.
Data transformation
Take complete control over target database attributes including table and field names, data types, lengths, scales and precisions. Easily combine columns from any source table regardless of database type, and create new and unique indexes on your target table.
Extract Transform & Load (ETL)
Manage single- or multi-table transformations and synchronizations using an integrated query builder, or write your own SQL statements.
Replicate on demand
Scale your synchronization tasks based on demand—simply schedule updates for low-use periods, such as after normal business hours or as frequently as every minute when your business requires more
up-to-date information.