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.
  • VMware vRealize Orchestrator Cookbook
  • Toc
  • feedback
VMware vRealize Orchestrator Cookbook

VMware vRealize Orchestrator Cookbook

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

VMware vRealize Orchestrator Cookbook

4.3 (10)
By: Langenhan

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