MicroStrategy ONE

Amazon Redshift

Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. It is designed to handle large-scale data warehousing and big data analytics, providing fast query performance and scalability. Its columnar storage enables efficient data compression and reduces I/O, accelerating queries and large datasets.

Redshift's Massively Parallel Processing (MPP) architecture distributes data across multiple nodes, each independently processes a portion of the workload. A leader node handles query coordination and optimizations, while compute nodes execute queries and manage storage.

Integrating Redshift with MicroStrategy delivers scalable, high-performance analytics. This integration is an ideal solution for enterprises that manage large datasets and require advanced business intelligence and visualizations.

Certified Driver

System Progress ODBC Driver Progress JDBC Driver Native JDBC Driver
Linux - Server

Y

 Y Y

Windows - Server

Y

Y

Y
Windows - Workstation Y Y N

Shipped Driver

System Progress ODBC Driver Progress JDBC Driver Native JDBC Driver
Linux - Server

Y

 Y Y

Windows - Server

Y

Y

Y
Windows - Workstation Y Y N

Support Authentication Method

Driver Progress ODBC Driver OAuth
Progress ODBC

Y

 N

Progress JDBC

Y

N
Native JDBC Y Y

OAuth IDP and Method

Single Sign-On OIDC (Native JDBC Driver Only) Entra ID Okta Generic
Workstation

Y

 N

N

Library

Y

N

N
Web Y N N

Feature Support

Feature TLS Connection Parameterized Query Unified Quoting
Support Status

Y

 Y

Y

See the following topics: