Database: The name of the SQL Server database.Ĭonnecting to Azure SQL Server and Azure Data Warehouse.
MICROSTRATEGY ODBC DRIVER FOR SQL SERVER PASSWORD
Password: The password associated with the authenticating user.
User: The username provided for authentication with SQL Server.
Server: The name of the server running SQL Server.
Connecting to Microsoft SQL ServerĬonnect to Microsoft SQL Server using the following properties: Information for connecting to SQL Server follows, along with different instructions for configuring a DSN in Windows and Linux environments (the ODBC Driver for SQL Server must be installed on the machine hosting the connected MicroStrategy Intelligence Server). With built-in dynamic metadata querying, you can visualize and analyze SQL Server data using native MicroStrategy data types.Ĭonnect to SQL Server as an ODBC Data Source 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 ODBC 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 creating a database instance for SQL Server in MicroStrategy Developer and creating a Warehouse Catalog based on SQL Server data. When you pair MicroStrategy with the CData ODBC Driver for SQL Server, you gain database-like access to live SQL Server data from MicroStrategy, expanding your reporting and analytics capabilities. MicroStrategy is an analytics and mobility platform that enables data-driven innovation.