Skip to main content
Skip table of contents

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

  1. ssh into your Delphix Engine using admin credentials.

    CODE
    ssh admin@<yourdelphixengine>
  2. 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>
  3. 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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.