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 

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 

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:

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 

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

Example -  
source 
select testdb 
disable 
commit 

Enabling the dSource

Run the following command to enable the dSource.

Example

Example -  
source 
select testdb 
enable 
commit 

Deleting the dSource 

Run the following command to delete the dSource.  

Example 

source 
select testdb 
delete 
commit