Flexter

Your XML data liberator

Flexter is a distributed and secure big data solution for processing XML. It is designed to provide rapid access to complex & diverse XML data locked away in industry data standards or other proprietary XML formats.

Try Flexter for free

Why choose Flexter?

Unlock your XML data for decision makers

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.

Learn more about:

Gain real insights from XML

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.

Learn more about:

Quickly generate structured data from XML

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.

Learn more about:

How Flexter benefits your organisation

Reduce costs

Reduce the cost of transforming complex XML structures by up to 80%.

User testing with Flexter eliminated a 120 day development project, saving 80,000 Euros in development costs and 10,000 Euros in annual maintenance costs.

Rapid XML processing

Flexter is extremely fast when processing XML data.

Using advanced algorithms and in-memory processing, user tests loading complex XML files performed an astonishing 600 times faster on the same hardware when using Flexter.

Keep on track

Flexter removes the risk of your XML project failing.

Data in XML files becomes available instantly without custom development or training.
Service Level Agreements are no longer missed.
Analysts and ETL developers can move away from endless lines of code - focusing on delivering real insights and value to decision makers.

Scale infinitely

Flexter handles any volume of XML data.

Built to work with multiple servers, it scales linearly - an important consideration in the current era of big data and exponential data growth.

Flexter is an amazing tool. It cut down my data load from hours to minutes. It gets better.
I didn’t even have to write a single line of code. I just fed Flexter my files, made some tea, and when I got back my data was ready to use in my analytics application.

How it works

Automated ETL Development for XML

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.

Find out how Flexter compares with other ETL tools when processing XML

Find out Flexter integrates with other ETL tools for XML processing

Visual XML Schema and XSD Browser

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.

Flexter's visual XML schema browser and
how to integrate with Tableau

Targeted XML Processing

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.

Learn more about core Flexter workflows

Target Schema Optimisation

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.

Powered by


Pricing

Flexter scales linearly with the number of CPUs and servers that are available for processing.
This is reflected in our CPU based pricing model.
The larger your data volume or the faster you want your data to be processed the more CPUs are required.

Pricing is based on an annual subscription model.

Features

Features
Free Online
Trial
Enterprise
Version
Max daily data limit
50MB
Unlimited
Scalability
Single instance
Clustered
File output formats
TSV
TSV,PARQUET,AVRO,ORC
RDBMS support
 
 
Oracle, MS SQL Server, PostgreSQL
Location
Online
On Premise
Data Lineage
 
Scheduled execution
 
Support
 
Optimisations
Elevate, Re-use, Naming
Elevate, Re-use, Naming
Visualisations
 
Browse Schemas
In-memory processing
 
Yes
   

Flexter is typically installed on-site.
Use our free online version to understand what Flexter can do for you and your data.

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.