Home
/
Middleware
/
Oracle GoldenGate Adapters
1/28
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Part I Understanding Oracle GoldenGate Adapters
1
Understanding Oracle GoldenGate Adapters
1.1
Adapters Overview
1.1.1
Oracle GoldenGate
1.1.2
Adapter Integration Options
1.2
Using Oracle GoldenGate Adapters Properties
1.2.1
Values in Property Files
1.2.2
Location of Property Files
1.2.3
Using Comments in the Property File
1.2.4
Variables in Property Names
1.3
Oracle GoldenGate Documentation
2
Introducing the File Writer
2.1
Overview of the Adapter for Flat Files
2.2
Typical Configuration
3
Introducing the Java Adapter
3.1
Oracle GoldenGate VAM Message Capture
3.1.1
Message Capture Configuration Options
3.1.2
Typical Configuration
3.2
Oracle GoldenGate Java User Exit
3.2.1
Delivery Configuration Options
4
Configuring Logging
4.1
Oracle GoldenGate Adapters Default Logging
4.1.1
Default Implementation Type
4.1.2
Default Message Logging
4.2
Changing the Default Logging
4.2.1
Changing the Logging Type
4.2.2
Changing the Logging Configuration
4.2.3
Enabling Debug
Part II Creating Flat Files
5
Configuring the Flat File Adapter
5.1
Configuring the Adapter for Writing Flat Files
5.1.1
User Exit Extract Parameters
5.1.2
User Exit Properties
5.2
Recommended Data Integration Approach
5.3
Producing Data Files
6
Using the Flat File Adapter
6.1
Working with Control Files
6.2
Working with Statistical Summaries
6.3
Managing Oracle GoldenGate processes
6.4
Trail Recovery Mode
6.5
Locating Error Messages
7
Using Predefined Defaults and Formats
7.1
Overview of Predefined Defaults and Formats
7.1.1
Default Properties
7.1.2
Specifying Consumer Formats
7.2
Siebel Remote Format
7.3
Ab Initio Format
7.4
Netezza Format
7.5
Greenplum Format
7.6
Comma Delimited Format
8
Flat File Properties
8.1
User Exit Properties
8.1.1
Logging Properties
8.1.2
General Properties
8.2
File Writer Properties
8.2.1
Output Format Properties
8.2.2
Output File Properties
8.2.3
File Rollover Properties
8.2.4
Data Content Properties
8.2.5
DSV Specific Properties
8.2.6
LDV Specific Properties
8.2.7
Statistics and Reporting
Part III Capturing JMS Messages
9
Configuring Message Capture
9.1
Configuring the VAM Extract
9.1.1
Adding the Extract
9.1.2
Configuring the Extract Parameters
9.1.3
Configuring Message Capture
9.2
Connecting and Retrieving the Messages
9.2.1
Connecting to JMS
9.2.2
Retrieving Messages
9.2.3
Completing the Transaction
10
Parsing the Message
10.1
Parsing Overview
10.1.1
Parser Types
10.1.2
Source and Target Data Definitions
10.1.3
Required Data
10.1.4
Optional Data
10.2
Fixed Width Parsing
10.2.1
Header
10.2.2
Header and Record Data Type Translation
10.2.3
Key identification
10.3
Delimited parsing
10.3.1
Metadata Columns
10.3.2
Parsing Properties
10.3.3
Parsing Steps
10.4
XML Parsing
10.4.1
Styles of XML
10.4.2
XML Parsing Rules
10.4.3
XPath Expressions
10.4.4
Other Value Expressions
10.4.5
Transaction Rules
10.4.6
Operation Rules
10.4.7
Column Rules
10.4.8
Overall Rules Example
10.5
Source definitions Generation Utility
11
Message Capture Properties
11.1
Logging and Connection Properties
11.1.1
Logging Properties
11.1.2
JMS Connection Properties
11.1.3
JNDI Properties
11.2
Parser Properties
11.2.1
Setting the Type of Parser
11.2.2
Fixed Parser Properties
11.2.3
Delimited Parser Properties
11.2.4
XML Parser Properties
Part IV Delivering Java Messages
12
Configuring Message Delivery
12.1
Configure the JRE in the User Exit Properties File
12.2
Configure a Data Pump to Run the User Exit
12.3
Configure the Java Handlers
13
Using the Java User Exit
13.1
Starting the Application
13.2
Restarting the Application at the Beginning of a Trail
14
Configuring Event Handlers
14.1
Specifying Event Handlers
14.2
JMS Handler
14.3
File Handler
14.4
Custom Handlers
14.5
Formatting the Output
14.6
Reporting
15
Message Delivery Properties
15.1
User Exit Properties
15.1.1
Logging Properties
15.1.2
General Properties
15.1.3
JVM boot Options
15.1.4
Statistics and Reporting
15.2
Java Application Properties
15.2.1
Properties for All Handlers
15.2.2
Properties for Formatted Output
15.2.3
Properties for CSV and Fixed Format Output
15.2.4
File Writer Properties
15.2.5
JMS Handler Properties
15.2.6
JNDI Properties
15.2.7
General Properties
16
Developing Custom Filters, Formatters, and Handlers
16.1
Filtering Events
16.2
Custom Formatting
16.2.1
Coding a Custom Formatter in Java
16.2.2
Using a Velocity Template
16.3
Coding a Custom Handler in Java
16.4
Additional Resources
Part V Troubleshooting the Oracle GoldenGate Adapters
17
Troubleshooting the Flat File Adapter
17.1
Checking Oracle GoldenGate
17.2
Checking the Configuration
17.3
Checking the Log File
17.4
Contacting Oracle Support
18
Troubleshooting the Java Adapters
18.1
Checking for Errors
18.2
Recovering after an Abend
18.3
Reporting Issues
Part VI Appendix
A
Adapter Examples
A.1
List of Included Examples
A.2
Configuring Logging
A.2.1
Example Oracle GoldenGate Java User Exit Defaults
A.2.2
Customizing Logging
Scripting on this page enhances content navigation, but does not change the content in any way.