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