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
|Data volume restrictions||Free||Unlimited||Unlimited|
|TSV, CSV, PSV etc.|
|MS SQL Server|
|Azure SQL Data Warehouse|
|Query engines (output)|
|File formats (output)|
|CSV, TSV, PSV etc.|
|XSD + XML sample|
|Azure BLOB Storage|
|Local file system|
|Access to Metadata|
|Merge of output files|
|File format conversion|
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.
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 the edition (Enterprise or FaaS), 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.