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:


www.connectionstrings.com


Of course you can use variables in any connection string like for example:


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


or


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


2007 Office System Driver: Data Connectivity Components


SQLite ODBC Driver


MySQL Download Connector/ODBC


MySQL Download Connector/ODBC  - previous versions