CLI cookbook: creating a VDB config template

This topic will address how to create a VDB Config Template in the CLI; this functionality is also available in the GUI.

Procedure

ssh into your Delphix Engine using admin credentials.
CODE
```
ssh admin@<yourdelphixengine>
```

Go to database and then template and then create.

CODE

delphix > database template
delphix database template > create
delphix database template create *> set name=<set the name of database template>
delphix database template create *> set parameters.<set parameters you want>
delphix database template create *> set sourceType=<set the source>

Verify information and commit.

CODE

delphix database template create *> ls
delphix database template create *> commit

Example for Oracle:

CODE

ssh admin@testenginetestengine > database templatetestengine
database template > createtestengine 
database template create *> set name=oracletestengine 
database template create *> set parameters.PGA_TARGET=100Mtestengine 
database template create *> set parameters.MEMORY_TARGET=100Mtestengine 
database template create *> set sourceType=OracleVirtualSourcetestengine 
database template create *> lsProperties    
  type: DatabaseTemplate    
  name: oracle (*)    
  description: (unset)    
  parameters:        
    MEMORY_TARGET: 100M (*)        
    PGA_TARGET: 100M (*)    
  sourceType: OracleVirtualSource (*)testengine 
database template create *> commit

Example for SQL Server:

CODE

ssh admin@testengine testengine > database template
 testengine database template > create 
testengine database template create *> set name=mssqlTemplate 
testengine database template create *> set parameters.READ_COMMITTED_SNAPSHOT=ON 
testengine database template create *> set sourceType=MSSqlVirtualSource 
testengine database template create *> ls
Properties  type: DatabaseTemplate  name: mssqlTemplate (*)     description: (unset)
 
    parameters:
         READ_COMMITTED_SNAPSHOT: ON (*)
    sourceType: MSSqlVirtualSource (*) 
testengine database template create *> commit