Features

Personal

ETL Server

Royalty free redistribution

Databases:

  • Oracle
  • DB2
  • MySql
  • PostgreSql
  • Microsoft SQL Server
  • Sybase SQL Server
  • Informix
  • Snowflake
  • Any JDBC

Data Exchange 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

Web services and APIs:

  • REST with basic and token-based authentication
  • SOAP
  • Google Analytics

Connectivity:

  • HTTP
  • Support for HTTP proxy
  • JDBC and ODBC
  • File
  • FTP
  • SFTP
  • SMTP
  • POP3
  • Amazon S3
  • Google Cloud Storage
  • Redis
  • HL7 MLLP

Can be embedded

Standalone

REST API

ETL Engine:

  • Automatic data type translation
  • Support for change replication (databases and APIs)
  • Data streaming
  • Parallel extract and load
  • Real time data movements and data transformations
  • Batch processing
  • Support for bind variables
  • Creating schema objects on the fly using source as a pattern. For example, table can be automatically created if it doesn’t exist
  • Data quality features and validation using SQL, JavaScript, other scripting languages and regex
  • Support for pluggable scripting languages such as JavaScript and Ruby
  • Using of databases specific features: stored procedures and functions, language constructs, cursors, temporary tables, exception handling, external tools 
  • CLOB and BLOB support
  • Manual and automatic transaction management (commit intervals)
  • Support for automatic primary/foreign key generation with mapping to existing primary/foreign key
  • Conditional sources and destinations
  • Conditional (IF-THEN-ELSE) execution
  • Automatic and manual exception handling
  • Support for multiple source and destination connections (for example MySql, Oracle and PostgreSql) in one scenario
  • Automatic and conditional Insert/Update/Delete/Merge
  • In-line SQL in scenarios
  • Ability to execute XQuery on XML based datasets
  • Pre/post/inline/on error/on success tasks

Dataset transformations:

  • Filter
  • Sort
  • Join
  • Minus
  • Intersect
  • Union
  • De-normalization
  • De-duplication
  • Partitioning by key columns or maximum number of rows
  • Matrix transformation
  • Key-Value de-normalization
  • Key-Value normalization
  • Split Dataset
  • Populate dataset from any fragment of text using given connector, such as JSON, XML, etc
  • Create staging tables and files from the nested dataset

Column transformations:

  • Calculate value
  • Add column
  • Exclude column
  • Change data type
  • Regex replacement

Dimension transformations:

  • Add dimension
  • Extract dimension

Tasks:

  • XLT transformation
  • OS command execution
  • File based operations such as copy, move, concatenate multiple files, delete, rename, zip, unzip, gzip
  • Send email
  • Execute SQL
  • Merge Files
  • Execute JavaScript anywhere in the ETL scenario

Oracle-specific transformations:

  • Using sequences to generate primary keys
  • Full PLSQL support including anonymous SQL blocks, inner functions, procedures, named variables, etc.
  • Cursors as data sources
  • Extract using SQL*plus and load using SQL*loader (requires Oracle client)
  • Table copy using SQL*plus COPY command (requires Oracle client)
  • Support for MERGE, exception handling, date+time conversion, temporary tables

DB2-specific transformations:

  • Using sequences and auto-increment fields to generate primary keys
  • Full SQL PL support including functions, procedures, named variables, etc.
  • Cursors as data sources
  • Extract and load using SYSPROC.ADMIN_CMD
  • Support for MERGE, exception handling, date+time conversion, temporary tables

MS SQL Server-specific transformations:

  • Using auto-increment fields to generate primary keys
  • Full Transact SQL support including functions, procedures, named variables, etc.
  • Cursors as data sources
  • Extract and load using BCP (requires MS SQL server client)
  • Support for MERGE, exception handling, date+time conversion, temporary tables

MySQL-specific transformations:

  • Using auto-increment fields to generate primary keys
  • Full MySql stored procedure language support including functions, procedures, named variables, etc.
  • Cursors as data sources
  • Extract using select INTO OUTFILE and Load using LOAD DATA
  • Support for exception handling, date+time conversion, temporary tables

PostreSQL-specific transformations:

  • Using sequences and serial fields to generate primary keys
  • Full PL/pgSQL support including functions, named variables, etc.
  • Cursors as data sources
  • Extract and Load using COPY
  • Support for MERGE, exception handling, date+time conversion, temporary tables

Informix-specific transformations:

  • Using sequences and serial fields to generate primary keys
  • Full SPL support including functions, procedures, named variables, etc
  • Cursors as data sources
  • Extract and load using DBACCESS (requires Informix client)
  • Support for MERGE, exception handling, date+time conversion, temporary tables

Sybase ASE-specific transformations:

  • Using auto-increment fields to generate primary keys
  • Full T-SQL support including functions, procedures, named variables, etc.
  • Cursors as data sources
  • Extract and load using BCP (requires Sybase Adaptive Server client)
  • Support for exception handling, date+time conversion, temporary tables

Snowflake-specific transformations:

  • Support for COPY INTO command

Ability to run in the cloud

Royalty free redistribution

Source code

Full source code, including license generation tool

Price

$0 (free)

$2000

Request a Quote

Not sure which one to choose?
Tell us about your needs and we will help you with the right solution.