Combine Multi-Target, Multi-Format Custom Reporting with Data Transformation
Challenges:
Custom Reports from large sets of data can consume a large amount of processing resources -- and thus be
unacceptably slow to produce.
If you need multiple reports and formats from the same set of source data, you may be using many duplicated design and execution steps.
They may be complex, or require the use of tools or legacy programs that are difficult to learn, use, or maintain.
You'd probably rather have an easier, faster and less costly way to produce your custom reports.
Solutions:
The CoSort product's SortCL tool is not only a high-performance data transformation engine;
it is also a fast, full-featured custom report generator for large volumes of information.
SortCL accepts one or more input files in the same or different formats, and allows you to specify multiple output targets.
You can use SortCL to write to those targets in one or more custom report formats. And those reports can be built in the same in the same job script and I/O pass along with data warehouse transformation
and field-level privacy protection functions. In other words, you can create
multiple custom reports while you are integrating and staging data.
You can use SortCL to produce complex detail and summary reports with meaningful, actionable information in custom formats.
For example, you can join transactions with archive files, cross-calculate sale costs against customer balances, aggregate and display
selected records, mask personal details, and format the report for a web browser with header and footer records, and other special formatting.
Change data capture, or delta, reports are also possible using joins and conditional output specifications.
Case Studies
White Papers
