7.4

Prerequisites
Verify that the vRealize Orchestrator SQL Plug-In is installed and configured to connect to the target
database.
Custom Property Configuration Values
You use these options to create the custom property.
Table 1‑52. 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 specific
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
You can add a custom property to the blueprint Properties tab to associate the property with the overall
blueprint.
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 workflows
and creating and using vRealize Orchestrator script actions, see Developing with VMware vCenter
Orchestrator .
Custom Properties Reference
VMware, Inc. 119