5.1
Table Of Contents
- Using VMware vCenter Orchestrator Plug-Ins
- Contents
- Using VMware vCenter Orchestrator Plug-Ins
- Introduction to Orchestrator Plug-Ins
- Using the vCenter Server 5.1 Plug-In
- Configure the vCenter Server 5.1 Plug-In
- vCenter Server 5.1 Plug-In Scripting API
- Using the vCenter Server 5.1 Plug-In Inventory
- Access the vCenter Server 5.1 Plug-In Workflow Library
- vCenter Server 5.1 Plug-In Workflow Library
- Batch Workflows
- Cluster and Compute Resource Workflows
- Guest Operation Files Workflows
- Guest Operation Processes Workflows
- Custom Attributes Workflows
- Datacenter Workflows
- Datastore and Files Workflows
- Datacenter Folder Management Workflows
- Host Folder Management Workflows
- Virtual Machine Folder Management Workflows
- Basic Host Management Workflows
- Power Host Management Workflows
- Host Registration Management Workflows
- Networking Workflows
- Distributed Virtual Port Group Workflows
- Distributed Virtual Switch Workflows
- Standard Virtual Switch Workflows
- Resource Pool Workflows
- Storage Workflows
- Storage DRS Workflows
- Basic Virtual Machine Management Workflows
- Clone Workflows
- Linked Clone Workflows
- Linux Customization Clone Workflows
- Tools Clone Workflows
- Windows Customization Clone Workflows
- Device Management Workflows
- Move and Migrate Workflows
- Other Workflows
- Power Management Workflows
- Snapshot Workflows
- VMware Tools Workflows
- Using the vCO Library Plug-In
- Using the SQL Plug-In
- Using the SSH Plug-In
- Using the XML Plug-In
- Using the Mail Plug-In
- Using the Net Plug-In
- Using the Enumeration Plug-In
- Using the Workflow Documentation Plug-In
- Index
4 Provide the required information, and click Next.
a Type a database connection URL.
b Type a user name to access the database.
c Type a password to access the database.
5 Type an SQL delete statement.
An example syntax is:
DELETE FROM "table_name"
6 Click Submit to run the workflow.
Drop a JDBC Table
You can run a workflow from the Orchestrator client to test the dropping of a JDBC table.
Prerequisites
Log in to the Orchestrator client as a user who can run JDBC workflows.
Procedure
1 Click the Workflows view in the Orchestrator client.
2 In the workflows hierarchical list, open Library > JDBC > JDBC Examples to navigate to the JDBC drop
table example workflow.
3 Right-click the JDBC drop table example workflow and select Start workflow.
4 Provide the required information, and click Next.
a Type a password to access the database.
b Type a database connection URL.
c Type a user name to access the database.
5 Type an SQL drop statement.
An example syntax is:
DROP TABLE "table_name"
6 Click Submit to run the workflow.
Run a Complete JDBC Cycle
You can run a workflow from the Orchestrator client to test all JDBC example workflows in one full cycle.
Prerequisites
Log in to the Orchestrator client as a user who can run JDBC workflows.
Procedure
1 Click the Workflows view in the Orchestrator client.
2 In the workflows hierarchical list, open Library > JDBC > JDBC Examples to navigate to the Full JDBC
cycle example workflow.
3 Right-click the Full JDBC cycle example workflow and select Start workflow.
Chapter 4 Using the SQL Plug-In
VMware, Inc. 41