Return to Snippet

Revision: 2460
at February 23, 2007 13:51 by ejboy


Initial Code
<!DOCTYPE etl SYSTEM "http://scriptella.javaforge.com/dtd/etl.dtd">
<etl>
  <connection id="in" driver="csv" url="data.csv" classpath="opencsv.jar"/>
  <connection id="out" driver="oracle" url="jdbc:oracle:thin:@localhost:1521:ORCL" 
      classpath="ojdbc14.jar" user="scott" password="tiger"/>
  <!-- Copy all CSV rows to a database table -->
  <query connection-id="in">
      <!-- Empty query means select all columns -->
      <script connection-id="out">
          INSERT INTO Table_Name VALUES (?id,?priority, ?summary, ?status)
      </script>
  </query>
</etl>

Initial URL
http://snippets.dzone.com/posts/show/3508

Initial Description
This example demonstrates usage of Scriptella ETL Tool to load CSV data into a database table.

Initial Title
Load CSV data into a database

Initial Tags
database, xml, csv

Initial Language
XML