Connecting Microservices Architecture to Classic Architecture

B Connecting Microservices Architecture to Classic Architecture

For establishing a connection to Classic Architecture, the Distribution Server in Oracle GoldenGate Microservices must know where to place the remote trail file for reading.

To connect Oracle GoldenGate Microservices and Classic Architecture follow these steps:

Note:

For this procedure to work only the ogg protocol is supported and an existing Extract must be running in Microservices.

Task 1: Add a Distribution Path

Launch the Distribution Server web interface.
Click the plus (+) sign next to Path. The Add Path page is displayed.

Enter the details:

Rule Configuration Description

Enable filtering

Rule Configuration	Description
Enable filtering	If you enable filtering by selecting it from the toggle button and click the `Add Rule` button, you’ll see the Rule Definition dialog box. `Rule Name` `Rule Action`: Select either Exclude or Include `Filter Type`: Select from the following list of options: `Object Type`: Select from three object types: `DML`, `DDL`, and `Procedure` `Object Names:` Select this option to provide an existing object name. A 3–part naming convention depends on whether you are using CDB. With CDB, you need to use a 3–part naming convention, otherwise a 2–part convention is mandatory. 3–part convention includes container, `schema`, `object`. 2–part convention includes `schema`, `object name`. `Procedure Feature Name`: Select this option to filter, based on existing procedure feature name. `Column Based`: If you select this option, you are presented with the option to enter the table and column name to which the rule applies. You can filter out using column value with `LT`, `GT`, `EQ`, `LE`, `GE`, `NE` conditions. You can also specify if you want to have before image or after image in filtered data. `Tag:` Select this option to set the filter based on tags. `Chunk ID`: Displays the configuration details of database shards, however, the details can’t be edited. `Negate`: Select this check box if you need to negate any existing rule. You can also see the JSON script for the rule by clicking the JSON tab.

If you enable filtering by selecting it from the toggle button and click the Add Rule button, you’ll see the Rule Definition dialog box.

Rule Name
Rule Action: Select either Exclude or Include
Filter Type: Select from the following list of options:
- Object Type: Select from three object types: DML, DDL, and Procedure
- Object Names: Select this option to provide an existing object name. A 3–part naming convention depends on whether you are using CDB. With CDB, you need to use a 3–part naming convention, otherwise a 2–part convention is mandatory. 3–part convention includes container, schema, object. 2–part convention includes schema, object name.
- Procedure Feature Name: Select this option to filter, based on existing procedure feature name.
- Column Based: If you select this option, you are presented with the option to enter the table and column name to which the rule applies. You can filter out using column value with LT, GT, EQ, LE, GE, NE conditions. You can also specify if you want to have before image or after image in filtered data.
- Tag: Select this option to set the filter based on tags.
- Chunk ID: Displays the configuration details of database shards, however, the details can’t be edited.
Negate: Select this check box if you need to negate any existing rule.

You can also see the JSON script for the rule by clicking the JSON tab.

Additional Options	Description
Eof Delay (cent sec)	You can specify the Eof Delay in centiseconds. On Linux platforms, the default settings can be retained. However, on non-Linux platforms, you may need to adjust this setting for high bandwidth, high latency networks, or for networks that have Quality of Service (QoS) settings (DSCP and Time of Service (ToS) ).
Checkpoint Frequency	Frequency of the path that is taking the checkpoint (in seconds).
TCP Flush Bytes	Enter the TCP flush size in bytes.
TCP Flush Seconds	Enter the TCP flush interval in seconds.
TCP Options	Section
DSCP	Select the Differentiated Services Code Point (DSCP) value from the drop-down list, or search for it from the list.
TOS	Select the Type of service (TOS) value from the drop-down list.
TCP_NODELAY	Enable this option to prevent delay when using the Nagle’s option.
Quick ACK	Enable this option to send quick acknowledgment after receiving data.
TCP_CORK	Enable this option to allow using the Nagle’s algorithm cork option.
System Send Buffer Size	You can set the value for the send buffer size for flow control.
System Receive Buffer Size	You can set the value for the receive buffer size for flow control.
Keep Alive	Timeout for keep-alive.

Click Create Path or Create and Run, as required. Select Cancel if you need to get out of the Add Path page without adding a path.

Once the path is created, you’ll be able to see the new path in the Overview page of the Distribution Server.

Task 2: Start Manager in Classic Architecture

Log in to GGSCI.
Use the command:
```
START MANAGER
```
For more information, see START MANAGER in Reference for Oracle GoldenGate.

Task 3: Create and start Replicat in Classic Architecture

If you are already logged into GGSCI, use the command:

ADD REPLICAT group_name

group_name is the name of the Replicat group. For more information, see Creating an Online Replicat Group in Administering Oracle GoldenGate and GGSCI Command Interface Help. in Reference for Oracle GoldenGate.