Sonra

XML data is locked away in complex XML industry data standards. Flexter can parse any XML industry data standard out of the box.

We have listed a few popular standards below.

• - HL7 (Healthcare - patient records)
• - HIPPA, CDISC (Life sciences - clinical trials)
• - FixML, SWIFT, ISO20022, XBRL (Finance - payments)
• - WITSML (Energy)
• - OTA, NDC (Travel)
• - DITA (Publishing)

Not forgetting custom XML, JSON, Excel/CSV and many more propietary data structures.

Generating insights from XML data is a largely, complex, slow, and labour intensive process. Business-critical and strategic decisions are taken without considering all of the available information simply because it’s not readily available, or it is too expensive to access.

XML data formats are primarily designed for exchanging data in the enterprise. They are optimised to help employees get on with their daily job. However, for the purpose of data analytics XML data needs to be organised into a tabular format consisting of rows and columns, i.e. structured data. Flexter converts XML to structured data.

Flexter completely automates the process of parsing and processing your XML files. No coding or ETL development is needed. Its execution engine auto-populates the target schema.
XML violations against the XML Schema Defintion are handled without aborting the parse process.
Removing or adding elements in XML files is handled gracefully.
Flexter can handle multiple versions of your XSD.

Use Flexter’s powerful Schema Browser to immediately gain real insights based on your optimised data structures.
Browse the XSD, the optimised target schema, and the lineage between the two.

Each XML input file is loaded only once and shredded (via XPath) into its various components.
Processing can optionally occur in-memory for faster throughput.

Flexter auto-generates:

1. A tabular output schema from XSD (normalised
   relational format).
2. The column mappings from the XML data source
   to the target table.
3. The table relationships of the target schema and
   their primary and foreign keys.

Flexter ships with various optimisation algorithms. It performs a deep analysis of the input XML and XSD. It translates the insights into a simplified target schema that gets rid of redundant data points.

Elevate
Analyses relationships inside XSD and XML. Optimises relationships in target model, e.g. based on analysis converts 1:N to 1:1 relationship

Smart Re-use
Eliminates duplicated and redundant data points by making them re-usable.

Rename
Shortens target column names to a predefined length while preserving maximum meaning, e.g. column size limitations in RDBMS limitations (Oracle etc). Resolves naming conflicts.

Sonra is here to help at any time.

In addition to Flexter, we also offer numerous Big Data services and solutions.

If you need any assistance, have any questions, or would like to find out more about us, Contact Us directly.