Get started with Denodo at IU

Denodo is a data virtualization and data integration platform in use at Indiana University. Denodo can connect to many different kinds of data sources and then combine, aggregate, or join and filter these data sources and present the results in multiple formats.

On this page:


Request a new virtual database

All of your department's Denodo activity takes place within a virtual database (VDB). For a list of IU's current VDBs, see Current VDBs and Groups. To request a new VDB for your department, fill out the EDSS Support Form; for "Application", select Denodo, and for "Question Type", select New VDB.

Note:
Because Denodo can combine data from a variety of sources, all Denodo developers are required to take the FERPA Tutorial for student data and the HRMS Data Use Tutorial, in addition to signing the Acceptable Use Agreement.

Access a virtual database

For a list of IU's current VDBs, see Current VDBs and Groups. To request access to an existing VDB, which you'll need if you want to consume Denodo data or develop in Denodo, fill out the EDSS Support Form; for "Application", select Denodo, and for "Question Type", select Request access.

Develop in Denodo

Note:
Before you begin developing in Denodo, read Denodo - Best Practices.

To develop in Denodo, install the Denodo VDB client software, available for download from IUware; for installation instructions, see Install the Denodo VDP client.

Development occurs in the IU Denodo Dev environments at the following URL:

  • DEV: //ebidvt-dev.uits.iu.edu:9999/<your_VDB_name>

After migration, you can access Denodo views in Stage and Production at the following URLs:

  • STG: //ebidvt-stg.uits.iu.edu:9999/<your_VDB_name>
  • PRD: //ebidvt.uits.iu.edu:9999/<your_VDB_name>

For details about migration, see Migrating resources in Denodo at IU.

Create Denodo data sources

For help creating data sources in Denodo, see the following:

Access Denodo views

Once you create resources in Denodo, you can share views with others. To request access for others, fill out the EDSS Support Form; for "Application", select Denodo, and for "Question Type", select Request Access.

You can access Denodo views from many different platforms, including:

Use of enterprise data

Data manager approval is required whenever you make use of any data that has been sourced from enterprise data. Audits are in place for data sources in the development environment. Data sources will not be moved from the DEV environment to the STG environment until there is proof of data manager approval.

Important:
If you are exposing Restricted or Critical data programmatically, make certain that the appropriate Data Manager is aware of this use case and that access to your program requires strong credentials.

For more, see Data Manager approval for Denodo and Tableau.

Learn more

To learn more about Denodo, consult the following resources:

Get help

Enterprise Decision Support Services manages access to Denodo resources and can assist with data connection and design or help to improve the performance of your views. To contact EDSS, use the EDSS Support Form.

This is document ajmc in the Knowledge Base.
Last modified on 2018-06-21 17:18:04.

Contact us

For help or to comment, email the UITS Support Center.