Get started with Denodo at IU

• Request a new virtual database
• Access a virtual database
• Develop in Denodo
• Create Denodo data sources
• Access Denodo views
• Use of enterprise data
• Learn more
• Get help

Request a new virtual database

All your department's Denodo activity takes place in a virtual database (VDB). To request a new VDB for your department, fill out the EDSD Support Form ; for "Application", select Denodo, and for "Question Type", select New VDB.

Access a virtual database

For you to obtain developer access to an existing VDB, someone who already has developer access to that VDB must fill out the EDSD Support Form and authorize your access. To request access to consume Denodo data, contact the appropriate Data Manager who oversees that particular area's data. If you need assistance with either type of access, fill out the EDSD Support Form ; for "Application", select Denodo, and for "Question Type", select Request access.

Develop in Denodo

Beginning with Denodo 8, you have two options for developing in Denodo:

• Use the web-based Design Studio: Select an environment from the drop-down menu, and choose Open on the "Design Studio" tile.
  • Production: Log in at https://denodo.dvt.iu.edu/solution-manager-web-tool/.
  • Development and Stage: Log in at https://denodo-dev.dvt.iu.edu/solution-manager-web-tool/.
  • Sandbox: Log in at https://denodo-snd.dvt.iu.edu/solution-manager-web-tool/.
• Use the Virtual DataPort Administration Tool client: Install the Denodo VDB client software on your computer, available for download from IUware.

  Start the client on your computer, and then launch the Virtual DataPort administration tool in the client. In the "Login" and "Password" fields, enter your IU username and passphrase, respectively. The "Server URI" value depends on which environment you need to access.

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

Create Denodo data sources

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

• Create Denodo data sources
• Connect to IU Active Directory as a Denodo data source
• Connect to DSS as a Denodo data source
• Connect Denodo to departmental databases

Access Denodo views

Once you create resources in Denodo, you can share views with others. To request access for others, see Use Data Delivery Apply Security to assign security to Denodo views.

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

• Tableau: See Denodo/Tableau ODBC Setup.
• Visual Studio: See Connect to Denodo from visual studio for SQL server reporting.
• Web services: See Denodo and REST APIs.
• JDBC: See Connect to Denodo through JDBC.
• ODBC: See Connecting from your application: ODBC Clients.
• Excel: See Accessing Denodo Views in Excel.

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.

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

Learn more

To learn more about Denodo, consult the following resources:

• To get started setting up views, see First steps: Organizing the Database.
• Learn about linked data to examine existing views.
• To improve the performance of a view, see Optimize Denodo views.
• For more, see the Denodo Platform Documentation.

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 EDSD Support Form .