Book Image

VMware vRealize Orchestrator Cookbook - Second Edition

By : Daniel Langenhan
Book Image

VMware vRealize Orchestrator Cookbook - Second Edition

By: Daniel Langenhan

Overview of this book

VMware vRealize Orchestrator is a powerful automation tool designed for system administrators and IT operations staff who are planning to streamline their tasks and are waiting to integrate the functions with third-party operations software. This book is an update to VMware vRealize Orchestrator Cookbook and is blend of numerous recipes on vRealize Orchestrator 7. This book starts with installing and configuring vRealize Orchestrator. We will demonstrate how to upgrade from previous versions to vRealize Orchestrator 7. You will be taught all about orchestrator plugins and how to use and develop various plugins that have been enhanced in Orchestrator 7. Throughout this book, you will explore the new features of Orchestrator 7, such as the introduction of the control center, along with its uses. You will also come to understand visual programming, how to integrate base plugins into workflows, and how to automate VMware. You will also get to know how to troubleshoot vRealize Orchestrator. By the end of this book, you will be able to get the most out of your Orchestrator installation, and will be able to develop complex workflows and create your own highly integrated automations of vRealize environments.

Related Content you might be interested in

Current Title:

Small book image
VMware vRealize Orchestrator Cookbook - Second Edition
Daniel Langenhan
Nov, 2016 | 556 pages
No titles found
Table of Contents (19 chapters)
VMware vRealize Orchestrator Cookbook Second Edition
VMware vRealize Orchestrator Cookbook Second Edition
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Installing and Configuring Orchestrator
Installing and Configuring Orchestrator
Introduction
Deploying the Orchestrator appliance
Important Orchestrator settings
Configuring an external database
Configuring external authentication
Connecting to vCenter
Installing plugins
Updating Orchestrator
Moving from Windows to appliance
Orchestrator Client and 4K display scaling
2
Optimizing Orchestrator Configuration
Optimizing Orchestrator Configuration
Introduction
Tuning the appliance
Tuning Java
Configuring the Kerberos authentication
Configuring access to the local filesystem
Configuring the Orchestrator service SSL certificate
Orchestrator log files
Redirecting Orchestrator logs to an external server
Backup and recovery
Control Center titbits
3
Distributed Design
Distributed Design
Introduction
Building an Orchestrator cluster
Load-balancing Orchestrator
Upgrading a cluster
Managing remote Orchestrators
Synchronizing Orchestrator elements between Orchestrator servers
4
Programming Skills
Programming Skills
Introduction
Version control
Changing elements in a workflow
Importing and exporting Orchestrator elements
Working with packages
Workflow auto documentation
Resuming failed workflows
Using the workflow debugging function
Undelete workflows and actions
Scheduling workflows
Sync presentation settings
Locking elements
5
Visual Programming
Visual Programming
Introduction
Scripting with logs
Scripting with decisions
Error handling in workflows
Scripting with loops
Workflow presentations
Linking actions in presentations
Changing credentials during runtime
6
Advanced Programming
Advanced Programming
Introduction
JavaScript complex variables
Working with JSON
JavaScript special statements
Turning strings into objects
Working with the API
Creating actions
Waiting tasks
Sending and waiting for custom events
Using asynchronous workflows
Scripting with workflow tokens
Working with user interactions
7
Interacting with Orchestrator
Interacting with Orchestrator
Introduction
User management
User preferences
Using Orchestrator though the vSphere Web Client
Accessing Orchestrator REST API
Accessing the Control Center via the REST plugin
Running Orchestrator workflows using PowerShell
Using PHP to access the REST API
8
Better Workflows and Optimized Working
Better Workflows and Optimized Working
Introduction
Working with resources
Working with configurations
Working with Orchestrator tags
Using the Locking System
Language packs (localization)
Working with policies
9
Essential Plugins
Essential Plugins
Introduction
Working with e-mail
File operations
Working with SSH
Working with REST
10
Built-in Plugins
Built-in Plugins
Introduction
Working with XML
Working with SQL (JDBC)
Working with SQL (SQL plugin)
Working with PowerShell
Working with SOAP
Working with Active Directory
Working with SNMP
Working with AMQP
11
Additional Plugins
Additional Plugins
Introduction
NSX integration
Horizon integration
vSphere Replication
SRM (Site Recovery Manager) integration
vROps (vRealize Operations Manager) integration
12
Working with vSphere
Working with vSphere
Introduction
Working with the vCenter API (to change a VM's HA settings)
Standard vSwitch and Distributed Switch ports
Getting started with vAPI
Custom Attributes and Tags (vAPI)
Executing a program inside a VM
An approval process for VM provisioning
13
Working with vRealize Automation
Working with vRealize Automation
Introduction
Working with the vRA-integrated Orchestrator
Automating a vRA instance in Orchestrator
Configuring an external Orchestrator in vRA
Adding Orchestrator as an infrastructure endpoint
Adding an Orchestrator endpoint
Integrating Orchestrator workflows as XaaS Blueprints
Managing AD users with vRA
Using the Event Manager to start workflows

Working with SQL (SQL plugin)

In this recipe, we will explore the SQL plugin to work with SQL. This is a bit different from the JDBC recipe.

Getting ready

Obviously, we need a database. This database can be PostgreSQL, MS SQL, Oracle, or MySQL. For testing, you can use the PostgreSQL database that is implemented in the appliance (refer to the Tuning the appliance recipe in Chapter 2, Optimizing Orchestrator Configuration). Also, take a look at the There's more... section of this recipe.

We will use a Microsoft SQL 2008 R2 database in this example; however, the steps are the same for all databases. The database we will be using is called testDB.

You will need an existing database and a user who is able to create/drop tables as well as insert/delete information, for example, the DBO role.

How to do it...

See the following sections.

Add an SQL DB to Orchestrator

In this section, we will connect an SQL server to Orchestrator:

  1. Start the Library | SQL | Configuration | Add a database workflow.

  2. Enter a name...

Previous Section
End of Section 5
Next Section