DATASHEET

CONNX Data Replication for Snowflake®

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 all you need to maintain your Snowflake data warehouse.

Synchronize all your data sources to the cloud with one tool

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’ uptime 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 all you need to unlock your enterprise data wherever it resides.

Key benefits

  • Seamlessly replicate data across mainframe, 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™ and IMS™, and connect to a cloud 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 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.

Connect to 150+ data sources:

  • Adabas
  • Amazon® AWS
  • C-ISAM®
  • DataFlex®
  • IBM® DB2®
  • IMS
  • IBM Informix®
  • MariaDB
  • Microsoft Azure®
  • MySQL®
  • Oracle®
  • PostgreSQL or EnterpriseDB
  • Rdb
  • RMS
  • SQL Server®
  • Sybase®
  • Teradata®
  • VSAM
  • And more
Take the next step:
DEMO
Schedule a demo with a mainframe modernization expert
See how you can access, virtualize or move your mainframe data. Get a live demo of CONNX with one of our product experts.
TECH COMMUNITY
Join the Software AG Tech Community
Collaborate with the CONNX community—and get tips and tricks, test code, and downloads—to help you extend your CONNX solutions into the future. 
ON-DEMAND WEBINARS
Browse our library of webinars
All of our webinars are available to watch on demand. Join mainframe modernization experts and analysts as they discuss, elaborate and demonstrate best practices.
Are you ready to unite cloud and mainframe data?
Become a data-driven organization by leveraging all the information in your enterprise, however it’s structured—without changing your core systems.  
ICS JPG PDF WRD XLS