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 the proper ODBC driver installed.


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


Microsoft Office Access Runtime and Data Connectivity 2007 Service Pack 2 (SP2)


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)


PostgreSQL ODBC Drivers