Through the "Open SQL Connection" Action, the user can define the connection string to connect ProcessRobot/WinAutomation to any kind of database.
Connection strings for any kind of Database can be found in the link below:
Of course you can use variables in any connection string like for example:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%ExcelFile%;Extended Properties="Excel 12.0 Xml;HDR=YES";
Most common Drivers List:
Download and install the appropriate drivers from the list below according to the database that you want to connect to:
Text File Driver - Schema.ini File (This is very useful when wanting to make an sql query to a text file, csv etc)