1) Create System DSN using ODBC Data Sources (64bit) Program.
– Note you’ll need to install ODBC drivers to fit your specific need. (Excel, MYSQL, etc.)

2) Using Instance Manager set…
Import Connection Type: ODBC
Server Name: “ODBCname”
User Name: “leave blank”
Password: “Leave blank”


Resulting connection string will look like:

DSN=DSNname;Integrated security=SSPI

or (if using Username and Password)