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:

Server=%ServerAddress%;Database=%myDataBase%;User Id=%Username%;Password=%Password%;


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:

Microsoft Access Database Engine 2010 Redistributable

Microsoft Access Database Engine 2016 Redistributable

Microsoft Office Access Runtime and Data Connectivity 2007 Service Pack 3 (SP3)

SQLite ODBC Driver

MySQL Download Connector/ODBC

MySQL Download Connector/ODBC  - previous versions 

Text File Driver - Schema.ini File (This is very useful when wanting to make an sql query to a text file, csv etc)