Denodo: Connect to Data Marketplace

Denodo Data Marketplace allows users to explore and access Denodo content without setting up any additional tools.

To access the Denodo Data Marketplace users must be approved for access to the platform as well as approved through Data Governance for the Subdomains and Data Classification levels they wish to access. Accessing Denodo requires users to be inside the Campus Network or connected to the UW GlobalProtect VPN. 

Logging Into Denodo Data Marketplace

1. Connect to the UW GlobalProtect VPN or Campus Network.
2. Access the Denodo Data Catalog login portal at https://connect.data.wisc.edu/denodo-data-catalog/
   
   1. The expected behavior is that you will arrive in the Denodo Data Marketplace application after confirming your Single Sign-On (SSO).   If that does not occur, and you instead come to a login screen for Data Marketplace, follow the next steps.
   2. Use the Virtual Dataport Server named localhost (set by default)
      1. Click the Single Sign-On button
      2. Complete the NetID login for Single Sign-On
         
         
         
3. If you are an approved user, you will be logged into the home page for Denodo Data Marketplace.
   The main tools in the Denodo Data Marketplace home page are:
   1. Browse control, which allows you to browse databases, tags, or domains.
   2. Query control, which allows you to write and save queries as well as create Tableau Dataset Connections.
   3. Help control, which allows you to Documentation and Resources for using Denodo Data Marketplace.
   4. Account Profile, which allows you to see notifications and to sign out of your session.
   5. Browse Catalog list, which allows you to click into data views and services that are present in Denodo Data Marketplace.
   6. Search field, which allows you to enter in a name or partial name of an object you seek to explore.
      

Browsing Databases in Denodo Data Marketplace

When starting your journey, it is recommended that you begin with the Browse Databases / Folders tool in Denodo Data Marketplace. 

1. Locate the Browse tool and select Databases
   
   
   
2. Data views are organized into folders or related data sources and then can be explored by the views each folder contains.  
   The folders will appear at the left of the screen, and folders can be expanded and collapsed using the [+] and [-] icons respectively.
   The 3 folders of particular importance are
   1. ext_bdw - which contains views from the Badger Data warehouse (Snowflake)
   2. ext_eap - which contains views from the EAP warehouse
   3. ext_ia - which contains views from the InfoAccess warehouse (Oracle)
      
      
      
      
3. In order to explore a view,
   1. Click on the name of the view in the left side of the screen.
   2. View the tools available for the view, which include Summary, Schema, Query, Data Preparation, and Relationships
   3. Notice there is an "Open In" tool.  This allows you save data connection strings for Tableau or PowerBI, or Connection URLs needed for other database tools. 
   4. Notice there is an icon in the shape of a question mark (?) which will provide context sensitive help. 
       
      
      
      
4. For more information about navigating the tools available in the sub-menu, please access the 'Using Data Marketplace Tools' article in the Related Articles section below.

Related Articles

Denodo: Using Data Marketplace Tools

Denodo: Connect DBeaver to Denodo

Denodo: Connect Tableau Desktop to Denodo

Need More Information?

If you have questions about this document, please contact Data, Academic Planning and Institutional Research (DAPIR, https://data.wisc.edu/) at badgerdata@wisc.edu.