Running ETL Scenarios

From Toolsverse Knowledge Base
Revision as of 15:15, 31 July 2014 by Maxlmus (Talk | contribs)

Jump to: navigation, search

Running ETL scenario using standalone executable

  1. Open APP_HOME/config/etl_config.xml file in your favorite text editor.
  2. Add connections for the particular ETL scenario
  3. Specify connections to use and scenarios to run
  4. Save
  5. Run ETL executable. For example c:\etl\etl.exe on Windows
  6. When it is finished check the etl.log file located under APP_HOME/logs

Example of the etl_config.xml:

<?xml version="1.0" encoding="UTF-8"?>
<config>
   <connections>
      <connection alias="test javadb">
         <driver>org.apache.derby.jdbc.EmbeddedDriver</driver>
         <url>jdbc:derby:{app.root.data}/demo/javadb</url>
      </connection>
      <connection alias="test oracle">
         <driver>oracle.jdbc.driver.OracleDriver </driver>
         <url>jdbc:oracle:thin:@localhost:1521:orcl1</url>
         <userid>user</userid>
         <password>password</password>   
         <params/>
      </connection>
   </connections>
 
   <active.connections>
      <sourses>
         <source alias="test javadb" />
      </sourses>
      <destination alias="test oracle"/> 
   </active.connections>
   <execute>
       <scenario name="move.xml" action="extract_load" />
   </execute>
</config>

In this example move.xml ETL scenario located under the {app.data}/scenario folder will be executed using extract_load action. Alias test javadb will be used for the source connection and alias test oracle for the destination.