Creating A Custom Azure Image for the Denodo Platform

We provide an Azure Image that includes the Denodo Platform 8.0 that is specially configured to be managed with the Solution Manager. That is the image you select in the page Configuration > Automated mode, in the section Default region & Images or when you create a cluster in automated mode.

Note

The Automated Cloud mode support for Azure is available since 8.0u20220126 so this page only applies for this update or a more recent one.

In this image we provide, the operating system is Windows Server. If you want to modify the default options of this image, you can create your own.

This section explains how to create your own image, with the Denodo Platform configured to be managed by the Solution Manager.

Important

If you create an image and just install the Denodo Platform on it, the Solution Manager will not be able to manage it (i.e. create a Virtual Machine based on it and start the Denodo components, stop them, etc.). You need to create the image following these steps.

  1. Launch a Virtual Machine based on one of the Windows versions that Denodo supports.

    When choosing the type of instance, consider the hardware and software requirements of the Denodo Platform.

    Ensure that the Virtual Machine use a managed disk and RDP inbound port (3389) is allowed.

  2. Connect to the Virtual Machine using RDP and the Administrator account defined when created.

  3. Copy to this Virtual Machine the installer of the Denodo Platform 8.0 and the latest update (if available).

    During the installation, do this:

    • Choose Custom Installation.

    • Installation path: C:\Denodo\DenodoPlatform8.0.

      Important

      Use this installation path. If you use a different one, you have to specify its value when creating the Denodo Azure Service.

    • License path: press Enter (do not provide anything).

      This instance will connect to the License Manager to obtain a license.

    • Select all the components to install, except ITPilot.

    • Use default values for the rest of the options.

      Important

      Be sure to uncheck to install the components as a Windows Service.

    • Once the installation ends, do not create shortcuts.

  4. Configure Windows Defender Firewall to allow the OpenJDK application through firewall

    You must allow both paths: C:\Denodo\DenodoPlatform8.0\jre\bin\javaw.exe and C:\Denodo\DenodoPlatform8.0\jre\bin\java.exe

    Windows Security Firewall

    Windows Security Firewall

    Windows Defender Firewall Allowed apps

    Windows Defender Firewall Allowed apps

  5. Ensure latest Python version 3.9 is installed. Ensure to add the python.exe to the path environment variable for all users.

  6. Execute this to upgrade pip and install the required Python packages:

    > python -m pip install --upgrade pip
    > pip install requests
    > pip install pywin32
    > pip install azure-core
    
  7. Install the Denodo Azure Service for Windows

    > sc.exe create DenodoAzure binPath="C:\Program Files\Python39\python C:\Denodo\DenodoPlatform8.0\tools\cloud\azure\denodo_azure_srv.py -loglevel=DEBUG" DisplayName="Denodo Azure service" start=delayed-auto
    > sc.exe failure DenodoAzure reset=86400 actions=restart/5000/restart/5000/restart/5000
    

    Important

    It is assumed the python installation path is C:\Program Files\Python39.

    This python script assumes you installed the Denodo Platform in C:\Denodo\DenodoPlatform8.0. If not, the installation path can be specified with argument -DENODO_HOME.

  8. It is necessary to generalize the Virtual Machine. Open a command prompt and execute the following command:

    > C:\Windows\System32\sysprep\sysprep.exe
    

    In the System Preparation Tool dialog box, select Enter System Out-of-Box Experience (OOBE) and select the Generalize check box.

    For Shutdown Options, select Shutdown.

    Select OK.

    Virtual Machine sysprep

    Virtual Machine sysprep

    When Sysprep completes, it shuts down the Virtual Machine. Do not restart it.

  9. Now yo can go back to the Azure portal and create an image using this Virtual Machine.