This appendix provides the contents of the following sample configuration file for using with the Oracle GoldenGate Veridata import and export utilities.
For more information about the parameters used in this configuration file, see Section 5.3, "Configuration File Element Reference".
This section shows the contents of a sample configuration file. For more details about each element in this configuration file, see Section 5.3, "Configuration File Element Reference".
<?xml version="1.0" encoding="UTF-8"?>
<!-- Copyright (c) 2011, Oracle and/or its affiliates. All rights reserved. -->
<!DOCTYPE configuration SYSTEM "configuration.dtd">
<configuration validation="required">
<connection name="sqlScriptingSource" host="localhost" port="7860"
user="source2" password="source2" agent-timeout="6000" truncate-spaces="true" fetch-size="4"/>
<connection name="sqlScriptingTarget" host="localhost" port="7862"
user="target2" password="target2"/>
<connection name="connection-with-properties" host="localhost"
port="7860" user="source2" password="source2" repairUser="source2" repairPassword="source2" agent-timeout="4000"
truncate-spaces="false" fetch-size="3" use-ssl="false">
<description>
<![CDATA[ SQL Scripting Source Connection with user defined properties]]>
</description>
<conn-properties datatype-name="array" format="clob"/>
<conn-properties datatype-name="binary_double" format="number" scale="3"/>
<conn-properties datatype-name="binary_float" format="dec_float" precision="5"/>
<conn-properties datatype-name="timestamp" format="binary_timestamp" scale="10" timezone="(UTC+05:30) Kolkata - India Time (IT)"/>
</connection>
<connection name="nskScriptingSource" host="gg-xxxx.us.company.com" port="9999"/>
<connection name="nskScriptingTarget" host="gg-xxxx.us.company.com"" port="9999" />
<group name="column-mapping" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog="" source-schema="SOURCE2" target-schema="TARGET2">
<description>
<![CDATA[
This group has various types of column mapping specifications.
]]>
</description>
<compare-pair source-table="SYSMAPPING1" name="exlcudeCol6">
<excluded-column name="COL6"/>
</compare-pair>
<compare-pair source-table="SYSMAPPING2" name="userDefinedKeys">
<key-column source-name="COL1" target-name="COL2"/>
<key-column source-name="COL2" target-name="COL3"/>
</compare-pair>
<compare-pair source-table="SYSMAPPING3" name="userDefinedColsWildCard">
<column source-name="COL.*" />
</compare-pair>
<compare-pair source-table="SYSMAPPING3" name="userDefinedColsLiteral">
<column source-name="COL5" target-name="COL6" type="literal"/>
<column source-name="COL.*" />
</compare-pair>
</group>
<group name="table-mapping" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog="">
<description>
<![CDATA[
This group has table mapping specifications.
]]>
</description>
<compare-pair source-table="SYSMAPPING1" target-table="SYSMAPPING1" name="sameTables"
source-schema="SOURCE2" target-schema="TARGET2" >
</compare-pair>
<compare-pair source-table="SYSMAPPING2" target-table="SYSMAPPING3" name="diffTables"
source-catalog="" target-catalog="" source-schema="SOURCE2" target-schema="TARGET2">
</compare-pair>
<compare-pair source-table="CHAR_*" target-table="*" name="sameTables"
source-schema="SOURCE2" target-schema="TARGET2" >
</compare-pair>
</group>
<group name="delta-processing" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog="" source-schema="SOURCE2" target-schema="TARGET2">
<description>
<![CDATA[
This group has delta processing specifications.
]]>
</description>
<compare-pair source-table="SYSMAPPING1" target-table="SYSMAPPING1" name="scriptingConfigTest1"
delta-processing="true" >
<key-column source-name="COL1" target-name="COL2"/>
<key-column source-name="COL2" target-name="COL3"/>
<column source-name="COL5" target-name="COL6" type="literal"/>
<delta-config>
<source-config column-name="COL1">
<query><![CDATA[
SELECT MAX(COL1) from SYSMAPPING1
]]>
</query>
</source-config>
<target-config column-name="COL2">
<query><![CDATA[
SELECT MAX(COL1) from SYSMAPPING1
]]>
</query>
</target-config>
</delta-config>
</compare-pair>
</group>
<group name="enscribe-partition" source-conn="SourceNSKConnection" target-conn="TargetNSKConnection" validation="none">
<description>
<![CDATA[
This group has all the tables for NSK
]]>
</description>
<compare-pair source-file-pattern="\ZEUS.$FSS02.FSSVSRC.*" source-table="ACCTN*" target-file-pattern="\ZEUS.$FSS03.FSSVTAR.*" target-table="*" >
<enscribe-key
name = "Part1"
end-key ="1000"
format ="hexadecimal"
default ="false"
side="source"/>
<enscribe-key
name = "Part1"
start-key ="001"
format ="hexadecimal"
default ="false"
side="target"/>
<enscribe-key
name = "Both"
start-key ="001"
end-key ="1000"
default ="true"/>
</compare-pair>
</group>
<group name="sql-partition" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog="" source-schema="SOURCE2" target-schema="TARGET2">
<description>
<![CDATA[
This group has sql partition specification.
]]>
</description>
<compare-pair source-table="SYSMAPPING1" name="PART1">
<sql-partition name="partition_wo_default" >
<![CDATA[
col4 > 50
]]>
</sql-partition>
<sql-partition name="part2" side="source">
<![CDATA[
col2 > 20
]]>
</sql-partition>
<sql-partition name="part2" side="target">
<![CDATA[
col3 > 30
]]>
</sql-partition>
</compare-pair>
<compare-pair source-table="SYSMAPPING2" name="PART2">
<sql-partition name="partition_default" default="true" >
<![CDATA[
col3 > 30
]]>
</sql-partition>
</compare-pair>
</group>
<group name="compare-pair-with-pkey" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog="" source-schema="SOURCE2" target-schema="TARGET2">
<description>
<![CDATA[
This group has all the SYSMAPPING tables.
SYSMAPPING3 uses the user defined index B_SYSMAPPING4_IDX.
]]>
</description>
<compare-pair source-table="SYSMAPPING3" source-pkey="B_SYSMAPPING3_IDX"/>
<compare-pair source-table="SYSMAPPING*" target-table="*">
</compare-pair>
<compare-pair source-table="SYSMAPPING5" exclude="true"/>
</group>
<group name="enscribe-expand-ddl" source-conn="SourceNSKConnection" target-conn="TargetNSKConnection" validation="none">
<description>
<![CDATA[
This group has expand ddl specification for NSK
]]>
</description>
<compare-pair source-file-pattern="\ZEUS.$FSS02.FSSVSRC.*" source-table="TELLER" target-file-pattern="\ZEUS.$FSS03.FSSVTAR.*"
target-table="TELLER" name="excludeCompKeyCol">
<enscribe-info side="source"
dictionary="$FSS04.FSSVDCT" record="ENSSRC-REC">
<expandddl
redefined-columns ="include"
resolvedups="appendAlphaIndex"
expandGroupArrays="false"
ddl-separator="underscore"
zero-fill-length="1"
fix-long-names="false"
max-col-name-len="110"/>
</enscribe-info>
<enscribe-info side="target"
dictionary="$FSS04.FSSVDCT" record="ENSSRC-REC">
<expandddl />
</enscribe-info>
<excluded-column name="ENSCRIBE-NUMBER"/>
</compare-pair>
<compare-pair source-file-pattern="\ZEUS.$FSS02.FSSVSRC.*" source-table="TELLER" target-file-pattern="\ZEUS.$FSS03.FSSVTAR.*"
target-table="TELLER" name="userDefined">
<enscribe-info side="source"
dictionary="$FSS04.FSSVDCT" record="ENSSRC-REC"/>
<enscribe-info side="target"
dictionary="$FSS04.FSSVDCT" record="ENSSRC-REC"/>
<key-column source-name="KEY1" target-name="KEY1"/>
<column source-name="ENSCRIBE-STRING" target-name="ENSCRIBE-STRING"/>
<column source-name="FIRST-NAME" target-name="FIRST-NAME"/>
<column source-name="LAST-NAME" target-name="LAST-NAME"/>
<column source-name="ENSCRIBE-NUMBER" target-name="ENSCRIBE-NUMBER"/>
</compare-pair>
</group>
<group name="include-exclude-filter" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog=""
source-schema="SOURCE2" target-schema="TARGET2">
<description>
<![CDATA[
This group has include/exclude filter description
]]>
</description>
<filter type="include" table="SYSMAPPING*">
<colfilter type ="exclude">
<colfiltercol name="COL3" />
<colfiltercol name="COL6" />
</colfilter>
</filter>
<filter type="exclude" table="SYSMAPPING4">
</filter>
<compare-pair source-table="SYSMAPPING1" target-table="*" name="userDefinedCols"> <!-- exclude col6 -->
<column source-name="COL5" target-name="COL5"/>
<column source-name="COL6" target-name="COL6"/>
</compare-pair>
<compare-pair source-table="SYSMAPPING2" name="userDefinedKeys"> <!-- exclude col3 -->
<key-column source-name="COL1" target-name="COL2"/>
<key-column source-name="COL2" target-name="COL3"/>
</compare-pair>
<compare-pair source-table="SYSMAPPING3" target-table="*"><!-- exclude col3, col6 -->
</compare-pair>
<compare-pair source-table="SYSMAPPING4" target-table="*"/>
</group>
<group name="quotedSchemaQuotedTable" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog=""
source-schema=""abc 11"" target-schema=""abc 11"">
<description>
<![CDATA[
SQL group with simple quoted schema and quoted table name
]]>
</description>
<compare-pair source-table=""Quoted Table"" target-table="*" />
<compare-pair source-table=""Quoted*Table"" target-table="*" />
</group>
<group name="group-schema-wildcard" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog="" source-schema="source*" target-schema="*">
<description>
<![CDATA[
SQL group with source-schema wildcard at group level and no compare-pair schema.
]]>
</description>
<filter type="include" table="CHAR_TYPES*">
</filter>
<filter type="exclude" table="CHAR_TYPES2*">
</filter>
<compare-pair source-table="CHAR_TYPE*" target-table="*">
</compare-pair>
</group>
<job name="test" profile="allParams">
<group name="column-mapping"/>
<group name="table-mapping"/>
<group name="delta-processing"/>
</job>
<profile name="allParams">
<description>
<![CDATA[
Full Profile description.
]]>
</description>
<profile-general>
<param name="oos-format" value="xml" />
<param name="oos-xml-chunk-size" value="1000" />
<param name="reports-insync" value="true" />
<param name="reports-inflight" value="true" />
</profile-general>
<sorting-method>
<param name="sort-method" value="server" />
<param name="sort-src-temp-dir" value="/dummy/location" />
<param name="sort-tar-temp-dir" value="/dummy/location" />
</sorting-method>
<initial-compare>
<param name="max-thread" value="6" />
<param name="max-oos-record" value="777777" />
<param name="output-oos-rpt" value="true" />
<param name="update-rpt-second" value="100" />
<param name="update-rpt-record" value="100" />
<param name="limit-input-row" value="100" />
<param name="src-oracle-hint" value="FIRST_ROWS(10)" />
<param name="tar-oracle-hint" value="FIRST_ROWS(10)" />
<param name="rpt-msg" value="both" />
<param name="rpt-warn-msg-threshold" value="100" />
<param name="src-agent-static-port" value="777" />
<param name="tar-agent-static-port" value="777" />
<param name="src-nsk-name" value="$AA*" />
<param name="src-nsk-cpu" value="2" />
<param name="src-nsk-priority" value="1" />
<param name="tar-nsk-name" value="$AA*" />
<param name="tar-nsk-cpu" value="2" />
<param name="tar-nsk-priority" value="1" />
</initial-compare>
<confirm-out-of-sync>
<param name="coos-enable" value="false" />
<param name="coos-concurrent" value="false" />
<param name="batch-size" value="15"/>
<param name="coos-delay" value="2" />
<param name="max-oos-record" value="777777" />
<param name="output-oos-rpt" value="true" />
<param name="update-rpt-second" value="100" />
<param name="update-rpt-record" value="100" />
<param name="src-oracle-hint" value="FIRST_ROWS(10)" />
<param name="tar-oracle-hint" value="FIRST_ROWS(10)" />
<param name="rpt-msg" value="both" />
<param name="rpt-warn-msg-threshold" value="100" />
<param name="src-agent-static-port" value="777" />
<param name="tar-agent-static-port" value="777" />
<param name="src-nsk-name" value="$AA*" />
<param name="src-nsk-cpu" value="2" />
<param name="src-nsk-priority" value="1" />
<param name="tar-nsk-name" value="$AA*" />
<param name="tar-nsk-cpu" value="2" />
<param name="tar-nsk-priority" value="1" />
</confirm-out-of-sync>
<repair>
<param name="repair-after-compare" value="true" />
<param name="batch-size" value="15" />
<param name="txn-size" value="2" />
<param name="concurrent-operation" value="2" />
<param name="check-change-value" value="false" />
<param name="terminate-max-warn" value="77777" />
<param name="write-success-rpt" value="false" />
<param name="disable-trigger" value="true" />
</repair>
</profile>
</configuration>