Table of Contents
- Title and Copyright Information
- Preface
- Part I Understanding Oracle GoldenGate for Big Data
-
Part II Capturing JMS Messages
- 5 Configuring Message Capture
- 6 Parsing the Message
-
7
Message Capture Properties
- 7.1 Logging and Connection Properties
-
7.2
Parser Properties
- 7.2.1 Setting the Type of Parser
-
7.2.2
Fixed Parser Properties
- 7.2.2.1 fixed.schematype
- 7.2.2.2 fixed.sourcedefs
- 7.2.2.3 fixed.copybook
- 7.2.2.4 fixed.header
- 7.2.2.5 fixed.seqid
- 7.2.2.6 fixed.timestamp
- 7.2.2.7 fixed.timestamp.format
- 7.2.2.8 fixed.txid
- 7.2.2.9 fixed.txowner
- 7.2.2.10 fixed.txname
- 7.2.2.11 fixed.optype
- 7.2.2.12 fixed.optype.insertval
- 7.2.2.13 fixed.optype.updateval
- 7.2.2.14 fixed.optype.deleteval
- 7.2.2.15 fixed.table
- 7.2.2.16 fixed.schema
- 7.2.2.17 fixed.txind
- 7.2.2.18 fixed.txind.beginval
- 7.2.2.19 fixed.txind.middleval
- 7.2.2.20 fixed.txind.endval
- 7.2.2.21 fixed.txind.wholeval
-
7.2.3
Delimited Parser Properties
- 7.2.3.1 delim.sourcedefs
- 7.2.3.2 delim.header
- 7.2.3.3 delim.seqid
- 7.2.3.4 delim.timestamp
- 7.2.3.5 delim.timestamp.format
- 7.2.3.6 delim.txid
- 7.2.3.7 delim.txowner
- 7.2.3.8 delim.txname
- 7.2.3.9 delim.optype
- 7.2.3.10 delim.optype.insertval
- 7.2.3.11 delim.optype.updateval
- 7.2.3.12 delim.optype.deleteval
- 7.2.3.13 delim.schemaandtable
- 7.2.3.14 delim.schema
- 7.2.3.15 delim.table
- 7.2.3.16 delim.txind
- 7.2.3.17 delim.txind.beginval
- 7.2.3.18 delim.txind.middleval
- 7.2.3.19 delim.txind.endval
- 7.2.3.20 delim.txind.wholeval
- 7.2.3.21 delim.fielddelim
- 7.2.3.22 delim.linedelim
- 7.2.3.23 delim.quote
- 7.2.3.24 delim.nullindicator
- 7.2.3.25 delim.fielddelim.escaped
- 7.2.3.26 delim.linedelim.escaped
- 7.2.3.27 delim.quote.escaped
- 7.2.3.28 delim.nullindicator.escaped
- 7.2.3.29 delim.hasbefores
- 7.2.3.30 delim.hasnames
- 7.2.3.31 delim.afterfirst
- 7.2.3.32 delim.isgrouped
- 7.2.3.33 delim.dateformat | delim.dateformat.table | delim.dateform.table.column
-
7.2.4
XML Parser Properties
- 7.2.4.1 xml.sourcedefs
- 7.2.4.2 xml.rules
- 7.2.4.3 rulename.type
- 7.2.4.4 rulename.match
- 7.2.4.5 rulename.subrules
- 7.2.4.6 txrule.timestamp
- 7.2.4.7 txrule.timestamp.format
- 7.2.4.8 txrule.seqid
- 7.2.4.9 txrule.txid
- 7.2.4.10 txrule.txowner
- 7.2.4.11 txrule.txname
- 7.2.4.12 oprule.timestamp
- 7.2.4.13 oprule.timestamp.format
- 7.2.4.14 oprule.seqid
- 7.2.4.15 oprule.txid
- 7.2.4.16 oprule.txowner
- 7.2.4.17 oprule.txname
- 7.2.4.18 oprule.schemandtable
- 7.2.4.19 oprule.schema
- 7.2.4.20 oprule.table
- 7.2.4.21 oprule.optype
- 7.2.4.22 oprule.optype.insertval
- 7.2.4.23 oprule.optype.updateval
- 7.2.4.24 oprule.optype.deleteval
- 7.2.4.25 oprule.txind
- 7.2.4.26 oprule.txind.beginval
- 7.2.4.27 oprule.txind.middleval
- 7.2.4.28 oprule.txind.endval
- 7.2.4.29 oprule.txind.wholeval
- 7.2.4.30 colrule.name
- 7.2.4.31 colrule.index
- 7.2.4.32 colrule.value
- 7.2.4.33 colrule.isnull
- 7.2.4.34 colrule.ismissing
- 7.2.4.35 colrule.before.value
- 7.2.4.36 colrule.before.isnull
- 7.2.4.37 colrule.before.ismissing
- 7.2.4.38 colrule.after.value
- 7.2.4.39 colrule.after.isnull
- 7.2.4.40 colrule.after.ismissing
-
Part III Oracle GoldenGate Java Delivery
- 8 Configuring Java Delivery
- 9 Running Java Delivery
- 10 Configuring Event Handlers
-
11
Java Delivery Properties
- 11.1 Common Properties
- 11.2 Delivery Properties
-
11.3
Java Application Properties
- 11.3.1 Properties for All Handlers
- 11.3.2 Properties for Formatted Output
-
11.3.3
Properties for CSV and Fixed Format Output
- 11.3.3.1 gg.handler.name.format.delim
- 11.3.3.2 gg.handler.name.format.quote
- 11.3.3.3 gg.handler.name.format.metacols
- 11.3.3.4 gg.handler.name.format.missingColumnChar
- 11.3.3.5 gg.handler.name.format.presentColumnChar
- 11.3.3.6 gg.handler.name.format.nullColumnChar
- 11.3.3.7 gg.handler.name.format.beginTxChar
- 11.3.3.8 gg.handler.name.format.middleTxChar
- 11.3.3.9 gg.handler.name.format.endTxChar
- 11.3.3.10 gg.handler.name.format.wholeTxChar
- 11.3.3.11 gg.handler.name.format.insertChar
- 11.3.3.12 gg.handler.name.format.updateChar
- 11.3.3.13 gg.handler.name.format.deleteChar
- 11.3.3.14 gg.handler.name.format.truncateChar
- 11.3.3.15 gg.handler.name.format.endOfLine
- 11.3.3.16 gg.handler.name.format.justify
- 11.3.3.17 gg.handler.name.format.includeBefores
- 11.3.4 File Writer Properties
-
11.3.5
JMS Handler Properties
-
11.3.5.1
Standard JMS Settings
- 11.3.5.1.1 gg.handler.name.destination
- 11.3.5.1.2 gg.handler.name.user
- 11.3.5.1.3 gg.handler.name.password
- 11.3.5.1.4 gg.handler.name.queueOrTopic
- 11.3.5.1.5 gg.handler.name.persistent
- 11.3.5.1.6 gg.handler.name.priority
- 11.3.5.1.7 gg.handler.name.timeToLive
- 11.3.5.1.8 gg.handler.name.connectionFactory
- 11.3.5.1.9 gg.handler.name.useJndi
- 11.3.5.1.10 gg.handler.name.connectionUrl
- 11.3.5.1.11 gg.handler.name.connectionFactoryClass
- 11.3.5.1.12 gg.handler.name.localTX
- 11.3.5.1.13 gg.handlerlist.nop
- 11.3.5.1.14 gg.handler.name.physicalDestination
- 11.3.5.2 Group Transaction Properties
-
11.3.5.1
Standard JMS Settings
- 11.3.6 JNDI Properties
- 11.3.7 General Properties
- 11.3.8 Java Delivery Transaction Grouping
- 12 Developing Custom Filters, Formatters, and Handlers
- Part IV Troubleshooting the Oracle GoldenGate for Big Data
- A List of Included Examples