telephone +44 (0) 1924 500 151
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.

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

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

Feature Benefit
Create transformations that seamlessly combine data from multiple data sources. Simplifies data warehouse implementation.
Detects which records have been added, deleted, or changed, and inserts, updates, or deletes the corresponding data in the data warehouse snapshot tables. Reduces time and resource utilization required to update target data store.
Perform incremental inserts and updates based on analysis of existing timestamp fields in the source tables. Increases performance in distributed and wide area networks.
Select single tables, use our integrated graphical query builder to specify source data from multiple tables, or write custom SQL statements. Flexible ETL designer interface supports beginning and advanced users.
Select source data using complex SQL operations such as views, aggregation, table joins, subqueries, filtering and sorting. Provides advanced control over source data selection.
Complete, built-in scheduler service runs data synchronization jobs at the appropriate time. Simplifies synchronization task automation.
Task execution - command, batch and executable files can be triggered to run before and/or after a synchronization job runs. Expands the reach of transformation jobs with command line support.
Each file in the synchronization process may be scheduled independently or as a group. Offers flexibility in synchronization task automation.
Built-in email notification makes it easy to for staff to determine the status of both manual and scheduled ETL tasks. Minimizes the time and effort required to monitor transformations.

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.

Click on the CD to request an evaluation and realise how your organisation can benefit from using CONNX
case studies
info request
Desktop Adapter
OLEDB Adapter