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)

Designing modular task bots

For this chapter, we will take a fictitious scenario where you are a bot developer tasked with building a bot. The walk-throughs will guide you from initial design to modular design right through to actually building the bot. In a nutshell, the task for your bot is this:

Extracting all the tables and data from a specific SQLite database to a new Excel workbook. The workbook should consist of a worksheet for each table in the SQLite database.

The following additional details are also given:

  • The local repository location is C:\Hands-On-RPA-with-AA-Sample-Data\.
  • The Excel spreadsheet should be named Output.xlsx and saved in the local repository folder. If this file already exists, it should be deleted and a new one should be created.
  • The SQLite database file is available in the GitHub repository; it is named Chapter15_SQLite.db.
  • Only the system tables should be extracted – system tables are prefixed with sqlite_.
  • A new worksheet...