Transformations provide support for ETL (Extract, Transform, Load) Projects. Datasync offers the ability to transform the source feeds and produce a target table on a selected target database. Some examples of the types of supported transformations are the ability to filter columns from the source table, add columns to the target table, join multiple source tables into a single target table, provide expressions to modify the data in a source column before sending it to the target table, and more. Before a transformation is created, it is often a good idea to take advantage of CONNX Tools to help design the potential transformation. During the DataSync design process, the following CONNX Tools can offer valuable support:

Both of these tools are available in the CONNX Driver section of the Start menu on your server.