Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Robotic Process Automation with Automation Anywhere
  • Toc
  • feedback
Robotic Process Automation with Automation Anywhere

Robotic Process Automation with Automation Anywhere

By : Mahey
4.5 (2)
close
Robotic Process Automation with Automation Anywhere

Robotic Process Automation with Automation Anywhere

4.5 (2)
By: 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)
close

Updating databases

You have done a great job so far, but now we will actually start editing the data in our databases. You will learn how to execute the following types of SQL statements:

  • Insert
  • Update
  • Delete

When working with databases, understanding how to update specific records, delete specific records, and append new records is essential. For the walk-throughs, we will continue working with the sample Access database. Instead of creating a connection for each statement type, it makes sense to just connect once for all of them as we're using the same database. We will begin by building the initial skeleton using the Step action.

Let's start this walk-through by performing the following steps:

  1. Add a Step just below line 20, set the Title property as Updating to Databases, and then click on Save.
  2. Again, we will add our connection to the Access database, dragging the Database: Connect action just below line 21, ensuring it is within...

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
bookmark search playlist download 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