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.
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
- 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
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
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
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
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
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
Start exploring the features by downloading the ETL Framework (free for personal use) and 20-day trial of the ETL Server.