ra_add_prop

Syntax

ra_add_prop propertyName, propertyValue

Parameters

• propertyName – specifies the property name you want to deploy.

  Property Name	Description
  builderType	The replication strategy used in a model. Valid values are CDC, TRANS_CDC, EVENTUAL, or TRANSACTIONAL.
  cdcRetentionMinutes	The amount of time to retain the CDC data. Default: 100 Minimum: 0 Maximum: 2147483647
  commitInterval	The commit batch size. Default: 100 Minimum: 0 Maximum: 2147483647
  ddlDropTable	Determines whether data definition language (DDL) drop table is replicated. Default: false Valid values are true or false.
  forceCleanDeploy	Forces a clean model deployment. Default: false Valid values are true or false.
  handleDDL	Determines whether DDL statements are replicated. Default: false Valid values are true or false.
  materializationRetryTime	The amount of time to wait before retrying a failed materialization. Default: 60 seconds Minimum: 0
  maxTasks.	The maximum number of concurrent materialization tasks Default: 100 Minimum: 0 Maximum: 2147483647
  primaryDBIsolationLevel	The connection transaction isolation level for the primary database. Default: TRANSACTION_READ_COMMITTED Valid values are TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, and TRANSACTION_SERIALIZABLE.
  primaryDriverName	A valid primary database JDBC driver name.
  primaryHost	A valid primary database host name.
  primaryPassword	A valid password for the primary database user.
  primaryPort	A valid primary database port number.
  primarySchema	A valid schema name that exists in the primary database.
  primaryURL.	A valid primary database JDBC URL.
  primaryUser	The primary database user name. The primaryUser property value cannot be blank.
  replicateDBIsolationLevel	The connection transaction isolation level for the replicate database. Default: TRANSACTION_READ_COMMITTED Valid values are TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, and TRANSACTION_SERIALIZABLE.
  replicateDriverName	A valid replicate database JDBC driver name.
  replicateHost	A valid replicate database host name.
  replicatePassword	A valid password for the replicate database user.
  replicatePort	A valid replicate database port number.
  replicateSchema	A valid schema name that exists in the replicate database.
  replicateURL	A valid replicate database JDBC URL.
  replicateUser	The replicate database user name. The replicateUser property value cannot be blank.
  repName	The replication model name.
  rollbackScanInterval	The scan time for CDC and Eventual scanners to check the shadow tables for unprocessed changes. Default: 5000 milliseconds Minimum: 0

• propertyValue – specifies the value of the property.

Examples

• Example 1 – Adds the Replication Strategy property to the HANA2HANA replication model:

  ra_add_prop builderType, TRANS_CDC
  go
   PROPERTY NAME PROPERTY VALUE
   ------------- --------------
   buildertype   TRANS_CDC

  You can separate parameters with a comma, a space, or a comma and a space.

• Example 2 – Adds the Replicate SAP HANA Dataserver Name property to the HANA2HANA replication model:

  ra_add_prop replicateuser, HANA_rep1
  go
   PROPERTY NAME PROPERTY VALUE
   ------------- --------------
   buildertype   TRANS_CDC
   replicateuser HANA_rep1

Usage

Use ra_add_prop to define the primary and replicate SAP HANA database properties.