Denodo - Installing Client Software

Denodo developers need to install the Virtual DataPort client and have their account configured before working in Denodo. Follow the applicable steps below to download, install, and configure the software.  Note that you will need to be on the VPN to connect to the ITS Denodo instance.

Windows Installation

  1. Click to download the following files, then unzip them: 
  2. Open denodo-install0client-7.0 > denodo-install-client-7.0 folder.
  3. Run install.exe and follow the installation wizard.
    • Accept the license agreement.
    • Choose the default installation.
    • Install the Common and Virtual DataPort packs.
  4. Launch Denodo Platform 7.0 to open the Denodo Platform Control Center.
  5. Click Update

  1. Click Install Update
  2. Navigate to and select denodo-vdp-v70-update-202011162200.jar from the denodo-vdp-v70-update-20201116 folder.
    • Click OK on the alert messages that display while running the updater. 
  3. Launch Denodo Platform 7.0 to open the Denodo Platform Control Center.
  4. Click Virtual DataPort
  5. Click Launch

  1. Select Admin Tools preferences from the Tools menu.

  1. Click the Kerberos Authentication radio button in the Authentication Type section. 
  2. If you have Kerberos credentials on your machine, select the Use Single Sign-On with system ticket cache radio button in the Authentication Mode section. Otherwise, select the Use user/password radio button.
    • When using user/password, enter your fully qualified username: uniqname@ADSROOT.ITCS.UMICH.EDU. 
  3. (Optional) Enter the server, port and database name in the Server URI field to set the default startup connection.  You may already have a VDB created, if so use those settings. Otherwise, it is recommend you use “gateway” - //denodo.it.umich.edu:9999/example_database_name.  

  1. Click OK.
  2. Click Connect.

Linux Installation - Unsupported

Denodo runs on Linux, but it is not an officially supported configuration at U-M. ITS only supports Denodo clients on UM-managed Windows systems connected to Active Directory. 

The installation and configuration information included here has worked for some U-M staff, if you want to proceed with a Linux installation on your own. 

Before beginning, you need to: 

Configure the following: 

  • Enable “Universe” in the software sources
  • From the terminal, run command: sudo apt install krb5-user
  • Enter umich.edu when the installer prompts for DefaultKerberos Realm
  • Update /etc/krb5.conf as follows (you may need to edit with sudo, i.e., sudoedit /etc/krb5.conf):

[libdefaults]
        default_realm = ADSROOT.ITCS.UMICH.EDU

[realms]
        UMICH.EDU = {
                kdc = kerberos-3.umich.edu:88
                kdc = kerberos-2.umich.edu:88
                kdc = kerberos-1.umich.edu:88
                kdc = kerberos-4.umich.edu:88
                master_kdc = kerberos-admin.umich.edu:88
                admin_server = kerberos-admin.umich.edu:749
                default_domain = umich.edu
        }

        ADSROOT.ITCS.UMICH.EDU = {
                kdc = adprod-dc-m1.adsroot.itcs.umich.edu:88
                kdc = adprod-dc-m2.adsroot.itcs.umich.edu:88
                kdc = adprod-dc-n1.adsroot.itcs.umich.edu:88
                kdc = adprod-dc-n2.adsroot.itcs.umich.edu:88
                kdc = adprod-dc-s1.adsroot.itcs.umich.edu:88
                admin_server = adprod-dc-m2.adsroot.itcs.umich.edu:88
                default_domain = umich.edu
        }

[appdefaults]
        afs-use-524 = no

[domain_realm]
        .umich.edu = UMICH.EDU
        adsroot.itcs.umich.edu = ADSROOT.ITCS.UMICH.EDU
        .adsroot.itcs.umich.edu = ADSROOT.ITCS.UMICH.EDU

  • In Terminal, run the command: kinit username@ADSROOT.ITCS.UMICH.EDU.
  • klist shows the Kerberos ticket and verifies everything has been set up properly. From that shell, run denodo_platform.sh.

Once the configuration is complete:

  • Launch the VDP Admin Tool. 
  • Select Admin Tools preferences from the Tools menu.
  • Click the Kerberos Authentication radio button in the Authentication Type section. 
  • Enter your database name in the Server URI field.

Mac Installation - Unsupported

Denodo and U-M do not support a Mac OS X client and will not troubleshoot any problems with a Mac OS installation.

The following information is provided as a courtesy for individuals who still want to attempt a Mac OS installation:

  • Java 1.8 or a similar OpenJDK version needs to be installed in order to run. JAVA_HOME needs to be set before working with Denodo.
  • A UMROOT Kerberos ticket is required.  This should happen by default on a MiWorkspace Mac when connected to the VPN.  Users on Macs without UMROOT credentials may need to set up Kerberos similar to the Linux instructions above. 
  • Install the client: 
    • Download and unzip denodo-install-vdp-client-7.0.zip and the latest update file.
    • Inside the denodo-install directory, create a denodo-update directory and save the unzipped update into that directory, renaming it from denodo-vdp-v70-update-XXXXXXXX.jar to denodo-update.jar. 
    • Run the install script.
    • Run the denodo_platform script to launch the client.
Tags: 
Last Updated: 
Friday, January 8, 2021