scriptella.driver.scriptella

Home
Java Source Code / Java Documentation
1.6.0 JDK Core
2.6.0 JDK Modules
3.6.0 JDK Modules com.sun
4.6.0 JDK Modules com.sun.java
5.6.0 JDK Modules sun
6.6.0 JDK Platform
7.Ajax
8.Apache Harmony Java SE
9.Aspect oriented
10.Authentication Authorization
11.Blogger System
12.Build
13.Byte Code
14.Cache
15.Chart
16.Chat
17.Code Analyzer
18.Collaboration
19.Content Management System
20.Database Client
21.Database DBMS
22.Database JDBC Connection Pool
23.Database ORM
24.Development
25.EJB Server
26.ERP CRM Financial
27.ESB
28.Forum
29.Game
30.GIS
31.Graphic 3D
32.Graphic Library
33.Groupware
34.HTML Parser
35.IDE
36.IDE Eclipse
37.IDE Netbeans
38.Installer
39.Internationalization Localization
40.Inversion of Control
41.Issue Tracking
42.J2EE
43.J2ME
44.JBoss
45.JMS
46.JMX
47.Library
48.Mail Clients
49.Music
50.Natural Language Processing
51.Net
52.Parser
53.PDF
54.Portal
55.Profiler
56.Project Management
57.Report
58.RSS RDF
59.Rule Engine
60.Science
61.Scripting
62.Search Engine
63.Security
64.Sevlet Container
65.Source Control
66.Swing Library
67.Template Engine
68.Test Coverage
69.Testing
70.UML
71.Web Crawler
72.Web Framework
73.Web Mail
74.Web Server
75.Web Services
76.Web Services apache cxf 2.2.6
77.Web Services AXIS2
78.Wiki Engine
79.Workflow Engines
80.XML
81.XML UI
Java Source Code / Java Documentation  » Scripting » scriptella » scriptella.driver.scriptella 
scriptella.driver.scriptella

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>
Java Source File NameTypeComment
Driver.javaClass This driver allows execution of external ETL files.
ScriptellaConnection.javaClass Represents a connection to externally located Scriptella ETL file.
ScriptellaDriverITest.javaClass Integration test for scriptella.driver.scriptella.Driver .
ScriptellaDriverPerfTest.javaClass Performance test for scriptella.driver.scriptella.Driver .
ScriptellaProviderException.javaClass Thrown to indicate Spring provider failure.
w___w___w_.___ja_v_a_2s.__c__o__m_ | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.