I am faily new to UiPath and building a more complex flow. I effectively need an unattended robot to
Access VDI via VMWare Horizon
Open a 3rd party app to run a report
Export the report to a csv
Move the csv out of the VDI and onto the Robot Machine
For each row in the csv, insert into an SQL database
My plan was to use the REFramework with steps 1 - 4 being linear to be placed inside the Initialization phase - uploading the csv to a Queue
Step 5 - Will download the data from the Queue and insert into SQL
If you’re fairly new I recommend not using REFramework. IMO it’s bloated, overcomplicated, and confusing. In order to learn, you should write your project from scratch. That way you know everything that’s in it, what it does, and why.
if you are planning to run everything in a single machine, then it is correct
if you are planning to run it in separate machines to make the processing quicker, you need to separate it into two different processes
a. Process 1 (Dispatcher) - this will run steps 1 to 4, after which each row of the CSV is uploaded as a queue item
b. Process 2 (Performer) - this REFramework will run step 5, it will take process the queue items until there are no more queue items to process
The dispatcher bot should only be deployed to one machine
The performer bot can be deployed to multiple machines to process the queue items in parallel and can run multiple times.