Data Validation Process
This bot determines whether the data is present on the ERP database and validates it
Top Benefits
- Data Validation
- Connected to ERP database and fetch in Excel
Tasks
- Read and validate Excel files to get AP record details
- Database connection establishment to Microsoft SQL server
- Data validation
- Run macro
- Delete Cells, Find, Get Multiple Cells, Get Single Cells
This bot inputs data validation records and fetches the data from the ERP database. It then determines whether the data is present on the ERP database or not, with presence being marked by a green dot, and no presence being marked by a red dot.
Free
- Bot Security Program
-
Level 1
- Applications
-
- Business Process
- Finance & AccountingHuman ResourcesOperations
- Category
- RPA Developer Tools
- Downloads
- 288
- Vendor
- Automation Type
- Bot
- Last Updated
- November 16, 2022
- First Published
- November 16, 2022
- Platform
- Automation 360
- ReadMe
- ReadMe
- Support
-
- Community Support Only
- Pathfinder Community Developer Forum
- Bot Store FAQs
See the Bot in Action
Setup Process
Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Configure
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
Run
That's it - now the Bot is ready to get going!
Requirements and Inputs
- vserver_name: Provided server name for connect to the ERP
- vuser_name: To connect the ERP database
- vpassword: To connect the ERP database
- vdriver_path: To connect the driver file
- Input_file: To validate the Input Data