scriptella.github.io/index.html at master · scriptella/scriptella.github.io · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
<!doctype html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <title>Scriptella — Simple ETL and script execution</title>
  <meta name="description" content="Scriptella is an open source Java ETL and script execution tool built around SQL and simple XML configuration.">
  <link rel="canonical" href="https://scriptella.org/">
  <meta property="og:title" content="Scriptella — Simple ETL and script execution">
  <meta property="og:description" content="Scriptella is an open source Java ETL and script execution tool built around SQL and simple XML configuration.">
  <meta property="og:type" content="website">
  <meta property="og:url" content="https://scriptella.org/">
  <meta property="og:image" content="https://scriptella.org/images/scriptella-logo.svg">
  <meta name="twitter:card" content="summary_large_image">
  <meta name="twitter:title" content="Scriptella — Simple ETL and script execution">
  <meta name="twitter:description" content="Scriptella is an open source Java ETL and script execution tool built around SQL and simple XML configuration.">
  <link rel="icon" href="favicon.ico" sizes="32x32">
  <link rel="icon" type="image/png" href="favicon-192.png" sizes="192x192">
  <script src="theme.js"></script>
  <link rel="stylesheet" href="style.css">
</head>
<body>
  <a class="skip-link" href="#main-content">Skip to content</a>
  <header class="site-header">
    <nav class="primary-nav" aria-label="Primary navigation">
      <div class="site-header__inner">
        <a class="site-logo" href="index.html" aria-label="Scriptella home">
          <img class="site-logo__dark" src="images/scriptella-logo.svg" width="190" height="38" alt="Scriptella">
          <img class="site-logo__light" src="images/scriptella-logo-light.svg" width="190" height="38" alt="Scriptella">
        </a>
        <ul>
          <li><a href="reference/index.html">Documentation</a></li>
          <li><a href="tutorial.html">Tutorial</a></li>
          <li><a href="reference/drivers.html">Drivers</a></li>
          <li><a href="https://github.com/scriptella/scriptella-etl">GitHub</a></li>
          <li><a href="download.html">Download</a></li>
          <li><a href="support.html">Support</a></li>
        </ul>
        <button class="theme-toggle" type="button" data-theme-toggle data-theme-current="system" aria-label="Color theme: System. Switch to Light." title="System theme — switch to Light">
          <span class="visually-hidden">Change color theme</span>
        </button>
      </div>
    </nav>
  </header>

  <main id="main-content">
    <section class="hero" aria-labelledby="hero-title">
      <div class="hero__inner">
        <div class="hero__copy">
          <h1 id="hero-title">Lightweight ETL for Java</h1>
          <p class="hero__lede">Scriptella runs SQL and other scripts against multiple data sources from one XML file. Open source. No visual designer, application server, or proprietary runtime.</p>
          <div class="button-group">
            <a class="button" href="tutorial.html">Two-minute tutorial</a>
            <a class="button button--secondary" href="download.html">Download 1.4</a>
            <a class="button button--github" href="https://github.com/scriptella/scriptella-etl">★ Star on GitHub</a>
          </div>
        </div>

        <div class="hero__example" aria-label="Example Scriptella ETL file">
          <p class="code-label">copy-customers.etl.xml</p>
          <pre><code class="language-xml">&lt;!DOCTYPE etl SYSTEM
  "http://scriptella.org/dtd/etl.dtd"&gt;
&lt;etl&gt;
  &lt;connection id="source" url="jdbc:h2:./source"/&gt;
  &lt;connection id="target" url="jdbc:h2:./target"/&gt;

  &lt;query connection-id="source"&gt;
    SELECT id, name FROM customer
    &lt;script connection-id="target"&gt;
      INSERT INTO customer VALUES (?id, ?name)
    &lt;/script&gt;
  &lt;/query&gt;
&lt;/etl&gt;</code></pre>
        </div>
      </div>
    </section>

    <div class="page-shell home-content">
      <section id="overview" aria-labelledby="overview-title">
        <h2 id="overview-title">SQL for the work. XML for the wiring.</h2>
        <p class="lede">Scriptella is an open source ETL and script execution tool written in Java. Use SQL or the language that fits the data source. XML only orchestrates.</p>

        <div class="feature-grid">
          <article class="feature-card">
            <h3>Multiple sources, one file</h3>
            <p>Work with JDBC, CSV, text, XML, LDAP, shell scripts, and other sources in the same ETL file.</p>
          </article>
          <article class="feature-card">
            <h3>Use your existing SQL</h3>
            <p>Run it directly, include files, bind query results as variables, and add expressions only where a transform needs them.</p>
          </article>
          <article class="feature-card">
            <h3>CLI, Ant, Maven, API</h3>
            <p>Transactions, batching, conditionals, and structured error handling are built in.</p>
          </article>
        </div>
      </section>

      <section id="usage" class="split-section" aria-labelledby="usage-title">
        <div>
          <h2 id="usage-title">Typical uses</h2>
        </div>
        <ul>
          <li>Cross-database migration and table copying</li>
          <li>CSV, text, and XML import or export</li>
          <li>Repeatable database schema initialization and upgrades</li>
          <li>Parameterized execution of SQL and other scripts</li>
          <li>A focused alternative to the Ant <code>&lt;sql&gt;</code> task</li>
        </ul>
      </section>

      <section id="features" class="getting-started" aria-labelledby="getting-started-title">
        <h2 id="getting-started-title">Getting started</h2>
        <div class="route-grid">
          <a class="route-card" href="download.html">
            <strong>Download</strong>
            <small>Binary, source, examples, or Maven.</small>
          </a>
          <a class="route-card" href="tutorial.html">
            <strong>Tutorial</strong>
            <small>Install, run, copy a table.</small>
          </a>
          <a class="route-card" href="reference/index.html">
            <strong>Reference</strong>
            <small>Syntax, drivers, and examples.</small>
          </a>
        </div>
        <aside class="github-prompt" aria-label="Support Scriptella">
          <strong>Scriptella useful?</strong>
          <p>Star it on GitHub to help others discover it.</p>
          <a class="button button--github" href="https://github.com/scriptella/scriptella-etl">★ Star Scriptella on GitHub</a>
        </aside>
      </section>

      <section id="News" class="release-note" aria-labelledby="news-title">
        <div>
          <h2 id="news-title">Scriptella 1.4</h2>
        </div>
        <div id="Scriptella+1.4+%28August+14%2C+2026%29">
          <p>Released August 14, 2026. Java 17 required. Obsolete HSQLDB and ODBC adapters removed.</p>
          <p>Get the binary, source, and examples from <a href="download.html#version-1-4">the download page</a>, or use the <code>org.scriptella</code> modules on Maven Central. Java 8 users should stay on <a href="download.html#version-1-3">Scriptella 1.3</a>.</p>
          <p><a href="changes.html#version_1.4">Change history</a> · <a href="download.html#version-1-4">Download 1.4</a></p>
          <span id="Scriptella+1.3+RC1+%28July+16%2C+2026%29" class="anchor-target" aria-hidden="true"></span>
          <p id="Scriptella+1.3+%28July+17%2C+2026%29">Previous: Scriptella 1.3 (July 17, 2026) is the Java 8 line. <a href="download.html#version-1-3">Download 1.3</a>.</p>
        </div>
      </section>
    </div>
  </main>

  <footer class="site-footer">
    <div class="site-footer__inner">
      <p><strong>Scriptella</strong> · Licensed under the Apache License, Version 2.0.</p>
      <p class="site-footer__credit">Built by <a class="pvrlabs-wordmark" href="https://pvrlabs.xyz" aria-label="PVR Labs"><span class="pvrlabs-wordmark__accent">PVR</span><span class="pvrlabs-wordmark__light">Labs</span></a></p>
      <nav aria-label="Footer navigation">
        <ul>
          <li><a href="reference/index.html">Documentation</a></li>
          <li><a href="faq.html">FAQ</a></li>
          <li><a href="docs/api/index.html">API Docs</a></li>
          <li><a href="docs/dtd/index.html">DTD Reference</a></li>
          <li><a href="https://github.com/scriptella/scriptella-etl">GitHub</a></li>
          <li><a href="changes.html">Change History</a></li>
          <li><a href="license.html">License</a></li>
          <li><a href="support.html">Support</a></li>
        </ul>
      </nav>
    </div>
  </footer>
  <!-- StatCounter: existing Scriptella project configuration -->
  <script>
    var sc_project = 10775960;
    var sc_invisible = 1;
    var sc_security = "53eaed1c";
  </script>
  <script defer src="https://secure.statcounter.com/counter/counter.js"></script>
  <!-- End StatCounter -->
</body>
</html>