Configure subscription.config
Edit subscription.config with destination database details and replication parameters.
| Parameter | Description | Purpose | Example |
|---|---|---|---|
| name | Unique name assigned to the sink connector. | Used by the system to identify and manage the connector instance. | oracle-sink-connector |
| bootstrap.ip | IP address of the Helyx physical server or VM. | Enables the sink connector to connect to the broker and consume change events. | 192.xxx.xxx.xxx |
| connection.host | Hostname or IP address of the destination database server. | Used to establish the connection with the destination database. | 192.xxx.xxx.xxx |
| connection.port | Port number of the destination database. | Specifies the port used for connecting to the destination database. | 5432 |
| connection.db | Name of the destination database. | Indicates which database the sink connector should write the replicated data to. | postgres |
| connection.password | Password of the destination database replication user (helyx). | Used for authentication when connecting to the destination database. | ******** |
Start Subscription
<path_to_serverconfig> -createsub -s <path_to_subscription.config> -pub <path_to_publication.config> -tables <path_to_tablelist.config>Verify Status of Publication & Subscription
<path_to_serverconfig> -status -pub -s <path_to_publication.config><path_to_serverconfig> -status -sub -s <path_to_subscription.config>