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

MongoDB - U102


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This page details the use of MongoDB in conjunction with MicroStrategy Secure Enterprise.

Strategy is an enterprise grade Business Intelligence platform that provides drivers for all supported RDBMS platforms to generate optimized SQL that takes advantage of database specific functionality.  Strategy applications can achieve industry-leading data scale due to its reliance on the processing power and data management capabilities of the underlying database.  Strategy can push down the analytics to the database in the form of optimized SQL queries and visualize the data of the result sets per the report and dashboard specification.  Query performance in many data warehouses is enhanced using aggregate tables.  Strategy’s SQL Engine is aggregate-aware and determines the use of aggregate tables transparently at query time.

ka02R000000kcTIQAY_0EM440000002Jgk.png

When used together, Strategy and MongoDB enable organizations to connect to a schema-less database that can handle large volumes of structured, semi-
structured, and unstructured data. Organizations can then leverage this data to build powerful enterprise reports and business applications.
Driver Support
 

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:


 

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:

 Certified
Strategy PRODUCTDATA SOURCEDRIVEROPERATING SYSTEMDesktopMongoDB 3.xStrategy JDBC Driver for MongoDBMacStrategy ODBC Driver for MongoDBWindows 64-bitServerMongoDB| 3.xStrategy ODBC Driver for MongoDBWindows 64-bitLinuxSUPPORTED PUSH-DOWN FUNCTIONSSUPPORTED DATA TYPE Strategy can push down 65 analytical
functions to the database to deliver faster query performance by leveraging the power of the data source. Strategy supports 14 MongoDB datatypes, allowing dashboard designers to bring in the critical information they need
for analysis.The following functions can be pushed
down to the database level:


The Strategy connector supports the
following data types for Mongo DB:



Comment

0 comments

Details

Knowledge Article

Published:

April 18, 2017

Last Updated:

April 18, 2017