Alter Process

The “alter” command is used to change either Capture or Apply Process parameters. The id parameter can not be changed. The Process has to exist otherwise the command will fail. The Apply Parameter capturename  and the Capture Parameter name can be altered only in the case that it has not been configured earlier.

Note – You can alter the Process even if it is running, however these changes will only be implemented after this Process has been stopped and rerun.

Depending on the process type and  RDBMS type the “alter” command may utilise different set of the parameters. 

The parameters for Capture:

• SQL Server Capture Parameters
• Oracle Capture Parameters

The parameters for Apply:

• SQL Server Apply Parameters
• Oracle Apply Parameters
• PostgreSQL Apply Parameters
• MySQL Apply Parameters
• Snowflake Apply Parameters
• Redshift Apply Parameters
• S3 Apply Parameters

The command can be invoked from repcli or via REST API or Web UI.

CLI Syntax:

REST API:

• Endpoint: https://repstance_url/configure/process
• Method: POST
• Header:
  • Content-Type: application/json
  • X-Token: token
• Body:
  {
    "command": "alter",
    "parameters": [
        ["process","capture|apply"],
        ["id","processID"],
        ["dbtype","mssql|oracle|others"],
        [list of parameters to be modified]
        ["preview","0|1"]
    ]
  }

Server response:

• HTTP Status – status of the command, possible codes are:
  • 200 – if no error occurs
  • 422 – if error occurs
• Body:
  {
        "Status":"{Failed|Completed}",
        "Message":"The command execution details"
  }

Examples

The following example shows how to modify Capture Process with id=1 to reload data for the“dbo.mytable1”  and instruct corresponding Apply processes to “truncate” table before data loading: 

The following example shows how to change users' password for the Apply Process (id=1): 

Web UI

 To edit the process, click “Edit” on the desired process tab.

It will open “Edit process tab”. For changing database connection click “Edit” in Database settings. For changing Replication Objects, click on “Replication Object Wizard” or edit rules under Replication Object Settings.

After editing the process, click on “Save Process” button. 

Note – after editing running process, it requires to restart it. After  click on “Save Process”  button, you'll see form that will propose you to restart it