![microstrategy desktop odbc driver for sql server microstrategy desktop odbc driver for sql server](https://kyligence.io/wp-content/uploads/2019/07/1-8-1-1024x581.png)
Enjoy real-time analytics, reporting and. Advanced extensible reporting skills using MS BI, SQL Server Analysis Service. Our ODBC driver can be easily used with all versions of SQL and across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX. In addition, select Edit connection string and add the parameters to enable SSL Encryption. Progress DataDirect’s ODBC Driver for OpenEdge offers a high-performing, secure and reliable connectivity solution for ODBC applications to access OpenEdge data. If you are using ODBC Administrator to create or edit your DSN to enable SSL Encryption, uncheck Validate Server Certificate.Ĭreate a DSN-less connection in MicroStrategy Web, Desktop, or WorkstationĪdd relevant information to connect to the SQL Database.
![microstrategy desktop odbc driver for sql server microstrategy desktop odbc driver for sql server](https://www.cdata.com/drivers/_img/_technologies/monitor.png)
To create the SSL enabled DSN by MicroStrategy Connectivity Wizard, click Enable Azure. Create a DSN using MicroStrategy Connectivity Wizard
Microstrategy desktop odbc driver for sql server install#
This forces your application to verify the server certificate and thus prevents your application from being vulnerable to man in the middle type attacks. The Microsoft ODBC Driver for SQL Server can be downloaded and installed using package managers for Linux and macOS using the relevant installation instructions: Install ODBC for SQL Server (Linux) Install ODBC for SQL Server (macOS) If you need to download the packages for offline installation, all versions are available via the below links. This ensures all data is encrypted "in transit" between the client and server irrespective of the setting of Encrypt or TrustServerCertificate in the connection string.Īfter, enabling SSL encryption is available for DSN and DSNLess connections as outlined below.Īs a best practice, it is recommended that in your application's connection string you specify an encrypted connection and not trust the server certificate (uncheck Validate Server Certificate). In the Import from Tables wizard, click to add a new data source. Click Add External Data, select Databases, and choose Select a Table as the Import Option. Open MicroStrategy Web and select your project.
![microstrategy desktop odbc driver for sql server microstrategy desktop odbc driver for sql server](https://www.cdata.com/jp/drivers/_img/_technologies/odbc-microstrategy-1.png)
To enable an SSL encrypted connection to Microsoft SQL Server, SSL first needs to be enabled on Microsoft SQL Server. Alternatively, you can create a new data source based on the ODBC Driver.