Sonra

Data is locked away in complex XML industry data standards. JSON is locked away in proprietary data stores. Flexter can convert any XML or JSON format out of the box to a relational database, text, or Hadoop.

We have listed a few popular XML standards below.

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

Not forgetting custom XML and JSON.

Generating insights from XML/JSON 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/JSON 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/JSON data needs to be organised into a tabular format consisting of rows and columns, i.e. structured data. Flexter automatically converts XML/JSON to structured data.

Flexter completely automates the process of parsing and processing your XML/JSON 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/JSON files is handled gracefully.
Flexter can handle multiple versions of your XSD or the derived JSON schema.

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/JSON input file is loaded only once and shredded into its various elements and components.
Processing can optionally occur in-memory for faster throughput.

Flexter auto-generates:

1. A tabular output schema from XSD (normalised
   relational format) and/or the source XML/JSON files.
2. The column mappings from the XML/JSON 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/JSON 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/JSON. 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.

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