Class | Description |
---|---|
Driver |
This driver allows execution of external ETL files.
|
ScriptellaConnection |
Represents a connection to externally located Scriptella ETL file.
|
Exception | Description |
---|---|
ScriptellaProviderException |
Thrown to indicate Spring provider failure.
|
When ETL file is executed from another Scriptella ETL file variables context is propagated to the callee.
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 |
Name | Description | Required |
---|
<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.
<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-2019 The Scriptella Project Team.