Book Image

Robotic Process Automation with Automation Anywhere

By : Husan Mahey
Book Image

Robotic Process Automation with Automation Anywhere

By: Husan Mahey

Overview of this book

With an increase in the number of organizations deploying RPA solutions, Robotic Process Automation (RPA) is quickly becoming the most desired skill set for both developers starting their career and seasoned professionals. This book will show you how to use Automation Anywhere A2019, one of the leading platforms used widely for RPA. Starting with an introduction to RPA and Automation Anywhere, the book will guide you through the registration, installation, and configuration of the Bot agent and Control Room. With the help of easy-to-follow instructions, you’ll build your first bot and discover how you can automate tasks with Excel, Word, emails, XML, and PDF files. You’ll learn from practical examples based on real-world business scenarios, and gain insights into building more robust and resilient bots, executing external scripts such as VBScripts and Python, and adding error handling routines. By the end of this RPA book, you’ll have developed the skills required to install and configure an RPA platform confidently and have a solid understanding of how to build complex and robust, yet performant, bots.
Table of Contents (20 chapters)

Chapter 15: Working with Databases

In the preceding chapter, you learned how to include PDF tasks as part of your automation scope. Through the use of walk-throughs, you learned how to extract text and images from PDF documents. The chapter also included splitting and merging multiple documents into a single PDF file. We finished off the chapter with an explanation of how to encrypt and decrypt documents as well as how to use the Dictionary variable to get file properties.

In this chapter, you will learn all about automating tasks using databases. We will explore how to connect to different types of databases such as Access, SQL, and Oracle. We will also look at using connection strings to connect to data sources. The walk-throughs will guide you on how to work with your datasets. This will include reading, updating, inserting, and deleting your data. You will also learn how to execute SQL Select statements against your databases.

In this chapter, we will be using the following...