CONNX DataSync Transformation Server
CONNX DataSync Transformation Server is an ETL solution enabling you to perform limitless combinations of full and incremental change data capture transformations on all of your enterprise data.
Transform ALL of Your Enterprise Data
CONNX DataSync Transformation Server lets you seamlessly extract, transform and load relational and non-relational data throughout your organization.
Many of the ETL tools on the market today require that you provide your own database drivers, a task that can be particularly difficult if you need to connect to data on OpenVMS, UNIX or IBM Mainframe platforms. Or, they require you to do extracts, a task that can be daunting and time consuming.
CONNX DataSync Transformation Server easily solves the complex problem of accessing and joining dissimilar data stores residing on UNIX, Windows, OpenVMS or Mainframe servers by leveraging our secure, scalable and time-tested SQL Data Access engine.
Use SQL to Create Transforms that Span Multiple Source Tables
CONNX DataSync Transformation Server features a Transform Wizard that guides you through the process of setting up simple, single table transforms, or customized transforms using our SQL query builder to join tables across databases in your enterprise. Take advantage of our integrated query builder or write your own SQL statements.
Identify your Target Database
After selecting your source data, the Transform Wizard lets you create a new target table or use an existing table in the database you select to house your transformed data.
From the Transform Wizard's Column Mapping tab you can add, remove, reposition or change attributes on the fields in your target table. Target table names, datatypes, lengths, precisions and scales can all be manipulated from the Column Mapping tab.
In addition to suggested indexes that the Transform Wizard has discovered on your source tables, you can also create new primary, unique indexes for your target tables. In fact, the incremental synchronization capability of DataSync Transformation Server relies on the existence of unique indexes on your target tables. The Transform Wizard makes it easy to combine columns from any of your source tables, regardless of the databases they reside in, to create new and truly unique indexes on your target tables.
Easy to Use
The CONNX DataSync Administrator allows you to create and manage your transforms as well as configure global settings for your synchronization and transformation environment. Use the CONNX DataSync Administrator to schedule incremental or full data synchronizations, launch tasks to run before or after a synchronization and configure automated email notification for status updates on synchronization jobs.
Azure, RMS, Oracle Rdb, VSAM, IMS, C-ISAM, D-ISAM, Micro Focus, DB2, Oracle, Oracle DBMS, Dataflex, POWERflex, SQL server and any OLEDB or ODBC data source.
CONNX is used by more than 3000 organisations world-wide to enable web/application development, data warehousing, business intelligence, ETL, replication, data synchronization, enhanced reporting and data migration.