Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying VMware vRealize Orchestrator Cookbook
  • Table Of Contents Toc
  • Feedback & Rating feedback
VMware vRealize Orchestrator Cookbook

VMware vRealize Orchestrator Cookbook

By : Langenhan
4.3 (10)
Buy this Book
close
close
VMware vRealize Orchestrator Cookbook

VMware vRealize Orchestrator Cookbook

4.3 (10)
By: Langenhan
Buy this Book

Overview of this book

If you are a VMware administrator who is interested in automating your infrastructure, this book is for you. An understanding of basic programming concepts is advised. No previous knowledge of Orchestrator is required, although some previous knowledge of it will allow you to get started more easily.
Table of Contents (9 chapters)
close
close
close
Preface
Icon
Preface
Icon
Best approaches to reading this book
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Free Chapter
1
1. Installing and Configuring Orchestrator
Icon
1. Installing and Configuring Orchestrator
Icon
Introduction
Icon
Getting Orchestrator running in 5 minutes (or less)
Icon
Deploying the Orchestrator appliance
Icon
Installing Orchestrator on Windows
Icon
Two ways to configure Orchestrator
Icon
Important Orchestrator base configurations
Icon
Configuring Orchestrator with an external LDAP or Active Directory
Icon
Integrating Orchestrator into SSO and vSphere Web Client
Icon
Configuring an external database
2
2. Optimizing Orchestrator Configuration
Icon
2. Optimizing Orchestrator Configuration
Icon
Introduction
Icon
Plugin basics
Icon
Tuning the appliance
Icon
Tuning Java
Icon
Backup and recovery
Icon
Creating an Orchestrator cluster
Icon
Configuring the Orchestrator Service SSL certificate
Icon
Configuring e-mail
Icon
Redirecting Orchestrator Syslog to an external Syslog server
Icon
Configuring the Kerberos authentication
Icon
Configuring access to the local filesystem
Icon
Updating Orchestrator
3
3. Visual Programming
Icon
3. Visual Programming
Icon
Introduction
Icon
Workflow basics
Icon
Version control
Icon
Working with logs
Icon
Error handling in workflows
Icon
Resuming failed workflows
Icon
Using the workflow debugging function
Icon
Working with decisions
Icon
Working with loops
Icon
Working with presentations
Icon
Working with configurations
Icon
Working with actions
Icon
Linking actions in presentations
Icon
Waiting tasks
Icon
Sending and waiting for custom events
Icon
Using asynchronous workflows
Icon
Working with user interactions
Icon
Changing credentials
4
4. Working with Plugins
chevron up
Icon
4. Working with Plugins
Icon
Introduction
Icon
Working with the API
Icon
Working with mails
Icon
File operations
Icon
Working with SSH
Icon
Working with XML
Icon
Working with SQL
Icon
Working with PowerShell
Icon
Working with SOAP
Icon
Working with REST
Icon
Working with Active Directory
Icon
Working with SNMP
Icon
Working with AMQP
5
5. Basic Orchestrator Operations
Icon
5. Basic Orchestrator Operations
Icon
Introduction
Icon
Basic Orchestrator operations for Orchestrator elements
Icon
Changing elements in a workflow
Icon
Undelete workflows and actions
Icon
Importing and exporting Orchestrator elements
Icon
Synchronize Orchestrator elements between Orchestrator servers
Icon
Working with packages
Icon
User management
Icon
User preferences
Icon
Scheduling workflows
Icon
Workflow auto documentation
Icon
Orchestrator and vSphere Web Client
6
6. Advanced Operations
Icon
6. Advanced Operations
Icon
Introduction
Icon
Accessing the Orchestrator API via REST
Icon
Working with resources
Icon
Working with tags
Icon
Working with locks
Icon
Language packs (localization)
Icon
Working with policies
Icon
Managing remote Orchestrator
7
7. Working with VMware Infrastructure
Icon
7. Working with VMware Infrastructure
Icon
Introduction
Icon
Unmounting all the CD-ROMs of all VMs in a cluster
Icon
Provisioning a VM from a template
Icon
An approval process for VM provisioning
Icon
Working with the vCenter API (to change a VM's HA settings)
Icon
Standard vSwitch and Distributed Switch ports
Icon
Executing a program inside a VM
Icon
Configuring a vRA instance in Orchestrator
Icon
Configuring an external Orchestrator in vRA
Icon
Adding an Orchestrator endpoint
Icon
Integrating Orchestrator workflows in vRA
Icon
Managing AD users with vRA
8
Index
Icon
Index

Working with SQL

This recipe focuses on the interaction between Orchestrator and a SQL database. You will learn how to send SQL queries as well as commands to a database.

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 vcoapp.

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...

This recipe has multiple parts that will cover all aspects of working with a database.

Creating a JDBC connection URL

To connect to a SQL database, Orchestrator uses Java...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
End of Section 12
Next Section

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY