Why choose Flexter?

Unlock your XML/JSON data for decision makers
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.
Learn more about:
- Converting FpML XML to Google BigQuery
- [Video] Converting ISO 20022 XML to Trifacta
- Converting NDC standard to an Oracle database
- Convert XML to Parquet and Spark
- Converting MISMO XML files to Hive
- JSON. To ETL or to NoETL? The big data question
- Convert ACORD Insurance XML to Talend Data Preparation
Gain real insights from XML/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.
Learn more about:


Quickly generate structured data from XML/JSON
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.
How Flexter benefits your organisation
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.

Alexey Shchedrin
ENTERPRISE ARCHITECT
How it works
Automated ETL Development for XML/JSON
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.


Visual XML/JSON 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.
Targeted XML/JSON Processing
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:
- A tabular output schema from XSD (normalised
relational format) and/or the source XML/JSON files. - The column mappings from the XML/JSON data source
to the target table. - The table relationships of the target schema and
their primary and foreign keys.


Target Schema Optimisation
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.
Pricing
Flexter scales linearly with the number of CPUs and servers that are available for processing.
This is reflected in our server based pricing model.
The larger your data volume or the faster you want your data to be processed the more servers are required.
Pricing is based on an annual subscription model.
Features
Free | FaaS (API) | Enterprise | |
---|---|---|---|
Data | |||
Data volume restrictions | 1 MB (zipped) | Unlimited (1 GB raw per API call) |
Unlimited |
Overwrite | x | x | x |
Append | x | ||
Formats (input) | |||
XML | x | x | x |
JSON | x | x | x |
TSV, CSV, PSV etc. | x | ||
RDBMS | x | ||
Databases (output) | |||
Teradata | x | ||
Oracle | x | x | |
MySQL | x | x | |
PostgreSQL | x | x | |
Snowflake | x | x | |
Redshift | x | x | |
MS SQL Server | x | x | |
Azure SQL Data Warehouse | x | ||
Query engines (output) | |||
Hive | x | ||
Impala | x | ||
File formats (output) | |||
CSV, TSV, PSV etc. | x | x | x |
ORC | x | ||
Parquet | x | ||
Avro | x | ||
API | |||
API | x | ||
Webhooks | x | ||
Optimisations | |||
Elevate | x | x | x |
Reuse | x | x | x |
Naming | x | x | x |
Schema generation | |||
JSON sample | x | x | x |
XML sample | x | x | x |
XSD | x | x | |
XSD + XML sample | x | x | x |
RDBMS | x | ||
Text | x | ||
Sources | |||
FTP, SFTP | x | ||
S3 | x | x | |
Azure BLOB Storage | x | ||
HTTP(S) | x | ||
HDFS | x | ||
MapR-FS | x | ||
Network drive | x | ||
Local file system | x | ||
Upload | x | x | x |
Access to Metadata | |||
Metadata repository | x | ||
Data lineage | x | x | x |
ER diagram | x | x | x |
Platforms | |||
Hadoop | x | ||
Openshift | x | ||
Nomad | x | ||
Spark | x | ||
Stand-alone server | x | ||
Merge | |||
Merge of output files (small files problem) | x | ||
File format conversion | x | ||
Location | |||
Cloud | x | x | x |
On-premise | x | ||
Support | |||
x | x | x | |
Phone | x | ||
Price | Free | Contact Us | Contact Us |
Flexter can be installed on-site in your own data centre or one of the popular cloud providers (Amazon, Microsoft, Google, Oracle etc.
Use our free online version to understand what Flexter can do for you and your data.
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.