Yes. You can define a data source and select from the drop-down providers, including ODBC, and connect directly.
If you are using linked servers just create a datasource to your database and write the query in the query box using the qualified name, OPENQUERY etc.