![Okidata 320 driver compatibility windows 10](https://knopkazmeya.com/14.png)
![microstrategy desktop odbc driver for sql server microstrategy desktop odbc driver for sql server](https://www.elastic.co/guide/en/elasticsearch/reference/6.8/images/sql/odbc/apps_ps_exed.png)
Add the JDBC keyword to the connection string.On the Advanced tab for the connection wizard, set the additional connection string parameters as follows.In the database connection wizard, name the connection and create a new Database Login name, setting the user and password for SQL Server.Name the instance, select Generic DBMS as the database connection type, and create a new database connection.Navigate to Administration -> Configuration Managers -> Database Instances and right-click to add a new instance.Open MicroStrategy Developer and select a Project Source.
Microstrategy desktop odbc driver for sql server install#
* Before you begin, you will need to install the JDBC Driver for SQL Server on the machine hosting the MicroStrategy Intelligence Server that your instance of MicroStrategy Developer is connected to. You can connect to SQL Server in MicroStrategy Developer by adding a database instance 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 SQL Server in MicroStrategy Developer 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 creating a database instance for SQL Server in MicroStrategy Developer and create a Warehouse Catalog for the 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 is an analytics and mobility platform that enables data-driven innovation.
![Okidata 320 driver compatibility windows 10](https://knopkazmeya.com/14.png)