XML File Conversion, Manipulation and More
Though XML is a popular file interchange format for SOA, database, and other applications, it has
not been a practical format for carrying large data volumes. In addition, conversions betwen legacy
index or flat files and XML rely on slower parsing
technologies like XSLT and do not simultaneously enable processing. Transforms
using XQuery cannot turn high volumes of XML data into meaningful information
in XML (or any other format) quickly, if at all. There
simply has been no efficient way to rapidly convert, process, protect,
or create large XML files.
For example, you may need to:
• Sort a huge XML file
You may even need to perform more than one of these functions at the same time, against many massive source and target files.
• Extract data, or report, from an XML file
• Convert a CSV, LDIF, or other file to XML
• Convert XML to text, CSV, LDIF, ISAM, etc.
• Encrypt or de-identify fields in an XML file
• Load XML data to a spreadhseet or database
• Create an XML file from a legacy or extract file
• Generate test data in XML file formats
IRI delivers XML and other file conversion functionality in two packages, which you can choose based on the level of need:
XML File Conversion Only
Newly available from IRI is a low-cost, data migration product called NextForm. NextForm allows you to convert huge, flat XML files* to other formats (like CSV, LDIF, COBOL, text, etc.) or from those other formats into XML or other file types.
NextForm includes an XML file parser to automatically create the XDEF field layouts used in the file conversion scripts.
NextForm also supports data type conversion at the field level, and the remapping of record layouts.
Note that NextForm file definitions also work in SortCL so that you can re-use your metadata if you someday want to upgrade to CoSort's fast transformation, custom reporting, and/or data-centric protection functions for your files.
XML File Conversion & Transformation
With the CoSort package, and its SortCL tool in particular, you can easily convert, transform, report
from, and create valid, well-formed XML files that represent structured
data at any volume level.
In fact, you can declare one or more XML and non-XML files for input and
output as part of any CoSort job involving data:
• filtering (select, scrub, links to DQ tools)
• transformation (sort, join, aggregate, calc, etc.)
• conversion (data-type and file-format migrations)
• reporting (CDC, detail and summary formats)
• protection (field encryption, de-ID, masking)
CoSort makes all of these actions - one or more at a time - available to data
architects who need to work with CSV, XML, LDIF, ISAM, Vision, text and
other large flat files.
XML Test Data
Do you need test data in XML file formats? If so, see IRI's RowGen product. RowGen uses the same layout metadata as CoSort and NextForm so you can easily move between test data generation and real data transformation.
XML Data Protection
Do you need to encrypt, mask, or otherwise de-identify the field data within your XML files? If so, see IRI's new FieldShield software. FieldShield uses the same layout metadata as NextForm and RowGen so you can easily move between format conversion or test data generation and XML data protection.
* You can process only XML data elements that conform to a flattened structure and extract one element of the same name at a given level. If you have multiple tags of the same name, NextForm and CoSort (SortCL) will extract the last occurring tag of a given name. Field names must be unique and comprise a single record with no additional dependencies.
> Large XML Files
Solutions > File Interchange
Products > NextForm
Products > CoSort > SortCL
Products > RowGen
Products > FieldShield
Thank you for sending us a request for information. We will get back to you shortly.