What is Flexter?

Flexter is an enterprise-level data warehouse automation tool for industry data standards (XML/JSON).

It automatically converts XML/JSON to text, any relational database, a data lake, or big data formats (Parquet, ORC, Avro).

It works with any industry data standard, including ACORD, FpML, FIXML, ISO 20022, HL7 etc.

Once the conversion process is complete, data analysts and anyone else who needs to query XML data can use SQL or standard reporting tools such as Tableau, Qlik, Looker etc. to generate insights and provide accurate data for decision-making.

Key benefits of Flexter

  • Rapidly frees up XML and JSON data from proprietary formats
  • Provides advanced, evidence-based analytics for decision-making
  • Reduces hours of manual work to minutes with automated, real-time conversion
  • Reduces costs and removes the need to hire expensive data specialists
  • Allows you to scale up for all data volumes
  • Reduces the risk of exceeding budgets and missing SLAs

Full tool capability data sheet

Explore the technical capabilities of our free XML conversion tool and Flexter to understand your options for converting XML data, including database and ETL integrations.
Data Free Flexter Enterprise Flexter
Data volume Up to 1MB Any
Overwrite
Append
Access Free Flexter Enterprise Flexter
API
Command Line
WebUI
Formats (input) Free Flexter Enterprise Flexter
XML
JSON
TSV, CSV, PSV etc.
RDBMS
Databases (output) Free Flexter Enterprise Flexter
Snowflake
Oracle
MySQL
PostgreSQL
Teradata
Redshift
MS SQL Server
Azure SQL Data Warehouse
Yellowbrick
BigQuery
Databricks
AWS Athena
Query engines (output) Free Flexter Enterprise Flexter
Hive
Impala
File formats (output) Free Flexter Enterprise Flexter
CSV, TSV, PSV etc.
Excel
ORC
Parquet
Avro
Automation Free Flexter Enterprise Flexter
Target schema
Mappings
Parent - child relationships
Conversion
Documentation
Optimisation algorithms Free Flexter Enterprise Flexter
Elevate
Reuse (XSD only)
Naming
Schema generation Free Flexter Enterprise Flexter
JSON sample
XML sample
XSD
XSD + XML sample
Database
Text
Sources Free Flexter Enterprise
FTP, SFTP
Object storage (S3, ADLS, Azure Blob etc.)
HTTP(S)
HDFS
Network drive
Local file system
Upload
Change intelligence and management Free Flexter Enterprise Flexter
Metadata Catalog
Schema version diff
Schema evolution
Data lineage
ER diagram
Platforms Free Flexter Enterprise Flexter
Virtual Machine / Server
Kubernetes
Databricks
Spark
Location Free Flexter Enterprise Flexter
Google Cloud (GCP)
AWS
Azure
On-premise
Support Free Flexter Enterprise Flexter
E-mail
Phone

Requirements

No custom development is required for Flexter to start converting your data.

It supports both individual XML/JSON files and batches of XML/JSON files in archives and compressed formats (zip, gzip etc.).

The software will pull XML/JSON files from any location: network drives, (S)FTP servers, HDFS, Object Storage (S3, Blob Storage, Google Cloud Storage), XML/JSON from columns in a databse (XMLTYPE, CLOB etc.)

Flexter supports any relational databases, e.g. Oracle, MS SQL Server, DB2, PostgreSQL, MySQL, Redshift, Snowflake, BigQuery etc.

It is also big data ready, works with any volume of data, and can be scaled up and out across multiple servers.

The hardware requirements depend on the data volumes and the complexity of your XML or JSON documents. We go through a sizing exercise with you during the Flexter POC.

Flexter ships as a Linux RPM installer. The installation and configuration process is simple.

FAQ

Can I try Flexter for myself?

Yes, you can try a free online version of Flexter. Contact us for a PoC of Flexter Enterprise or Flexter as a Service.

Can I run a Flexter PoC or pilot?

Yes, we can run a 1-2 week Flexter PoC or pilot. Contact us for the details of running a PoC.

How much does Flexter cost?

Flexter pricing is based on an annual subscription model. It depends on your data volumes, and your number of schemas. Schedule a call to find out more.

How can I integrate Flexter with my own environment? Can I call it programmatically?

Flexter is a command line tool. You can call it programmatically from other tools, e.g. ETL or workflow tools.

Can I run Flexter on-premise in my own data centre?

Yes, Flexter can be installed locally in your own data centre.

Can I run Flexter in the cloud?

Yes, Flexter can be installed in the cloud environment of your choice.

Is Flexter Data Lake ready?

Yes, Flexter supports object storage on AWS (S3), GCP (GCS), and Azure (Blob)

Can I use Flexter without XSD?

Yes, Flexter can derive a schema from a sample of XML or JSON files.

Technologies

Big data format
Data Lake Storage
Database