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

Secure Cloud Homepage


Stefan Zepeda

Salesforce Solutions Architect • Strategy


High level overview of our MicroStrategy Cloud offering consisting of our world class MicroStrategy product suite, Amazon Web Services (AWS) infrastructure, Cloud Support, security certifications, monitoring, elasticity and our global solution expertise.

Strategy Cloud
The Strategy Cloud offering (“Strategy Cloud”) is a service for customers of all sizes using a hybrid Platform-as-a-Service (PaaS) delivery model. The PaaS model is designed to deliver the Strategy Platform for building and serving Analytics, Mobility, and Security applications thatis pre-configured by Strategy, coupled with the supporting infrastructure, to enable customers to rapidly enjoy the value and benefits of the Strategy Platform without having to deploy and manage the underlying IT infrastructure.
The Strategy Cloud offers compute power, database storage, content delivery and other functionality to allow our customers to build applications with increased flexibility, scalability and reliability.  The core of the Strategy Cloud offering is the Strategy Analytics, Mobility, and Security components that provide customers with a secure, scalable, and resilient Business Intelligence application platform. It also includes the necessary Cloud Infrastructure components (listed below) needed to operate, access, and manage the environment. Customers are provisioned with their own dedicated cloud environment based on a predefined configuration. Once a customer takes ownership of the environment, they can develop, tailor and manage the application components to meet their respective company needs. Based on this operating model, customers control the Analytics, Mobility, and Security application stack; Strategy maintains control over the supporting physical and virtual infrastructure.
 

ka04W000000XQ0qQAG_0EM440000002L60.jpeg

Cloud customers are provisioned and assigned their own Strategy Cloud instance, where their respective servers reside logically segmented from all other Strategy Cloud instances. Strong network access controls have been implemented through Software Defined Networking (SDN) and isolated customer networks, and Strategy Cloud management networks. Customers are permitted to access their assigned analytics application resources; all other network traffic is denied.
Infrastructure deployment automation tools are used to build and deploy servers within the Strategy Cloud. All virtual machines built are based on standardized templates and are assigned computing resources (RAM, disk space, and CPU) from the storage and compute resources. Virtual server Operating Systems are deployed using standardized secured baseline configurations and managed centrally through configuration management software. All servers in the Strategy Cloud have host-based firewalls and anti-malware software installed, with all configurations and policies centrally controlled. All components of the Strategy Cloud are monitored 24 hours a day, 365 days a year through a suite of system availability and health monitoring software tools configured to notify our staff in the event of a problem.
 

ka04W000000XQ0qQAG_0EM440000002L65.png

Strategy Cloud Security & Compliance
The Strategy Cloud Compliance Program enables customers to understand the robust controls in place to maintain security, compliance, and data protection. As applications are built on the Strategy Cloud Platform, compliance responsibilities are shared. By providing a governed platform as a service, we enable customers to establish and operate in a security control environment. The Strategy Cloud controls are based on the Service Organizational Controls (SOC) 2 security and availability Trust Criteria.
As such, Strategy is able to map its controls to the most common industry control frameworks, including PCI, HIPAA and Safe Harbor. Currently, Strategy Cloud is compliant with HIPAA requirements and is certified compliant with PCI DSS 3.1, Safe Harbor, and SOC2 Type II controls and requirements. Amazon Web services maintain SOC1, SOC2 Type II, and PCI certifications up to the hypervisor level, and Strategy is responsible for the operating system level and above.
 

Strategy Platform (Early Adopter)
Database ObjectType of Permissions RequiredTablesSelect, Insert, Update, Create, Drop, DeleteIndexesCreate, DropTriggersCreate, DropFunctionsCreate, ExecutePackagesCreateProceduresCreate, Execute Standard Verification (default - explicit)Standard Verification (default - implicit)JDBCjdbc:exa:exadb1.example.com:8563; validateservercertificate=1jdbc:exa:exadb1.example.com:8563
 ODBCEXAHOST=exadb1.example.com
SSLCertificate=SSL_VERIFY_SERVER
 EXAHOST=exadb1.example.com
  Connection string examples 1Connection string examples 2JDBCjdbc:exa:exadb1.example.com/<fingerprint>:8563 jdbc:exa:exadb1.example.com:8563; fingerprint=<fingerprint>;ODBCEXAHOST=exadb1.example.com/<fingerprint>:8563 EXAHOST=exadb1.example.com:8563;fingerprint=<fingerprint>; Connection string examples 1JDBCjdbc:exa:exadb1.example.com:8563;validateservercertificate=0 ODBCSSLCertificate=SSL_VERIFY_NONE JDBCjdbc:exa:exadb1.example.com:8563;legacyencryption=1ODBCUseLegacyEncryption=Y Connection string examples 1JDBCjdbc:exa:exadb1.example.com:8563;encryption =0 ODBCencryption=N LanguageDateNumberCurrencyPercentageGermandd.mm.yyyy12.345,00123.456,7812,34%Spanishdd/mm/yyyy12.345,00123.456,7812,34%English (US)mm/dd/yyyy12,345.00123,456.7812.34%English (UK)dd/mm/yyyy12,345.00123,456.7812.34%Frenchdd/mm/yyyy12 345,00123 456,7812,34%Italiandd/mm/yyyy12.345,00123.456,7812,34%Japaneseyyyy/mm/dd12,345.00123,456.7812.34%Koreanyyyy-mm-dd12,345.00123,456.7812.34%Portuguese (Brazil)dd/mm/yyyy12.345,00123.456,7812,34%Swedishyyyy-mm-dd12 345,00123 456,7812,34%COLUMNPURPOSEDATATYPEMR_SUB_IDSubscription Portal generated Subscription IDNumeric/Int (Must be unique)MR_ADDRESS_IDID of the addressText/VarCharMR_USER_IDNarrowcast User IDText/VarCharMR_SUB_SET_IDSubscription Set IDText/VarCharValueEffect1Unicode (UTF-8) support is enabled.0No Unicode support.

Best Practices



Authentication ⟩



Authorization ⟩



Encryption ⟩



Web Security ⟩

[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1
 

Strategy Platform (Early Adopter)
Database ObjectType of Permissions RequiredTablesSelect, Insert, Update, Create, Drop, DeleteIndexesCreate, DropTriggersCreate, DropFunctionsCreate, ExecutePackagesCreateProceduresCreate, Execute Standard Verification (default - explicit)Standard Verification (default - implicit)JDBCjdbc:exa:exadb1.example.com:8563; validateservercertificate=1jdbc:exa:exadb1.example.com:8563
 ODBCEXAHOST=exadb1.example.com
SSLCertificate=SSL_VERIFY_SERVER
 EXAHOST=exadb1.example.com
  Connection string examples 1Connection string examples 2JDBCjdbc:exa:exadb1.example.com/<fingerprint>:8563 jdbc:exa:exadb1.example.com:8563; fingerprint=<fingerprint>;ODBCEXAHOST=exadb1.example.com/<fingerprint>:8563 EXAHOST=exadb1.example.com:8563;fingerprint=<fingerprint>; Connection string examples 1JDBCjdbc:exa:exadb1.example.com:8563;validateservercertificate=0 ODBCSSLCertificate=SSL_VERIFY_NONE JDBCjdbc:exa:exadb1.example.com:8563;legacyencryption=1ODBCUseLegacyEncryption=Y Connection string examples 1JDBCjdbc:exa:exadb1.example.com:8563;encryption =0 ODBCencryption=N LanguageDateNumberCurrencyPercentageGermandd.mm.yyyy12.345,00123.456,7812,34%Spanishdd/mm/yyyy12.345,00123.456,7812,34%English (US)mm/dd/yyyy12,345.00123,456.7812.34%English (UK)dd/mm/yyyy12,345.00123,456.7812.34%Frenchdd/mm/yyyy12 345,00123 456,7812,34%Italiandd/mm/yyyy12.345,00123.456,7812,34%Japaneseyyyy/mm/dd12,345.00123,456.7812.34%Koreanyyyy-mm-dd12,345.00123,456.7812.34%Portuguese (Brazil)dd/mm/yyyy12.345,00123.456,7812,34%Swedishyyyy-mm-dd12 345,00123 456,7812,34%COLUMNPURPOSEDATATYPEMR_SUB_IDSubscription Portal generated Subscription IDNumeric/Int (Must be unique)MR_ADDRESS_IDID of the addressText/VarCharMR_USER_IDNarrowcast User IDText/VarCharMR_SUB_SET_IDSubscription Set IDText/VarCharValueEffect1Unicode (UTF-8) support is enabled.0No Unicode support.

Best Practices



Authentication ⟩



Authorization ⟩



Encryption ⟩



Web Security ⟩

[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1
 

Strategy Platform (Early Adopter)
Database ObjectType of Permissions RequiredTablesSelect, Insert, Update, Create, Drop, DeleteIndexesCreate, DropTriggersCreate, DropFunctionsCreate, ExecutePackagesCreateProceduresCreate, Execute Standard Verification (default - explicit)Standard Verification (default - implicit)JDBCjdbc:exa:exadb1.example.com:8563; validateservercertificate=1jdbc:exa:exadb1.example.com:8563
 ODBCEXAHOST=exadb1.example.com
SSLCertificate=SSL_VERIFY_SERVER
 EXAHOST=exadb1.example.com
  Connection string examples 1Connection string examples 2JDBCjdbc:exa:exadb1.example.com/<fingerprint>:8563 jdbc:exa:exadb1.example.com:8563; fingerprint=<fingerprint>;ODBCEXAHOST=exadb1.example.com/<fingerprint>:8563 EXAHOST=exadb1.example.com:8563;fingerprint=<fingerprint>; Connection string examples 1JDBCjdbc:exa:exadb1.example.com:8563;validateservercertificate=0 ODBCSSLCertificate=SSL_VERIFY_NONE JDBCjdbc:exa:exadb1.example.com:8563;legacyencryption=1ODBCUseLegacyEncryption=Y Connection string examples 1JDBCjdbc:exa:exadb1.example.com:8563;encryption =0 ODBCencryption=N LanguageDateNumberCurrencyPercentageGermandd.mm.yyyy12.345,00123.456,7812,34%Spanishdd/mm/yyyy12.345,00123.456,7812,34%English (US)mm/dd/yyyy12,345.00123,456.7812.34%English (UK)dd/mm/yyyy12,345.00123,456.7812.34%Frenchdd/mm/yyyy12 345,00123 456,7812,34%Italiandd/mm/yyyy12.345,00123.456,7812,34%Japaneseyyyy/mm/dd12,345.00123,456.7812.34%Koreanyyyy-mm-dd12,345.00123,456.7812.34%Portuguese (Brazil)dd/mm/yyyy12.345,00123.456,7812,34%Swedishyyyy-mm-dd12 345,00123 456,7812,34%COLUMNPURPOSEDATATYPEMR_SUB_IDSubscription Portal generated Subscription IDNumeric/Int (Must be unique)MR_ADDRESS_IDID of the addressText/VarCharMR_USER_IDNarrowcast User IDText/VarCharMR_SUB_SET_IDSubscription Set IDText/VarCharValueEffect1Unicode (UTF-8) support is enabled.0No Unicode support.

Best Practices



Authentication ⟩



Authorization ⟩



Encryption ⟩



Web Security ⟩

[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1
 

 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

May 5, 2017

Last Updated:

January 20, 2021