Create a JDBC Connection for Denodo

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 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 database connection.

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

   

8. Click the Basic tab. .

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

10. In the Authentication Mode drop-down list, choose Standard.

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

    For more information, see Manage OAuth Enterprise Security with Identity and Access Management (IAM) Objects and Configure OAuth Parameters Using Microsoft Entra ID for Denodo.

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

    

13. Click Save.

14. Click the Security tab.

15. Choose a verification method based on your database from the Verification Method drop-down list.

    

16. Click Save.

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

    

18. Click Save.

Create a Data Source Using OAuth Authentication

Starting in MicroStrategy ONE (December 2024), MicroStrategy supports connecting to Denodo using the JDBC (com.denodo.vdb.jdbcdriver.VDBJDBCDriver) driver with OAuth authentication via Microsoft Entra ID or Okta 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 for and choose Denodo from the data source list.

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

   

6. Type a Namefor the new database connection.

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

   

8. Click the Basic tab.

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

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

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

12. If you click Add New Authentication Service, Type a Display Name and enter your Client ID, Directory (tenant) ID, and Scope.

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

13. Click the Security tab.

14. Choose a verification method based on your database from the Verification Method drop-down list.

    

15. Click Save.

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

17. 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 Preview Data to modify your data or click Save.