Versions Compared

Version Old Version 117 New Version Current
Changes made by

Matthew Girard

Matthew Girard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

When using Denodo in production, it’s required that service accounts be used in place of personal credentials. With personal credentials, anything that relies on those credentials will break if you leave the university. Using a service account prevents this. You can ask the Data Strategy team to have a service account created for you and assigned the appropriate privileges.

Raising an Urgent Issue

If an urgent issue arises with Denodo that needs immediate attention, you should create a ticket in ServiceNow with the following field values:

  • Urgency: High
    This will spawn the following prompt. Click Yes

    image-20250123-155737.pngImage Removed

  • Paging Location: Denodo (if known, include the specific Denodo component at issue as well)

  • Service: Denodo

  • Assignment Group: TTS Data Virtualization

Developers

This section is dedicated to users who will be developing in Denodo and contains a collection of information to help you get started and succeed with Denodo at Tufts.

Skill requirements 

  • SQL 

  • Data modeling

Training

...

There is an “Introduction to Denodo' class available in the Tufts Learning Center which we require all new users to complete. Simply log in and search for “Denodo”.

...

Additionally, there is a Denodo Online User Community. If you create an account with your Tufts email, you can avoid entering the promotion code above for each course.

...

Denodo Tutorials

Onboarding Steps  

  1. Team new to Denodo

    1. Data needs determined

    2. Virtual Database (VDB) created in Denodo 

    3. AD groups created in Grouper 

    4. AD groups imported into Denodo

  2. Team exists in Denodo

    1. Dev AD group for team assigned

Connecting to Denodo

This section outlines Denodo’s services specific to developers and ways to connect to them

Design Studio

URL: https://denodo-solution-manager.it.tufts.edu:19443/denodo-design-studio/#/

Design Studio is a web-based IDE for developing with Denodo and will be your primary tool for Denodo development. To connect to Design Studio, follow the steps below.

  1. Navigate to the above URL

  2. When presented with the following screen, enter the hostname for the Development VDP (found under Virtual Data Port in the General Users section) in the following format //denodo-dev.it.tufts.edu:9999 and click Single Sign-On.

    Image Removed

While you can use Design Studio to connect to the Stage and Production VDP’s, your access will be read-only. You can only make edits in the Development VDP.

Solution Manager

URL: https://denodo-solution-manager.it.tufts.edu:19443/solution-manager-web-tool/Login

The Solution Manager is the central management tool for all Denodo environments. For developers, it’s used for deploying code through our Denodo environments.

Scheduler

URLs:

The Scheduler is used for creating jobs that need to run on a regular basis against the VDP.

When prompted for Scheduler Server, using one of the VDP URLs, enter //${VDP_URL}:8000/

...

Requesting access

In order to request access to data, please send a TechConnect ticket to the Data Virtualization team (data-virtualization@tufts.edu). In your ticket please include the following information:

...

Please provide a brief description of the business problem you are trying to solve and what you are requesting in order to address it. E.g. I am creating a dashboard for the Med School admissions team so that they can see year over year trends by degree and demographic information. I require 2 data sources to be made available in Tableau and refreshed weekly.

...

Data Source System

  • Is the source system managed internally or externally?

  • Please include connection information if applicable

  • Do you already have access to this data by other means?

...

Please supply a list of the data fields or tables by data source you are requesting and include what system they originate from. These do not need to be the official data field names if you do not know them- a description is fine. E.g. student name/SIS, academic program/SIS, application date/Slate.

...

If you are requesting any protected or sensitive data (PHI, PII, FERPA), please provide a rationale for having access to this data and the name of who has authorized the access if applicable. E.g. phone number, race, DOB, grades, admit status, vaccination status, etc.

...

Any additional helpful information

If you are requesting that Data Strategy create a specific view for you and/or end users, in additional to the above steps please also:

...

Specify what level of aggregation you need for each data source. Individual student level? Rolled up at the school or degree level?

...

Requesting access

In order to request access to data, please send a TechConnect ticket to the Data Virtualization team (data-virtualization@tufts.edu). In your ticket please include the following information:

  • Please provide a brief description of the business problem you are trying to solve and what you are requesting in order to address it. E.g. I am creating a dashboard for the Med School admissions team so that they can see year over year trends by degree and demographic information. I require 2 data sources to be made available in Tableau and refreshed weekly.

  • Data Source System

    • Is the source system managed internally or externally?

    • Please include connection information if applicable

    • Do you already have access to this data by other means?

  • Please supply a list of the data fields or tables by data source you are requesting and include what system they originate from. These do not need to be the official data field names if you do not know them- a description is fine. E.g. student name/SIS, academic program/SIS, application date/Slate.

  • If you are requesting any protected or sensitive data (PHI, PII, FERPA), please provide a rationale for having access to this data and the name of who has authorized the access if applicable. E.g. phone number, race, DOB, grades, admit status, vaccination status, etc.

  • Any additional helpful information

  • If you are requesting that Data Strategy create a specific view for you and/or end users, in additional to the above steps please also:

    • Specify what level of aggregation you need for each data source. Individual student level? Rolled up at the school or degree level?

    • Note any calculated fields that need to be developed and provide the business logic behind them.

Raising an Urgent Issue

If an urgent issue arises with Denodo that needs immediate attention, you should create a ticket in ServiceNow with the following field values:

  • Urgency: High
    This will spawn the following prompt. Click Yes

    image-20250123-155737.pngImage Added

  • Paging Location: Denodo (if known, include the specific Denodo component at issue as well)

  • Service: Denodo

  • Assignment Group: TTS Data Virtualization

This will push the ticket through the On-Call schedule set up for Denodo.

Developers

This section is dedicated to users who will be developing in Denodo and contains a collection of information to help you get started and succeed with Denodo at Tufts.

Skill requirements 

  • SQL 

  • Data modeling

Training

  1. There is an “Introduction to Denodo' class available in the Tufts Learning Center which we require all new users to complete. Simply log in and search for “Denodo”.

  2. There is also comprehensive, free on-demand training available on the Denodo website. Simply create an account using your Tufts email to access the training.
    For questions, email: training@denodo.comPlease note that courses may expire if you do not complete them within a certain timeframe; however, you can simply register for the course again to extend that timeframe.

  3. Additionally, there is a Denodo Online User Community. If you create an account with your Tufts email, you can avoid entering the promotion code above for each course.

  4. Denodo Tutorials

Onboarding Steps  

  1. Team new to Denodo

    1. Data needs determined

    2. Virtual Database (VDB) created in Denodo 

    3. AD groups created in Grouper 

    4. AD groups imported into Denodo

  2. Team exists in Denodo

    1. Dev AD group for team assigned

Connecting to Denodo

This section outlines Denodo’s services specific to developers and ways to connect to them

Design Studio

URL: https://denodo-solution-manager.it.tufts.edu:19443/denodo-design-studio/#/

Design Studio is a web-based IDE for developing with Denodo and will be your primary tool for Denodo development. To connect to Design Studio, follow the steps below.

  1. Navigate to the above URL

  2. When presented with the following screen, enter the hostname for the Development VDP (found under Virtual Data Port in the General Users section) in the following format //denodo-dev.it.tufts.edu:9999 and click Single Sign-On.

    Image Added

While you can use Design Studio to connect to the Stage and Production VDP’s, your access will be read-only. You can only make edits in the Development VDP.

Solution Manager

URL: https://denodo-solution-manager.it.tufts.edu:19443/solution-manager-web-tool/Login

The Solution Manager is the central management tool for all Denodo environments. For developers, it’s used for deploying code through our Denodo environments.

Scheduler

URL: https://denodo-solution-manager.it.tufts.edu:19443/webadmin/denodo-scheduler-admin/#/

The Scheduler is used for creating jobs that need to run on a regular basis against the VDP.

When prompted for Scheduler Server, using one of the VDP URLs, enter //${VDP_URL}:8000/

...

Connecting Data Sources

Denodo allows you to connect to a wide variety of data sources. The sections below outline how to connect to some common types of data sources at Tufts.

...