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
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 | |
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.