Orchestrator Workflow Action to Configure vCenter Orchestrator to use an SQL Server Database

by Simon Sparks · 26 April 2014

The following is the vCO Workflow Script to Configure vCenter Orchestrator to use an SQL Server Database

var strCurrentDB = "SQLServer";

var intDatabasePort = 0;

var strHostName = "SQLServer";

var strActiveDirectoryDomainName = "vcoflow.local";

var strDatabaseFQDN = strHostName + "." + strActiveDirectoryDomainName;	

var blnSslEnabled = false;

var strDatabaseUserName = "vCenterOrchestrator";

var strDatabasePassWord = "P@55w0rd!";

var strDatabaseName = "vCenterOrchestrator";
	
var strDatabaseInstance = "";

var strDomainName = "";

var blnUseNTLM = false;
	
var objConfiguratorDatabase = Config.getDatabase();

var objConfiguratorDatabaseConfiguratorAction = objConfiguratorDatabase.getDatabaseConfiguratorAction();

var objConfiguratorDatabase = objConfiguratorDatabaseConfiguratorAction.getModel();
	objConfiguratorDatabase.setCurrentDB(strCurrentDB);
	objConfiguratorDatabase.setHost(strDatabaseFQDN);
	objConfiguratorDatabase.setPort(intDatabasePort);
	objConfiguratorDatabase.setSslEnabled(blnSslEnabled);
	objConfiguratorDatabase.setUser(strDatabaseUserName);
	objConfiguratorDatabase.setPassword(strDatabasePassWord);
	objConfiguratorDatabase.setInstanceName(strDatabaseInstance);
	objConfiguratorDatabase.getCurrentDB().setDBName(strDatabaseName);
	objConfiguratorDatabase.getCurrentDB().setDomainName(strDomainName);
	objConfiguratorDatabase.getCurrentDB().setUseNTLMv2(blnUseNTLM);

var strErrorValidate = objConfiguratorDatabaseConfiguratorAction.validate();

var strErrorExecute = objConfiguratorDatabaseConfiguratorAction.execute();

Discover more from Cloud Build Tools

Subscribe to get the latest posts sent to your email.

You may also like