![microstrategy desktop odbc driver for sql server microstrategy desktop odbc driver for sql server](http://www.cdata.com/ui/img/logo-mongodb.png)
In the datasets panel, click New Data, select Databases, and select Type a Query as the Import Option. Open MicroStrategy Desktop and create a new dossier.
![microstrategy desktop odbc driver for sql server microstrategy desktop odbc driver for sql server](https://www.cdata.com/drivers/_img/_technologies/ado-exmt-qb-3.png)
Restart any I-Server that was running before the DSN was created. Follow the steps below to add SQL Analysis Services data as a dataset and create visualizations and reports of SQL Analysis Services data. Test the connection from the MicroStrategy ODBC Test tool (found in the bin directory of the MicroStrategy install).ĥ. SQL Server exec storedprocedurename with SQL Server ODBC driver The stored procedure returns the data to the client. This file is in the same directory as the odbc.ini file.Ĥ. Unicode, 32-bit and 64-bit support: Support 32-bit and 64-bit applications and unicode ODBC APIs.M. Update the odbcinst.ini to include the proper path to the Netezza driver. Developers can use SQL Analysis Services ODBC Driver to rapidly build Web, Desktop, and Mobile applications that interact with live SQL Analysis Services data Standards-Compliant ODBC: ODBC 3.8 compliant native protocol based drivers. The DSN needs to be updated to include the path to the Netezza driver, the proper IP address, and the database name.ģ.
#MICROSTRATEGY DESKTOP ODBC DRIVER FOR SQL SERVER DRIVERS#
CData Drivers Real-time data connectors with any SaaS, NoSQL, or Big. Platform Solutions Connectors Support Resources Company Search Chat. Connect to PostgreSQL data in MicroStrategy Desktop using the. Update the odbc.ini file in the MicroStrategy installation directory to include the sample DSN found in the . Connect to PostgreSQL data in MicroStrategy Desktop using the CData ODBC Driver for PostgreSQL. Verify that the correct ODBC driver is installed ()Ģ. The typical steps to connect to Netezza from Linux are:ġ. NZSQL = Microstrategy ODBC Driver for Netezza Wire ProtocolĪfter saving your changes to the odbc.ini file, you should be able to choose the NZSQL DSN name from the drop down menus in the Microstrategy interface. The following is an example of the odbc.ini file contents.ĭriver = /usr/local/nz/lib/libnzsqlodbc3.so For the MSTR configuration wizard to recognize the DSN entry for Netezza, you must add a line to the odbc.ini file that is located in /var/opt/Microstrategy.