MicroStrategy ONE

Create a ODBC Connection for Amazon Redshift

  • Workstation
  • Library

Create a Data Source

  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 Redshift ODBC 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 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 and Database Version, and optionally choose Projects for further data manipulation.

  16. 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 Redshift data source and click Build a Query or Add free-form SQL.

  8. Click Prepare 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 the Redshift ODBC 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 Default Database Login, click Add New Database Login.

  11. Type a Name, Username, and Password.

  12. Click Save.

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

  14. Click Save.

  15. Type a Name.

  16. Click Save.

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

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

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

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

  20. Create your dashboard using your imported data.