Compact, modular, high performance and embeddable ETL engine written in Java

ETL Framework allows you to create data integration and ETL scenarios using XML-based language or Java. You can easily embed framework in your application or deploy it as a Web application and connect to the open REST API. There is a wide selection of built-in transformations and you can also develop your own using JavaScript and SQL. ETL Framework is free for personal use.


Connect to everything

ETL Framework offers a great selection of connectivity options and supports most of the widely used databases, data exchange formats and well-known APIs.

Databases

  • Oracle
  • MS SQL Server
  • MySQL
  • PostgreSQL
  • DB2
  • Informix
  • Sybase
  • Snowflake
  • Any JDBC

Formats

  • Delimited text file
  • Fixed length text file
  • XML
  • XML with XLT transformation
  • XML with XQuery
  • JSON
  • Excel XLS
  • Excel XLSX
  • HTML
  • PDF
  • HL7 2.x
  • HL7 FHIR

Connectivity

  • HTTP(S)
  • HTTP and NTLM Proxy
  • File
  • FTP
  • SFTP
  • Amazon S3
  • Google Cloud Storage
  • Redis
  • HL7 MLLP
  • SMTP
  • POP3
  • IMAP

Web Services

  • Any REST using HTTP connector
  • Any SOAP using HTTP connector
  • Google Analytics

Integration

  • Standalone application
  • Embedded
  • REST API

Feature Rich

ETL Framework makes your life as a developer easier. Build complex data integration and ETL scenarios with minimum effort and maximum result.

Data Quality

Data Validation

Data Mapping

Scripting using SQL and JavaScript

Data Streaming

Data Partitioning

100+ built-in Transformations

Multidimensional Objects

Database specific features

Read more about ETL Framework features.

ETL Server

REST API for the ETL Framework.

Benefits of the ETL Server:

  • Connect to the open REST API from anywhere, using any programming language
  • Performance - ETL Server can be deployed to the multiple nodes in the cluster and supports millions of concurrent requests
  • Retrieve metadata from databases, APIs and file-based data sources
  • Security – all API endpoints are protected by JWT based security/li>

Integration

ETL Framework can be embedded in or integrated with any existing application.

Integration Options:

  • Integrate by including a few compact jar files in your project
  • Use ETL framework as headless executable
  • Deploy ETL Server and connect using REST API

ETL Framework and Server editions and pricing

Compact, modular, high performance and embeddable ETL engine written in Java.

Personal Edition 

Free

  • Oracle, MySQL, MS SQL Server, DB2, Informix, PostgreSQL, Sybase, Snowflake, any DB using JDBC
  • Binary and Text file Formats
  • HL7 2.x and HL7 FHIR
  • REST and SOAP Web Services, Google Analytics
  • HTTP(S), FTP, SFTP, Amazon S3, Google Cloud Storage, SMTP, POP3, IMAP, Redis
  • 100+ transformations
  • JavaScript and SQL
  • Source Code
  • REST API
  • Site license
  • Full Source Code including license generator and Royalty Free Redistribution

ETL Server  

$2000.00

  • Oracle, MySQL, MS SQL Server, DB2, Informix, PostgreSQL, Sybase, Snowflake, any DB using JDBC
  • Binary and Text file Formats
  • HL7 2.x and HL7 FHIR
  • REST and SOAP Web Services, Google Analytics
  • HTTP(S), FTP, SFTP, Amazon S3, Google Cloud Storage, SMTP, POP3, IMAP, Redis
  • 100+ transformations
  • JavaScript and SQL
  • Source Code
  • REST API
  • Site license
  • Full Source Code including license generator and Royalty Free Redistribution

RedistributionRoyalty Free

Contact Us

  • Oracle, MySQL, MS SQL Server, DB2, Informix, PostgreSQL, Sybase, Snowflake, any DB using JDBC
  • Binary and Text file Formats
  • HL7 2.x and HL7 FHIR
  • REST and SOAP Web Services, Google Analytics
  • HTTP(S), FTP, SFTP, Amazon S3, Google Cloud Storage, SMTP, POP3, IMAP, Redis
  • 100+ transformations
  • JavaScript and SQL
  • Source Code
  • REST API
  • Site license
  • Full Source Code including license generator and Royalty Free Redistribution

Start exploring the features by downloading the ETL Framework (free for personal use) and 20-day trial of the ETL Server.