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
178
179
<!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>
        </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">
          <p class="eyebrow">Open source ETL for Java</p>
          <h1 id="hero-title">Move data with the languages you already use</h1>
          <p class="hero__lede">Scriptella runs SQL and other scripts against multiple data sources from one small, readable ETL file. There is no visual designer, application server, or proprietary runtime to learn.</p>
          <div class="button-group">
            <a class="button" href="tutorial.html">Start the two-minute tutorial</a>
            <a class="button button--secondary" href="download.html">Download Scriptella</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">ETL without the machinery</h2>
        <p class="lede">Scriptella is a lightweight, open source ETL (extract-transform-load) and script execution tool written in Java. Its focus is simplicity: use SQL or the scripting language suited to your data source, with XML providing only the orchestration.</p>

        <div class="feature-grid">
          <article class="feature-card">
            <h3>Connect anything</h3>
            <p>Work with several data sources in one file. Built-in providers cover JDBC, CSV, text, XML, LDAP, shell, JEXL, Velocity, Janino, and more.</p>
          </article>
          <article class="feature-card">
            <h3>Keep scripts readable</h3>
            <p>Run existing SQL directly, include external files, bind query results as variables, and add expressions only where a transformation needs them.</p>
          </article>
          <article class="feature-card">
            <h3>Run it your way</h3>
            <p>Use the command line, Ant, Maven, or the Java API. Transactions, batching, conditional execution, and structured error handling are built in.</p>
          </article>
        </div>
      </section>

      <section id="usage" class="split-section" aria-labelledby="usage-title">
        <div>
          <p class="eyebrow">Typical uses</p>
          <h2 id="usage-title">A small tool for practical data work</h2>
        </div>
        <ul class="check-list">
          <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">
        <p class="eyebrow">Getting started</p>
        <h2 id="getting-started-title">From download to first run</h2>
        <div class="route-grid">
          <a class="route-card" href="download.html">
            <span>01</span>
            <strong>Get Scriptella</strong>
            <small>Download the binary distribution.</small>
          </a>
          <a class="route-card" href="tutorial.html">
            <span>02</span>
            <strong>Run an ETL file</strong>
            <small>Follow the short hands-on tutorial.</small>
          </a>
          <a class="route-card" href="reference/index.html">
            <span>03</span>
            <strong>Go deeper</strong>
            <small>Explore syntax, integrations, and best practices.</small>
          </a>
        </div>
      </section>

      <section id="News" class="release-note" aria-labelledby="news-title">
        <div>
          <p class="eyebrow">Current baseline</p>
          <h2 id="news-title">Scriptella 1.3</h2>
        </div>
        <div id="Scriptella+1.3+RC1+%28July+16%2C+2026%29">
          <p>Released July 17, 2026, Scriptella 1.3 modernizes the build, website, documentation, and release process while preserving Scriptella's established behavior and Java 8 compatibility.</p>
          <p>Download the binary, source, and examples distributions from <a href="download.html#version-1-3">the download page</a>, or use the <code>org.scriptella</code> modules from Maven Central.</p>
          <p><a href="changes.html#version_1.3">Read the change history</a> · <a href="download.html#version-1-3">Download 1.3</a> · <a href="support.html">Support</a></p>
        </div>
        <div id="Scriptella+1.2+Released+%28October+3%2C+2019%29">
          <p class="eyebrow" style="margin-top:2rem">Previous release</p>
          <p>Scriptella 1.2, released October 3, 2019. <a href="download.html#version-1-2">Download 1.2</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>