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

SQL Generation Homepage


Stefan Zepeda

Salesforce Solutions Architect • Strategy


MicroStrategy SQL Engine is the main feature in MicroStrategy for retrieving the data for display and analysis by users.

Strategy SQL Engine is the backbone of the entire Strategy product. It takes end user designs and needs and creates the necessary queries to fetch the desired data from the database. It picks the most optimal manner to retrieve the data to reduce the time needed to provide a good end user experience.

ka02R000000kcdkQAA_0EM440000002Ikc.jpeg

The Strategy SQL Engine can write queries based on either a mapped data model created in Architect or the schema object editors or it can generate queries off of the user design made within Data Import for building queries or picking tables. This can be done against the multitude of databases Strategy supports or through writing standard ANSI SQL against other databases.


Comment

0 comments

Details

Knowledge Article

Published:

April 7, 2017

Last Updated:

April 7, 2017