MicroStrategy ONE

Create an Amazon Redshift JDBC Connection

Starting in MicroStrategy ONE (December 2024), you can connect to Amazon Redshift using a JDBC connection.

  • Workstation
  • Library

Create a Data Source Using Standard Authentication

  1. Open the Workstation window.

  2. Connect to an environment.

  3. In the Navigation pane, click ,next to Data Sources.

  4. Search and choose Amazon Redshift from the data source list.

  5. In the Default Database Connection drop-down list , click Add New Database Connection.

  6. Type a Name.

  7. In the Driver drop-down list, choose the Progress JDBC Driver (com.microstrategy.jdbc.redshift.RedshiftDriver) or Native JDBC Driver (com.amazon.redshift.Driver).

  8. Type a Server Name, Port Number, and Database. These values can be found in the Redshift Endpoint, it is under the following format: <Server Name>:<Port>/<Database>.

  9. In the Authentication Mode drop-down list in the Basic tab, choose Standard.

  10. In the Default Database Login drop-down list, click Add New Database Login.

  11. Type a Name, Username, and Password.

  12. Click Save.

  13. In the Security tab, choose a verification method based on your database from the Verification Method drop-down list.

  14. Click Save.

  15. In the Add Data Source dialog, enter a Name, Database Version, and optionally choose Projects for further data manipulation.

  16. Click Save.

Create a Data Source Using OAuth Authentication

Starting in MicroStrategy ONE (September 2024), MicroStrategy supports connecting to Redshift using the Redshift Native JDBC (com.amazon.redshift.Driver) driver with OAuth authentication via Microsoft Entra ID as the IDP.

  1. Open the Workstation window.

  2. Connect to an environment.

  3. In the Navigation pane, click , next to Data Sources.

  4. Search and choose Amazon Redshift from the data source list.

  5. In the Default Database Login drop-down list, click Add New Database Connection.

  6. Type a Name

  7. In the Driver drop-down list, choose the Redshift native JDBC driver (com.amazon.redshift.Driver).

  8. Type a Server Name and Database.

  9. In the Authentication Mode drop-down list, choose OAuth.

  10. In the Authentication Service drop-down list, choose an authentication service or click Add New Authentication Service.

    For more information, see Manage OAuth Enterprise Security with Identity and Access Management (IAM) Objects.

  11. In Scope, type your scope value.

    For more information, see Configure OAuth Parameters for a Data Source.

  12. In the Security tab, choose a verification method based on your database from the Verification Method drop-down list.

  13. Click Save.

  14. In the Add Data Source dialog, enter a Name, Database Version, and optionally choose Projects for further data manipulation.

  15. Click Save.

Import Data Using Your Amazon Redshift Data Source

  1. Open the Workstation window.

  2. Connect to an environment.

  3. In the Navigation pane, click ,next to Datasets.

  4. Choose a Project and select Data Import Cube.

  5. Click OK.

  6. In Data Catalog, click the Redshift data source you created, choose a namespace, and click Connect.

  7. Double-click a table to add it to the right pane.

    You can also hover over the Denodo Database Source and click Build a Query or Add free-form SQL.

  8. Click Preview Data to modify your data or click Save.

  1. In Library, choose Create New > Dashboard.

  2. Choose a project from the Create Dashboard in drop-down list.

  3. Click Blank Dashboard.

  4. In the Datasets panel, click New Data.

  5. Click , next to Data Catalog.

  6. Search and choose Amazon Redshift from the data source list.

  7. In Default Database Connection, click Add New Database Connection.

  8. In the Driver drop-down list, choose a Redshift JDBC driver. Starting in MicroStrategy ONE (September 2024), you can choose Progress JDBC (com.microstrategy.jdbc.redshift.RedshiftDriver) or Native JDBC Driver (com.amazon.redshift.Driver).

  9. In the Basic tab, type a Server Name, Port Number, and Database. These values can be found in the Redshift Endpoint, it is under the following format: <Server Name>:<Port>/<Database>.

  10. In Authentication Mode, choose an option from the drop-down list:

    • If you choose Standard, click Add New Database Login and type your Username and Password.

    • Starting in MicroStrategy ONE (September 2024), you can use OAuth authentication via Microsoft Entra ID as the IDP. If you choose OAuth, choose an option in the Authentication Service drop-down list and type a Scope.

      For more information, see Manage OAuth Enterprise Security with Identity and Access Management (IAM) Objects.

  11. In the Security tab, choose an option in the Verification Method drop-down list based on your database settings.

  12. Click Save.

  13. Type a Name.

  14. Click Save.

  15. In Data Catalog, click the Redshift data source you created, choose a namespace, and click Connect.

  16. Double-click a table to add it to the right pane.

    You can also hover over the Redshift Database Source and click Build a Query or Add free-form SQL.

  17. Click Prepare Data to modify your data or click Save.

  18. Create your dashboard using your imported data.