Linking SAP HANA operations via CLI

The operations explained in this documentation section can also be performed through the Delphix Engine’s Command Line Interface (CLI).

The available operations are as follows:

Create
Disable
Enable
Delete

Prerequisites

To run any of the following commands, login to the Delphix Continuous Data Engine’s CLI with the admin user account.

Example

CODE

ssh admin@<CONTINUOUS-DATA-FQDN-or-IP>

Creating the dSource

Run the following command sets to create a dSource and define linking parameters. The first general section is generic for all ingestion mechanisms. You will need to follow up these default commands with the link parameters command specific to your choice of staging pull or push ingestion method.

Create a general dSource

Follow these commands to create a dSource without a specified ingestion method.

As a pre-requisite, to create a dSource via CLI, you must first create a source configuration. For more information on creating a source configuration, refer to Add Source Config using CLI. The following example uses testscfg source config.

Example

CODE

database link 
set linkData.type=AppDataStagedLinkData	 
set name=testds 
set group=Untitled 
set linkData.config=testscfg 
set linkData.environmentUser=rh86-hana2sp6-s1.dlpxdc.co/hdbadm 
set linkData.stagingEnvironment=rh86-hana2sp6-s1.dlpxdc.co 
set linkData.stagingEnvironmentUser=rh86-hana2sp6-s1.dlpxdc.co/hdbadm 
set linkData.syncParameters.parameters={\"resync\":true}

The commands above will remain common for all type of ingestion mechanisms. You can find specific parameters below:

Link parameters for Externally-initiated Backup:

Run the following commands to link parameters for externally initiated backup.

Example:

CODE

set linkData.parameters="{\"mountLocation\":\"/tmp/DIBR\",\"sDatabaseName\":\"DB_NAME\", \"stagingPush\":false,\"stagingDbParameters\":[{\"sSystemUserName\":\"delphix\",\"sSystemUserPassword\":\"password\"}],\"sDataBackupFilePath\":\"/tmp/data\",\"sLogBackupPath\":\"/tmp/log\"}"

Link parameters for Staging Push

Run the following commands to link parameters for staging push.

Example

CODE

set  
linkData.parameters="{\"mountLocation\":\"/tmp/DIBR\",\"sDatabaseName\":\"DB_NAME\", \"stagingPush\":true,\"stagingDbParameters\":[],\"sDataBackupFilePath\":\"\",\"sLogBackupPath\":\"\"}" 
commit;

Disabling the dSource

Run the following command to disable the dSource.

Example

CODE

Example -  
source 
select testdb 
disable 
commit

Enabling the dSource

Run the following command to enable the dSource.

Example

CODE

Example -  
source 
select testdb 
enable 
commit

Deleting the dSource

Run the following command to delete the dSource.

Example

CODE

source 
select testdb 
delete 
commit