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)

Connecting to, and disconnecting from, databases

When working with databases, the first thing you would do with most development platforms is to establish a connection with the database. There are many types of databases that are used, the most widely used being the following:

  • SQL or Oracle
  • SQLite
  • MS Access

A connection to all of these database types can be established using a connection string, which is also quite often used for bespoke or propriety databases. Automation Anywhere is designed to connect to the most common database types by just providing the key connection details, such as the server/database name and user credentials. It also provides the means to connect via a connection string. This removes any restrictions, allowing you to connect to any type of database for your automation needs.

As with most connections in Automation Anywhere, it uses a session to identify each connection. The Database: Connect action is used to create a database session...