Table of Contents
- Title and Copyright Information
- Preface
-
Part I Understanding Oracle GoldenGate Application Adapters
- 1 Understanding Oracle GoldenGate Adapters
- 2 Introducing the File Writer
- 3 Introducing the Java Adapter
- 4 Configuring Logging
-
Part II Creating Flat Files
- 5 Configuring the Flat File Adapter
- 6 Using the Flat File Adapter
- 7 Using Predefined Defaults and Formats
-
8
Flat File Properties
- User Exit Properties
-
File Writer Properties
- Output Format Properties
-
Output File Properties
- writer.files.onepertable
- writer.files.oneperopcode
- writer.files.prefix
- writer.files.data.rootdir, writer.files.data.ext, writer.files.data.tmpext
- writer.files.control.use, writer.files.control.rootdir, writer.files.control.ext
- writer.files.control.delim.chars/code, writer.files.control.eof.chars/code
- writer.files.formatstring
- writer.files.data.bom.code
- writer.files.includeprocessname
- writer.files.useownerfiles
- File Rollover Properties
-
Data Content Properties
- writer.rawchars
- writer.includebefores
- writer.afterfirst
- writer.includecolnames
- writer.omitvalues
- writer.diffsonly
- writer.omitplaceholders
- Metadata Columns
- Valid Metadata Columns
- Using Metadata Columns
- writer.metacols
- writer.metacols.metacol_name.fixedlen
- writer.metacols.metacol_name.column
- writer.metacols.token_name.novalue.chars | writer.metacols.token_name.novalue.code
- writer.metacols.metacol_name.fixedjustify
- writer.metacols.metacol_name.fixedpadchar.chars | writer.metacols.metacol_name.fixedpadchar.code
- writer.metacols.opcode.insert.chars | writer.metacols.opcode.insert.code
- writer.metacols.opcode.update.chars | writer.metacols.opcode.update.code
- writer.metacols.opcode.delete.chars | writer.metacols.opcode.delete.code
- writer.metacols.opcode.updatepk.chars | writer.metacols.opcode.updatepk.code
- writer.metacols.txind.begin.chars | writer.metacols.txind.begin.code
- writer.metacols.txind.middle.chars | writer.metacols.txind.middle.code
- writer.metacols.txind.end.chars | writer.metacols.txind.end.code
- writer.metacols.txind.whole.chars | writer.metacols.txind.whole.code
- writer.metacols.position.format
- writer.metacols.colname.omit
- writer.begintx.metacols, writer.endtx.metacols
-
DSV Specific Properties
- writer.dsv.nullindicator.chars | writer.dsv.nullindicator.code
- writer.dsv.fielddelim.chars | writer.dsv.fielddelim.code
- writer.dsv.linedelim.chars | writer.dsv.linedelim.code
- writer.dsv.quote.chars | writer.dsv.quote.code
- writer.dsv.quotes.policy
- writer.dsv.quotes.datatypes
- writer.dsv.nullindicator.escaped.chars | writer.dsv.nullindicator.escaped.code
- writer.dsv.fielddelim.escaped.chars | writer.dsv.fielddelim.escaped.code
- writer.dsv.linedelim.escaped.chars | writer.dsv.linedelim.escaped.code
- writer.dsv.quotes.escaped.chars | writer.dsv.quotes.escaped.code
- writer.dsv.onecolperline
- writer.dsv.quotealways
-
LDV Specific Properties
- writer.ldv.vals.missing.chars | writer.ldv.vals.missing.code
- writer.ldv.vals.present.chars | writer.ldv.vals.present.code
- writer.ldv.vals.null.chars | writer.ldv.vals.null.code
- writer.ldv.lengths.record.mode,writer. ldv.lengths.field.mode
- writer.ldv.lengths.record.length, writer.ldv.lengths.field.length
- Statistics and Reporting
-
Part III Capturing JMS Messages
- 9 Configuring Message Capture
- 10 Parsing the Message
-
11
Message Capture Properties
- Logging and Connection Properties
-
Parser Properties
- Setting the Type of Parser
-
Fixed Parser Properties
- fixed.schematype
- fixed.sourcedefs
- fixed.copybook
- fixed.header
- fixed.seqid
- fixed.timestamp
- fixed.timestamp.format
- fixed.txid
- fixed.txowner
- fixed.txname
- fixed.optype
- fixed.optype.insertval
- fixed.optype.updateval
- fixed.optype.deleteval
- fixed.table
- fixed.schema
- fixed.txind
- fixed.txind.beginval
- fixed.txind.middleval
- fixed.txind.endval
- fixed.txind.wholeval
-
Delimited Parser Properties
- delim.sourcedefs
- delim.header
- delim.seqid
- delim.timestamp
- delim.timestamp.format
- delim.txid
- delim.txowner
- delim.txname
- delim.optype
- delim.optype.insertval
- delim.optype.updateval
- delim.optype.deleteval
- delim.schemaandtable
- delim.schema
- delim.table
- delim.txind
- delim.txind.beginval
- delim.txind.middleval
- delim.txind.endval
- delim.txind.wholeval
- delim.fielddelim
- delim.linedelim
- delim.quote
- delim.nullindicator
- delim.fielddelim.escaped
- delim.linedelim.escaped
- delim.quote.escaped
- delim.nullindicator.escaped
- delim.hasbefores
- delim.hasnames
- delim.afterfirst
- delim.isgrouped
- delim.dateformat | delim.dateformat.table | delim.dateform.table.column
-
XML Parser Properties
- xml.sourcedefs
- xml.rules
- rulename.type
- rulename.match
- rulename.subrules
- txrule.timestamp
- txrule.timestamp.format
- txrule.seqid
- txrule.txid
- txrule.txowner
- txrule.txname
- oprule.timestamp
- oprule.timestamp.format
- oprule.seqid
- oprule.txid
- oprule.txowner
- oprule.txname
- oprule.schemandtable
- oprule.schema
- oprule.table
- oprule.optype
- oprule.optype.insertval
- oprule.optype.updateval
- oprule.optype.deleteval
- oprule.txind
- oprule.txind.beginval
- oprule.txind.middleval
- oprule.txind.endval
- oprule.txind.wholeval
- colrule.name
- colrule.index
- colrule.value
- colrule.isnull
- colrule.ismissing
- colrule.before.value
- colrule.before.isnull
- colrule.before.ismissing
- colrule.after.value
- colrule.after.isnull
- colrule.after.ismissing
-
Part IV Delivering Java Messages
- 12 Configuring Message Delivery
- 13 Using the Java User Exit
- 14 Configuring Event Handlers
-
15
Message Delivery Properties
- User Exit Properties
-
Java Application Properties
- Properties for All Handlers
- Properties for Formatted Output
-
Properties for CSV and Fixed Format Output
- gg.handler.name.format.delim
- gg.handler.name.format.quote
- gg.handler.name.format.metacols
- gg.handler.name.format.missingColumnChar
- gg.handler.name.format.presentColumnChar
- gg.handler.name.format.nullColumnChar
- gg.handler.name.format.beginTxChar
- gg.handler.name.format.middleTxChar
- gg.handler.name.format.endTxChar
- gg.handler.name.format.wholeTxChar
- gg.handler.name.format.insertChar
- gg.handler.name.format.updateChar
- gg.handler.name.format.deleteChar
- gg.handler.name.format.endOfLine
- gg.handler.name.format.justify
- gg.handler.name.format.includeBefores
- File Writer Properties
-
JMS Handler Properties
-
Standard JMS Settings
- gg.handler.name.destination
- gg.handler.name.user
- gg.handler.name.password
- gg.handler.name.queueOrTopic
- gg.handler.name.persistent
- gg.handler.name.priority
- gg.handler.name.timeToLive
- gg.handler.name.connectionFactory
- gg.handler.name.useJndi
- gg.handler.name.connectionUrl
- gg.handler.name.connectionFactoryClass
- gg.handler.name.localTX
- gg.handlerlist.nop
- Group Transaction Properties
-
Standard JMS Settings
- JNDI Properties
- General Properties
- 16 Developing Custom Filters, Formatters, and Handlers
- Part V Troubleshooting the Oracle GoldenGate Adapters
- Part VI Appendix
- A Adapter Examples