ETL Framework

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

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

Knowledge base

Embedding in Java

REST API

ETL Scenario Examples

Javadoc

Download Free

Connect to everything

ETL Framework offers a great selection of connectivity options, supports the majority of the SQL and NoSQL databases, data exchange formats and well-known APIs.

Databases

  • Oracle
  • MS SQL Server
  • MySQL
  • PostgreSQL
  • DB2
  • Informix
  • Sybase
  • Snowflake
  • Amazon Redshift
  • MongoDB
  • Redis
  • 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
  • HTTP and NTLM Proxy
  • File
  • FTP
  • SFTP
  • FTPS
  • WebDAW
  • Amazon S3
  • Google Cloud Storage
  • Microsoft Azure Storage
  • HL7 MLLP
  • SMTP, POP3, IMAP

Web Services

  • Any REST using HTTP connector
  • Any SOAP using HTTP connector
  • Google Analytics
  • Google Sheets
  • Amazon MWS
  • Facebook
  • Twitter

Integration

  • Standalone application
  • Embedded
  • REST API
  • Integration Agent

Feature Rich

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

Expandable using Java

Data Synchronization

Data Mapping

Scripting using SQL and JavaScript

Data Streaming

Data Partitioning

100+ built-in Transformations

Semi-structured/unstructured data

Database specific features

Integrations

ETL Framework can be integrated with any existing application.

Integration options:

  • Embed ETL Framework in Java application
  • Use ETL Framework as a headless executable
  • Deploy ETL Server and connect to the REST API
  • Integration Agent with the scheduler
Embedding in Java

ETL Server

REST API for the ETL Framework.

Benefits:

  • Connect to the open REST API from anywhere, using any programming language
  • Scalability. ETL Server is horizontally scalable
  • Security. All API endpoints are protected by JWT-based authentication
  • Ability to discover metadata and execute SQL queries on any data source
Installing ETL Server

ETL Framework editions and pricing

Personal Edition

Free

  • Oracle, MySQL, MS SQL Server, DB2, Informix, PostgreSQL, Sybase, Snowflake, any DB using JDBC
  • Redis, MongoDB
  • CSV, Text, JSON, XML, Excel, PDF, HTML, HL7 2.x, HL7 FHIR
  • Web services
  • Google Analytics, Google Sheets, Amazon MWS, Facebook, Twitter, Google BigQuery
  • HTTP, FTP, SFTP, MLLP, Amazon S3, Google Cloud Storage, Azure Storage, WebDAV, SMTP, POP3, IMAP
  • 100+ transformations
  • Expandable using Java
  • Scripting using JavaScript and SQL
  • Source Code
  • Can be used in commercial projects
  • REST API
  • Royalty Free Redistribution
Download Free

Site License or ETL Server

$2,000.00 USD

  • Oracle, MySQL, MS SQL Server, DB2, Informix, PostgreSQL, Sybase, Snowflake, any DB using JDBC
  • Redis, MongoDB
  • CSV, Text, JSON, XML, Excel, PDF, HTML, HL7 2.x, HL7 FHIR
  • Web services
  • Google Analytics, Google Sheets, Amazon MWS, Facebook, Twitter, Google BigQuery
  • HTTP, FTP, SFTP, MLLP, Amazon S3, Google Cloud Storage, Azure Storage, WebDAV, SMTP, POP3, IMAP
  • 100+ transformations
  • Expandable using Java
  • Scripting using JavaScript and SQL
  • Source Code
  • Can be used in commercial projects
  • REST API
  • Royalty Free Redistribution
Buy Now

Redistribution (Royalty Free)

starts from $10,000.00 USD

  • Oracle, MySQL, MS SQL Server, DB2, Informix, PostgreSQL, Sybase, Snowflake, any DB using JDBC
  • Redis, MongoDB
  • CSV, Text, JSON, XML, Excel, PDF, HTML, HL7 2.x, HL7 FHIR
  • Web services
  • Google Analytics, Google Sheets, Amazon MWS, Facebook, Twitter, Google BigQuery
  • HTTP, FTP, SFTP, MLLP, Amazon S3, Google Cloud Storage, Azure Storage, WebDAV, SMTP, POP3, IMAP
  • 100+ transformations
  • Expandable using Java
  • Scripting using JavaScript and SQL
  • Source Code
  • Can be used in commercial projects
  • REST API
  • Royalty Free Redistribution
Request a Quote

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

Download Free