Package scriptella.driver.scriptella

Driver for running Scriptella ETL files.

See: Description

Package scriptella.driver.scriptella Description

Driver for running Scriptella ETL files.

The idea of this driver is similar to Ant's <ant> task, i.e. it is suitable for splitting ETL files into sub-projects.

When ETL file is executed from another Scriptella ETL file variables context is propagated to the callee.

General information

Driver class:scriptella.driver.scriptella.Driver
URL:URL of the ETL file to execute. URIs are resolved relative to a script file. Not required.
Runtime dependencies:None

Driver Specific Properties

Name Description Required

Script Syntax

Put ETL file names or absolute URLs directly in the body of <script> element. File paths are separated by End-Of-Line tokens.

Use standard ${name} or $name syntax for properties substitution.

<query> elements are not supported.

Examples

The following example creates a database by executing external ETL file named create_db.etl.xml and then executes an SQL script over it:
<etl>
    <connection id="createdb" driver="scriptella" url="createdb.etl.xml"/>
    <connection id="db" driver="oracle" url="jdbc:...."/>

    <script connection-id="db">
        INSERT INTO ...
    </script>
</etl>

The following example selects user_id, email from Users table and runs genreport.etl.xml and sendreport.etl.xml for each record found:

<etl>
    <connection id="db" driver="oracle" url="jdbc:...." />
    <connection id="scriptella" driver="scriptella" />

    <query connection-id="db">
        <!-- Selects User_ID and EMail, this variables are visible in nested scripts -->
        SELECT User_ID, Email FROM Users
        <script connection-id="scriptella">
            genreport.etl.xml <!-- Generates report for User_ID -->
            sendreport.etl.xml <!-- Sends produced report to Email -->
        </script>
    </query>
</etl>

Copyright © Copyright 2006-2012 The Scriptella Project Team.