Connect is a high-performance data transformation product. With Connect you can design, schedule, and control all your data transformations from a simple graphical interface on your Windows desktop.
Data records can be input from many types of sources such as database tables, SAP systems, Salesforce.com objects, flat files, XML files, pipes, etc. The records can be aggregated, joined, sorted, merged, or just copied to the appropriate target(s). Before output, records can be filtered, reformatted, or otherwise transformed.
Metadata, including record layouts, business rules, transformation definitions, run history and data statistics, can be maintained either within a specific task or in a central repository. The effects of making a change to your application can be analyzed through impact and lineage analysis.
You can run your data transformations directly from your desktop, on any UNIX or Windows server, or schedule them for later execution, embed them in batch scripts, or invoke them from your own programs.