Support Portal

for ProcessRobot and WinAutomation


Connection Strings and Drivers
Through the "Open SQL Connection" Action, the user can define the connection string to connect to any kind of SQL database, as long as there is th...
Tue, 20 Aug, 2019 at 3:04 PM
Execute SQL queries to Microsoft Access
Access files consist of tables. We can execute SQL queries to those tables, using the "Database" Actions. Requirements Verify that any one of...
Fri, 27 Sep, 2019 at 12:56 PM
Tips on SQL queries and Connection Strings
In case your Connection String or SQL Query does not work as expected, have in mind the below: 1. Replace any single quote (') characters with doub...
Wed, 21 Aug, 2019 at 3:26 PM
Stored procedures and functions in SQL Actions
Using the "Database" group of Actions one can connect to any database and execute SQL statements. Although most SQL queries can be executed, q...
Fri, 10 May, 2019 at 7:29 PM
How to connect to a MongoDB Database
First we need to install the appropriate drivers found here. Then we need to install MongoDB Connector for BI found here. The executable for the con...
Fri, 17 May, 2019 at 4:48 PM
Execute query to SQL database with Windows vs SQL Server authentication
Setup  Robot_1 is installed on the same machine as the SQL Server. Robot_2 is installed on a separate machine. Scenario A Process that runs throug...
Fri, 6 Dec, 2019 at 6:45 PM