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

Key features

Enterprise
Data
Data volume restrictions Unlimited
Overwrite
Append
Formats (input)
XML
JSON
TSV, CSV, PSV etc.
RDBMS
Databases (output)
Teradata
Oracle
MySQL
PostgreSQL
Snowflake
Redshift
MS SQL Server
Azure SQL Data Warehouse
Yellowbrick
BigQuery
Databricks
AWS Athena
Query engines (output)
Hive
Impala
File formats (output)
CSV, TSV, PSV etc.
ORC
Parquet
Avro
Optimisations
Elevate
Reuse
Naming
Schema generation
JSON sample
XML sample
XSD
XSD + XML sample
RDBMS
Text
Sources
FTP, SFTP
Object storage (S3, ADLS, Azure Blob etc.)
HTTP(S)
HDFS
MapR-FS
Network drive
Local file system
Upload
Access to Metadata
Metadata repository
Data lineage
ER diagram
Platforms
Hadoop
Kubernetes
Spark
Stand-alone server
Merge
Merge of output files
File format conversion
Location
Google Cloud (GCP)
AWS
Azure
On-premise
Support
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