Overview

This topic provides more information about PostgreSQL, supported versions, authentication, data type support, and more.

• What is PostgreSQL?

• Supported Version and Testing Level

• Certification Level Description

• Testing Level Description

• Supported PostgreSQL Products

• Connectivity

• Authentication

• Data Type Support

• Analytical Function Support

• Write Back to Source

• Repository

• Supported Workflow

• PostgreSQL Integration with MicroStrategy

What is PostgreSQL?

PostgreSQL is a powerful, open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 30 years of active development on the core platform. See POSTGRES on the PostgreSQL site for more details.

PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open-source community behind the software to consistently deliver performant and innovative solutions.

Supported Version and Testing Level

We have certified the latest PostgreSQL major version PostgreSQL 14.x in the MicroStrategy 2021 Update 4 release. The support is downward compatible, meaning an older version of PostgreSQL is also compatible with MicroStrategy products. We certify PostgreSQL as a warehouse and repository for the metadata, history list, Collaboration server, and Platform Analytics. PostgreSQL is not currently supported for Enterprise Manager, Statistic Repository, and Narrowcast server.

The table below shows the certification level per MicroStrategy release and PostgreSQL version. One combination indicates support level and the test execution level.

MicroStrategy Version	PostgreSQL 13.x	PostgreSQL 12.x	PostgreSQL 11.x	PostgreSQL 10.x
MicroStrategy 2019 and Updates	Diamond Comprehensive Test	Diamond Connectivity Test	Diamond Connectivity Test	Diamond Connectivity Test
MicroStrategy 2020 and Updates	Diamond Comprehensive Test	Diamond Connectivity Test	Diamond Connectivity Test	Diamond Connectivity Test
MicroStrategy 2021 and updates	Diamond Comprehensive Test	Diamond Connectivity Test	Diamond Connectivity Test	Diamond Connectivity Test

Certification Level Description

• Diamond: MicroStrategy works closely with the vendors in this category to ensure that everything is fully optimized by the date of their release and recommends this configuration with the highest confidence. We run end-to-end regression testing and performance testing to ensure that our platform is optimized to work best with this configuration.

• Platinum: MicroStrategy strongly recommends this configuration. We frequently run end-to-end regression testing and performance testing to ensure that our platform is optimized to work best with this configuration.

• Gold: MicroStrategy recommends this configuration. We run end-to-end regression testing to ensure our platform works well with this configuration.

• Silver: MicroStrategy supports this configuration. Any issues encountered should be reported and resolved in a timely manner.

Testing Level Description

• Comprehensive Test: Full gateway capability test.

• Universal Benchmark Test: UB test, data fetch test, connection capability test, and authentication capability test.

• Connectivity Test: Data fetch, connection capability test, and authentication capability test.

See Platform Certifications. for the latest certified platforms.

Supported PostgreSQL Products

• PostgreSQL Database

• Azure Database for PostgreSQL

• Amazon Aurora PostgreSQL

Connectivity

• PostgreSQL ODBC and JDBC drivers are shipped with MicroStrategy releases.

• Retrieval of PostgreSQL data from RESTful api is also supported.

Both DSN and DSN-less connectivity for PostgreSQL are supported, which is our standard level of support for all databases.

Authentication

The following five modes of authentication are supported:

1. Standard authentication (login/password)

2. Kerberos authentication (We do not support Kerberos with JDBC driver)

3. Windows authentication (SSPI)

4. Certificate authentication

5. Warehouse passthrough (We only support warehouse pass-through with database authentication to run report)

Data Type Support

MicroStrategy supports 21 of PostgreSQL's 43 data types.

Analytical Function Support

• PostgreSQL supports a wide range of built-in functions which allows MicroStrategy to push down lots of analytical functions to take advantage of database capabilities, as well to distribute data computation.

• Currently 273 analytical functions are supported of which 117 are mapped to built-in PostgreSQL functions for calculation on the database. The supported push-down functions are:

  • 15 of 21 Basic functions are pushed down

  • 21 of 25 String functions are pushed down

  • 24 of 31 OLAP functions are pushed down

  • 23 of 31 Date-time functions are pushed down

  • 29 of 34 Mathematical functions are pushed down

  • 0 of 50 Financial functions are pushed down

  • 5 of 51 Statistical functions are pushed down

  • 0 of 30 Predictive functions are pushed down

Write Back to Source

MicroStrategy supports Transaction services with PostgreSQL ODBC and JDBC driver. With MicroStrategy Transactions services support for PostgreSQL, users can record selections in a PostgreSQL table.

Repository

PostgreSQL can be used as a repository for the metadata, history list, Platform Analytics, Collaboration server. Enterprise Manager, Statistic Repository and Narrowcast server are not supported with PostgreSQL.

Supported Workflow

Basic Workflow	In-Memory Support	Direct Data Access Support
Modelled Schema Workflow from Developer	Yes	Yes
Self Service Dossier workflow from Web	Yes	Yes
Self Service Dossier workflow from Workstation	Yes	Yes
Self Service Data Wrangling Workflow from Web	Yes	N/A
Self Service Data Wrangling Workflow from Workstation	Yes	N/A

PostgreSQL Integration with MicroStrategy