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
180
181
182
183
184
185
186
187
188
<!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>
        <div class="header-controls">
        <div class="language-menu" data-language-menu>
          <button class="language-toggle" type="button" data-language-toggle aria-expanded="false" aria-label="Language" title="Choose language">
            <svg aria-hidden="true" viewBox="0 0 24 24" focusable="false"><circle cx="12" cy="12" r="9"></circle><path d="M3 12h18M12 3a14 14 0 0 1 0 18M12 3a14 14 0 0 0 0 18"></path></svg>
            <span class="visually-hidden">Choose language</span>
          </button>
          <div class="language-menu__dropdown" data-language-dropdown hidden>
            <a href="https://github.com/scriptella/scriptella-etl/blob/master/README.zh-CN.md"><span>简体中文</span><small>README</small></a>
            <a href="https://github.com/scriptella/scriptella-etl/blob/master/README.ko.md"><span>한국어</span><small>README</small></a>
            <a href="https://github.com/scriptella/scriptella-etl/blob/master/README.de.md"><span>Deutsch</span><small>Geschichte</small></a>
          </div>
        </div>
        <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>
      </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">Scriptella 1.5</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.5</h2>
        </div>
        <div id="Scriptella+1.5">
          <p>Scriptella 1.5 is now available. It keeps the Java 17 baseline and adds current PostgreSQL, MariaDB, and MySQL JDBC guidance, safer driver-loading diagnostics, and maintained Spring and Velocity integrations.</p>
          <p><a href="changes.html#version_1.5">What is new in 1.5</a> · <a href="download.html#version-1-5">Download 1.5</a></p>
          <p id="Scriptella+1.4+%28August+14%2C+2026%29">Previous release: Scriptella 1.4 (August 14, 2026). <a href="download.html#version-1-4">Download 1.4</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>