![microstrategy odbc driver for sql server microstrategy odbc driver for sql server](https://static.packt-cdn.com/products/9781789136241/graphics/5404e167-f69f-4923-b5eb-ad6e83a33135.png)
#MICROSTRATEGY ODBC DRIVER FOR SQL SERVER INSTALL#
* Before you begin, you will need install the JDBC Driver for SQL Server on the machine hosting the MicroStrategy Intelligence Server that your instance of MicroStrategy Web is connected to. You can connect to SQL Server in MicroStrategy Web by adding a data source based on the CData JDBC Driver for SQL Server. With built-in dynamic metadata querying, you can visualize and analyze SQL Server data using native MicroStrategy data types.Ĭonnect to and Visualize SQL Server Data using MicroStrategy Web When you issue complex SQL queries from MicroStrategy to SQL Server, the driver pushes supported SQL operations, like filters and aggregations, directly to SQL Server and utilizes the embedded SQL engine to process unsupported operations (often SQL functions and JOIN operations) client-side. The CData JDBC driver offers unmatched performance for interacting with live SQL Server data in MicroStrategy due to optimized data processing built into the driver. In this article, we walk through adding SQL Server as an external data source in MicroStrategy Web and creating a simple visualization of SQL Server data. When you pair MicroStrategy with the CData JDBC Driver for SQL Server, you gain database-like access to live SQL Server data from MicroStrategy, expanding your reporting and analytics capabilities.
![microstrategy odbc driver for sql server microstrategy odbc driver for sql server](https://www.cdata.com/kb/articles/odbc-microstrategy-10.png)
MicroStrategy is an analytics and mobility platform that enables data-driven innovation.