<div>
Thanx!!! The details given really helped identify the actual &quot;How-To&quot; process!! We are up and running!!!
</div>


<div>
<div class="content wysiwyg-content">
Is there a way to setup our MS Sql management Studio (2005 or 2014) to connect to a non-mssql database (or external data source) using an OBDC connector? &nbsp;We have an ODBC driver for a database that is not a Microsoft SQL database njor a Microsoft product. &nbsp;The ODBC driver has it's own &quot;query&quot; section that we can query the non-sql databases but we wanted to see if we can use MSSQL Studio to run our queries.<br />
<br />
Can we setup our MS Sql Studio to connect to a database via ODBC? is this possible? How can we go about it?
</div>
</div>


Is there a way to setup our MS Sql management Studio (2005 or 2014) to connect to a non-mssql database (or external data source) using an OBDC connector?  We have an ODBC driver for a database that is not a Microsoft SQL database njor a Microsoft product.  The ODBC driver has it's own "query" section that we can query the non-sql databases but we wanted to see if we can use MSSQL Studio to run our queries.

Can we setup our MS Sql Studio to connect to a database via ODBC? is this possible? How can we go about it?

Use MS Sql Management Studio to read non-sql database thru ODBC

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.