7.1

Prerequisites
Verify that the vRealize Orchestrator SQL Plug-In is installed and congured to connect to the target
database.
Custom Property Configuration Values
You use these options to create the custom property. For the general steps, see “Create a vRealize
Orchestrator Action Custom Property Denition,” on page 90.
Table 4‑6. Database Query Custom Property Configuration Values
Option Value
Name You can use any string.
Data type String
Display as Dropdown
Values External
Action folder com.vmware.vra.sql
Script action executeSQLSelectOnDatabase
This script action is an example script. You can create
specic actions for your environment.
Input parameters
n
databaseName. Name of the database to which
vRealize Orchestrator is connected.
n
sqlSelectQuery. The SQL select query that you are
running on the database to retrieve the values. For
example, select * <table name>.
n
keyColumnName. Name of the database column that
is the key for the key pair value.
n
valueColumnName. Name of the database column
from which you are retrieving values.
Blueprint Configuration
To add the custom property to the blueprint Properties tab, see “Add a Custom Property or Property Group
as a Blueprint Machine Property,” on page 95.
Custom Action Custom Property Definition
You add a custom property to retrieve data from a source using a custom vRealize Orchestrator action when
you want users to select the retrieved values in the request form.
Limitations
Limitations depend on your custom action.
Prerequisites
Verify that you have a working vRealize Orchestrator action. For information about developing workows
and creating and using vRealize Orchestrator script actions, see Developing with VMware vCenter
Orchestrator .
The action script must accept the input parameter values. You can congure the values as key value pairs.
You can present user-readable names for less friendly identiers using key value pairs.
Custom Property Configuration Values
You use these options to create the custom property. For the general steps, see “Create a vRealize
Orchestrator Action Custom Property Denition,” on page 90.
Custom Properties Reference
102 VMware, Inc.