simplepush.xml

一个java的ETL工具

<?xml version="1.0" encoding='ISO-8859-1' ?>
<!DOCTYPE DATABASE_MIGRATION SYSTEM "ETL-2.dtd">

<!-- 	

Test of MS Access DB for Source and Target

Source Table:  FourTextFields
Target Table:  TargetTableWithThreeTextFields

-->


<DATABASE_MIGRATION>
	<RUN_PARAMETERS ERROR_LEVEL="STOP"/>
	
	<CONNECTION_SOURCE DRIVER="sun.jdbc.odbc.JdbcOdbcDriver" URL="jdbc:odbc:AccessTest" USERNAME="admin" PASSWORD="admin"/>

	<CONNECTION_TARGET DRIVER="sun.jdbc.odbc.JdbcOdbcDriver" URL="jdbc:odbc:AccessTest" USERNAME="admin" PASSWORD="admin"/>

	<TABLE_MIGRATION NAME="Move Records from FourTextFields to TargetTableWithThreeTextFields" TABLE_SOURCE="FourTextFields" TABLE_TARGET="TargetTableWithThreeTextFields">
		<FIELDS>
			<SOURCE_FIELDS>
				<FIELD_DEFINITION ID="1stField" NAME="Field1" SQL_TYPE="VARCHAR"/>
				<FIELD_DEFINITION ID="2ndField" NAME="Field2" SQL_TYPE="VARCHAR"/>
				<FIELD_DEFINITION ID="3rdField" NAME="Field3" SQL_TYPE="VARCHAR"/>
				<FIELD_DEFINITION ID="4thField" NAME="Field4" SQL_TYPE="VARCHAR"/>
			</SOURCE_FIELDS>
			<TARGET_FIELDS>
				<FIELD_DEFINITION ID="f1t" NAME="f1" SQL_TYPE="VARCHAR"/>
				<FIELD_DEFINITION ID="f2t" NAME="f2" SQL_TYPE="VARCHAR"/>
				<FIELD_DEFINITION ID="f3t" NAME="f3" SQL_TYPE="VARCHAR"/>
			</TARGET_FIELDS>
			<TEMPORARY_FIELDS>
<!--			VARIABLE_DEFINITION ID="temp1" SQL_TYPE="INTEGER"  -->
			</TEMPORARY_FIELDS>	
		</FIELDS>

		<INSERT_ROW_TRANSFER DESCRIPTION="Move Row When 1stField = c">
			<CONDITION>
				<COMPARISON OPERATOR="EQ">
					<FIRST_OPERAND>3rdField</FIRST_OPERAND>
					<SECOND_OPERAND>"12"</SECOND_OPERAND>
				</COMPARISON>
			</CONDITION>	
					
			<ACTION>
				<PUSH>
					<FROM_ID>1stField</FROM_ID>
					<TO_ID>f1t</TO_ID>
				</PUSH>
			</ACTION>

			<ACTION>
				<PUSH>
					<FROM_ID>2ndField</FROM_ID>
					<TO_ID>f2t</TO_ID>
				</PUSH>
			</ACTION>

			<ACTION>
				<PUSH>
					<FROM_ID>3rdField</FROM_ID>
					<TO_ID>f3t</TO_ID>
				</PUSH>
			</ACTION>
		</INSERT_ROW_TRANSFER>

		<UPDATE_FALLBACK_RULE>
			<TARGET_UPDATE_ID MODE="ADD">fieldName</TARGET_UPDATE_ID>		
		</UPDATE_FALLBACK_RULE>

	</TABLE_MIGRATION>
	
</DATABASE_MIGRATION>