MicroStrategy ONE

Create an ODBC Connection for Denodo

  • 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 for and choose Denodo from the data source list.

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

  6. Type a Name for the new database connection.

  7. In the Driver drop-down list, choose the Denodo ODBC driver.

  8. Click the Basic tab.

  9. Type a Server Name, Port Number, and Database.

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

  11. Type a Name, Username, and Password for the new database login.

  12. Click Save.

  13. Click Save.

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

  15. Click Save.

Import Data Using Your Denodo 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 Denodo 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 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 for and choose Denodo from the data source list.

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

  8. In the Driver drop-down list, choose the Denodo ODBC driver.

  9. Click the Basic tab.

  10. Type a Server Name, Port Number, and Database.

  11. In Authentication Mode, choose Standard.

  12. Click Add New Database Login and type your Username and Password.

  13. Click Save.

  14. Type a Name for the new database connection.

  15. Click Save.

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

  17. 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.

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

  19. Create your dashboard using your imported data.