Business Intelligence
Now Reading
Scriptella ETL
2
Review

Scriptella ETL

Overview
Synopsis

Scriptella is an open source ETL (Extract-Transform-Load) and script execution tool written in Java. The primary focus is simplicity and don't have to study yet another complex XML-based language - use SQL (or other scripting language suitable for the data source) to perform required transformations.

Category

ETL Software Free

Features

Simple
Free
Easy to run
Easy to use

License

Proprietary Software

Price

Contact for Pricing

Pricing

Subscription

Free Trial

Available

Users Size

Small (<50 employees), Medium (50 to 1000 employees), Enterprise (>1001 employees)

Company

Scriptella ETL

PAT Rating™
Editor Rating
Aggregated User Rating
Rate Here
Ease of use
8.9
7.9
Features & Functionality
8.7
9.2
Advanced Features
8.8
7.6
Integration
8.7
9.5
Performance
8.9
9.1
Customer Support
8.8
9.0
Implementation
9.0
Renew & Recommend
8.9
Bottom Line

The solution features simple XML syntax for scripts and all users need is to add dynamics to their existing SQL scripts by creating a thin wrapper XML file.Moreover, it allows users to work with multiple data sources in a single ETL file while offering support for many useful JDBC features like batching, prepared statements and parameters in SQL including references to files (BLOBs) and JDBC escaping.

8.8
Editor Rating
8.8
Aggregated User Rating
6 ratings
You have rated this

Scriptella is an open source ETL (Extract-Transform-Load) and script execution tool written in Java. Its primary focus is simplicity hence users don't have to study yet another complex XML-based language - use SQL (or other scripting language suitable for the data source) to perform required transformations.

Its main areas of application are executing scripts written in SQL, JavaScript, JEXL, and Velocity, database migration and Interoperability with LDAP, JDBC, XML and other datasources and cross-database ETL operations, import/export from/to CSV, text and XML and other formats.

The solution features simple XML syntax for scripts and all users need is to add dynamics to their existing SQL scripts by creating a thin wrapper XML file.Moreover, it allows users to work with multiple data sources in a single ETL file while offering support for many useful JDBC features like batching, prepared statements and parameters in SQL including references to files (BLOBs) and JDBC escaping.

It also offers support for evaluated expressions and properties (based on JEXL syntax).Additionally, the platform can be used as a standalone tool or Ant task and it does not require any deployment or installation.It comes with built-in adapters for popular databases for a tight integration and support for any database with JDBC/ODBC compliant driver.

The solution features a Service Provider Interface (SPI) designed for interoperability with non-JDBC DataSources and scripting languages and an out-of-the box support for JSR 223 (Scripting for the Java™ Platform) compatible languages. It also comes with built-In CSV, Excel, Text, XML, LDAP, Lucene, Velocity, JEXL and Janino providers, and it supports integration with Java EE, Spring Framework, JMX , JNDI and JavaMail for enterprise ready scripts.

You may like to read: Top Extract, Transform, and Load, ETL Software, How to Select the Best ETL Software for Your Business and Top Guidelines for a Successful Business Intelligence Strategy

Filter reviews
User Ratings





User Company size



User role





User industry





2 Reviews
  • Brooke
    December 23, 2017 at 3:25 pm

    Add dynamics to existing SQL scripts by creating a thin wrapper XML file.

    Company size

    Medium (50 to 1000)

    User Role

    Executive

    User Industry

    Construction

    Rating
    Ease of use8.7

    Scriptella offers support for many useful JDBC features like batching, prepared statements and parameters in SQL including references to files (BLOBs) and JDBC escaping.

    Features & Functionality8.4

    Advanced Features8

    Integration8.9

    Training 8.9

    Customer Support8.9

    Renew & Recommend8

    ADDITIONAL INFORMATION
    It allows for data transformations without XML and provides the ability to execute scripts in a series of different languages including SQL, JavaScript, Velocity and JEXL. Scriptella ETL offers support for evaluated expressions and properties, based on the JEXL syntax.

  • Andrey Yavin
    September 13, 2019 at 4:58 pm

    Very fast and easy to use ETL tool

    What is best?

    Simplicity and performance

    Company size

    Enterprise (>1001)

    User Role

    Consultant

    User Industry

    Computer

    ADDITIONAL INFORMATION
    One-line integration in java – EtlExecutor.newExecutor(new File(“etl.xml”)).execute();

    Highly optimized for performance and memory usage

Ease of use
Features & Functionality
Advanced Features
Integration
Performance
Customer Support
Implementation
Renew & Recommend

What's your reaction?
Love It
100%
Very Good
0%
INTERESTED
0%
COOL
0%
NOT BAD
0%
WHAT !
0%
HATE IT
0%