•In the Configuration tab, enter an SQL query in the SQL QUERY field. This is the query that will be executed on the target data source.

•In the Connection tab, enter the full connection string to the data source using the ODBC driver into the CONNECTION STRING field.

oExample string for the connection to an SQL Server instance:
Driver={SQL Server};Server=myServerAddress;
Database=myDataBase;Uid=myUsername;Pwd=myPassword;

oExample string when using a trusted connection:
Driver={SQL Server};Server=myServerAddress;
Database=myDataBase;Trusted_Connection=Yes;

oExample when using an Excel file (EXCEL 97-2013)
Driver={Microsoft Excel Driver
(*.xls, *.xlsx, *xlsm, *.xlsb)};
DBQ=C:\MyExcel.xlsx;