EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics
  3. KB439832: Functional and driver updates in MicroStrategy Secure Enterprise

KB439832: Functional and driver updates in MicroStrategy Secure Enterprise


Community Admin

• Strategy


MicroStrategy 10.4 Hotfix 5 provides feature parity with the latest MicroStrategy feature release 10.9.

MicroStrategy 10.4 Hotfix 5 provides parity with MicroStrategy feature release 10.9. for some features

The information below provides a summary table of the functional and driver updates, the steps required to enable them, and a table with the full list of Gateway changes.
The following functional and driver updates on Windows and Linux

Gateway

Driver

Connector

Links to more information

Amazon Athena

N/A

Introduces support for Athena

Enable importing prefix with tables
Follow these steps when retrieving large data volumes

Amazon Aurora

N/A

Introduces support for Aurora

Create or modify connections to Aurora in Developer

Apache Hive

Updated

Adds support for Hive 2

 

Apache Spark SQL

Updated

Adds support for Spark SQL 2

Enable importing prefix with tables

Cassandra

ODBC driver added

Introduces support for Cassandra 3

 

Google BigQuery

updated

Updates the connector

On Linux, post-install steps are required to enable driver
Enable importing prefix with tables

IBM DB2

updated

Adds support for DB2 11

 

MapR Drill

updated

Adds support for Drill 1.10

In Web, modify the query syntax when using "Build a Query"

MariaDB

N/A

Adds support for MariaDB 10

Create or modify connections to MariaDB in Developer

Microsoft SQL Server

updated

Adds support for SQL Server 2016

 

Microsoft Azure SQL Database

updated

Updates connector

 

MongoDB

ODBC driver added

Updates the connector to support MongoDB 3

 

Oracle Database

updated

Adds support for Oracle 12 R2

 

Presto

updated

Updates existing connector for Presto

Follow these steps when retrieving large data volumes

SAP HANA

N/A

Adds support for SAP HANA 2

Data Import only supports Information Views

Teradata

N/A

Adds support for Teradata 16

 

 

To enable functionality for one or more of these updates

  1. Install MicroStrategy 10.4 (Hotfix 5). This will install all new and updated driver versions in the existing MicroStrategy 10.4 environment, with the following results:

     

    - Existing DSNs and connections are tested and expected to work.Existing connectors have not yet been updated.

    - Existing applications are expected to continue working in the same way as before the upgrade, no SQL changes are expected.

    - This allows for a risk free upgrade to Hotfix 5.New connectors have not yet been added and will not appear in Developer.

  2. To take advantage of changes to existing connectors or to enable new connectors, load the connectors in the MicroStrategy metadata. Multiple connectors can be added or updated in bulk.

     

    See KB43537 for detailed steps explaining how to load the database object in the database.pds file into MicroStrategy metadata.


Example: How to add the DB object for Teradata 16
 

  1. Install MicroStrategy 10.4 Hotfix 5. Launch the “Database Instance” GUI, and Click upgrade as below:
rtaImage.png

When the “Upgrade Database Type” window appears, click load, then locate “Teradata 16.0”, and click add to the right.

rtaImage (1).png

3.Click Ok to save.
        4.Click Ok on the Database instance window too. Reopen the Database instance GUI, the Teradata 16.0 is available from the drop-down window.

rtaImage (2).png
Article Reference Number: KB439832


 

KB439832

Comment

0 comments

Details

Knowledge Article

Published:

January 31, 2024

Last Updated:

January 21, 2026