Understanding Denodo
Denodo provides no-cost on-demand training courses, materials, and certification exams to help grow your Denodo data virtualization skills and demonstrate your knowledge:
- On-demand training via role-specific learning paths or the full course catalog
- Denodo certification exams
- Course registration instructions
Data Sources
By default, Developers have access to virtualized views representing the components of the U-M Data Warehouse datasets to which they already have access. This allows Developers to source data from these views without the need to create/maintain their own U-M Data Warehouse data sources. Developers can create data sources to other systems or repositories as needed.
For information on creating data sources, see the following:
- Custom Sources
- Delimited File Sources
- If you do not have a suitable file host (such as an SFTP server), ITS recommends using Dropbox to host delimited files to be exposed via Denodo.
- Dropbox
- Excel Sources
- If you do not have a suitable file host (such as an SFTP server), ITS recommends using Dropbox to host Excel files to be exposed via Denodo.
- Google BigQuery
- Google Sheets
- JDBC Sources
- JSON Sources
- Multidimensional Database Sources
- One Drive
- SFTP
- SOAP Web Services Sources
- U-M API Directory API
- XML Sources
Note: ODBC data source connections are not currently available.
Sharing Views
Developers can share views created in Denodo with an MCommunity group. To share a view:
- Submit a ticket for the ITS-Denodo team through the ITS Service Center. Include a list of the Denodo views and the MCommunity groups which should be granted access.
- Verify the appropriate individuals are in the MCommunity group(s).
For more information on Denodo access using MCommunity groups, see the Denodo - Roles and Privileges page.
U-M Guidelines and Policies
Denodo users are bound by all U-M data security policies. For more information, see: