• User Manuals /
  • Denodo 9 Enterprise for Azure Quick Start Guide

Denodo 9 Enterprise for Azure Quick Start Guide

Download original document


You can translate the document:

Denodo Platform, the data virtualization leader for unifying enterprise data and delivering data services for the business, is available on Azure as a pay as you go (PAYG) virtual machine (VM).

Thank you for your confidence in Denodo and for choosing the Denodo for Azure as your data virtualization technology!

This quick start guide will give you an overview of  Denodo and how to quickly start building data virtualization solutions on Azure.

Marketplace Offering Overview

The Denodo Enterprise for Azure VM is based on a pay as you go (PAYG) model under your Azure account.

The hourly/pay-go subscription pricing is for the Denodo server (aka VDP - Virtual Data Port server),  while the infrastructure (compute, storage) charges are separate and the user's responsibility.

Therefore it is expected that you already have an Azure subscription with an associated Billing Account that you can use to logon to the Azure Marketplace in order to subscribe, create and launch the Denodo Enterprise virtual machine through the Azure Portal.

For annual subscriptions, we highly recommend a private offer. Kindly reach out to cloud.solutions@denodo.com or your account manager for more details about the private offer.

The Denodo Enterprise offer on Windows Server consists of:

  • The Denodo Virtual DataPort (VDP), the core Denodo Data Virtualization engine, to integrate data from any data source and deliver it to any consumer in any format.
  • The Denodo Scheduler, for scheduling data pipelines and cache loads among other tasks.
  • The Denodo Data Catalog webtool to enable self-service and data discovery for end users.
  • Additional tools for administering and developing like the Denodo Design Studio webtool and the Denodo VDP Administration Tool.

In the sections below you can find more information on how to deploy.

NOTE: this offering does not require a Denodo Solution Manager with a Denodo License Server to run the VDP services in the VM; the Solution Manager is an optional component and can be deployed separately, depending on your needs. There is no extra charge for it.

Deploy the Denodo Enterprise VM

Overview

You must have an Azure subscription with a valid payment method. You are responsible for operating your own Azure subscription. You can create and launch your Denodo Enterprise for Azure PAYG VM using that Azure subscription.

As a summary of the instructions you will need to complete the following steps:

  1. Use your Azure Subscription to subscribe to the Denodo Enterprise on the Azure Marketplace
  2. Create the VM
  3. Log into the Design Studio Web Tool
  4. Log into the Scheduler Admin Web Tool
  5. Log into the Data Catalog Web Tool
  6. Register for Denodo Support

Note: The Azure Portal interface is subject to change and the exact options you see may change depending on your Azure account profile.

Step 1 - Subscribe to Denodo Enterprise for Azure on Windows Server

You are responsible for operating your own Azure subscription.

You can create and launch your Denodo Enterprise for Azure solution app using your Azure subscription.

Log on to the Azure Marketplace, search for the Denodo 9 Enterprise offer and click on the Get It Now button.

Then you will go to Azure Portal

We recommend that for an initial evaluation or testing you follow the “Start with a pre-set configuration” path. Next chapters will be based on that option.

Step 2 - Denodo Enterprise VM Creation

You have to complete some few configuration steps in order to launch the Denodo VM through the Azure console.

Select Dev/Test and General Purpose. Then “Continue to create a VM”.

Parameters needed to create the VM:

  • Resource Group. The recommendation is to create a new one for evaluation / testing purposes. Note that the name of the Resource Group will be the initial password for the admin user in all Denodo services and tools.
  • VM name.
  • Region. Select the region you prefer and take into account you have quote available to launch the VM.
  • Availability: No infrastructure redundancy required
  • Security: Standard.
  • Administrator Account. This is the username and password for managing the VM Windows Operating System, not the username to log in Denodo tools.

Then click on “Review + Create”

In the next screen, click on “Create”

In around 10 minutes your VM will be ready.

Step 3 - Launch Denodo Service

Enter the instance through RDP or SSH and launch the VDP service:

In the user desktop there is an direct  access to Denodo Platform. Launch it and wait until the admin  tool is shown.

Then in the left side panel select “Virtual DataPort” and launch both “Virtual DataPort Service” and “Diagnostic & Monitoring Tool”.

After that, in the “Scheduler” section in the same left side panel launch “Scheduler Server” and all required services are launched.

Step 4 - Log into the Design Studio Web Tool

The Design Studio provides a web interface to the developers to create data sources, base views, derived views, publish web services, etc.

Check first the list of Supported Browsers for the Design Studio tool. The VM is based on a Windows Server and it comes with Windows Explorer but you cannot use it because it is one of the browsers not supported by Denodo tools.

Then use a supported browser to point to the following URL of the Design Studio Web Tool following the pattern:

http://<vm_ip>:9090/denodo-design-studio/

Where <vm_ip> is the IP address or DNS name for the Denodo VM. The default user is admin and the password is admin too, so remember to change the password to a secured one after the first run..

Note that services in the VM require some time to start, meanwhile you could get a 404, wait some minutes and try again.

Refer to Main Areas of the Design Studio for more information.

Note that certain administrative tasks like cache configuration, setting-up the authentication, user management, etc can be done graphically only by using the Virtual Dataport Administration tool (desktop based).

Step 5 - Log into the Denodo Scheduler Admin Web Tool

The Scheduler Admin provides a web interface to administrators to create jobs.

http://<vm_ip>:9090/webadmin/denodo-scheduler-admin/

Where <vm_ip> is the IP address or DNS name for the Denodo VM. The default credentials are ‘admin/admin’

Refer to Denodo Scheduler Administration Guide for more information.

Step 6 - Log into the Denodo Catalog

The Denodo Data Catalog is a web application that allows end users to query and browse all the information accessible through Denodo.

http://<vm_ip>:9090/denodo-data-catalog

Where <vm_ip> is the IP address or DNS name for the Denodo VM. The default user is admin and the default password is the name of the Resource Group.

Refer to the Denodo Data Catalog Documentation for more information.

Step 7 - Register for Denodo Support

Denodo is committed to helping you succeed with the Denodo Platform through our comprehensive network of technical support and services.

Denodo Standard Support is available for all subscribers. To access this service, you must first register on our website. After you have signed-up, you will have access to the Denodo Support Site where you can get web-based support, software updates and DenodoConnects, which will improve your data virtualization experience. Denodo version upgrades are not available as version upgrades require migration between Azure instances.

You can always post your question directly on the Q&A section, a moderated forum on our Community Site, where data virtualization professionals and enthusiasts will assist you. Our community is knowledgeable and tenacious and there is no question without a valid answer. Technical resources such as product documentation, Knowledge Base articles, step-by-step tutorials, and how-to videos are also available.

Optional Actions after Deploying

Review the Security Configuration

There are a couple of optional steps that we recommend you to take in order to improve the security of your Azure deployment.

Changing the Default VDP Administration Password

As the first step of the configuration of your new Denodo virtual machine you should change the default administrator password. It is extremely important that you change this default password to ensure that you are operating under a secure environment.

Configuring the Security Groups

Please, check first the list of Denodo default ports to review which ones are needed for operating your environment.

When a new virtual image is started Azure creates by default a new security group. This group contains all TCP ports that Denodo may need to use plus the RDP (for server administration). The default configuration specifies that all those ports can be reached from any IP addresses - our strong recommendation is to modify the groups so they can only be accessed from the range of authorized IP addresses that you control instead of being publicly accessible.

To do this, follow the steps in the Azure guide located at: https://docs.microsoft.com/en-us/azure/virtual-network/virtual-network-manage-nsg-arm-portal

VDP Client Access from Outside of VM

You have to configure the Virtual DataPort server in order to receive connections from external clients to the VM.

The default ports for Denodo based on the connection protocol are:

  • JDBC: TCP 9999.
  • ODBC and ADO.NET: TCP 9996.
  • Web Container: TCP 9090.

VM must be configured to allow the connections to ports enumerated above according to the connection protocol needed:

  1. Update the Azure network Security Group associated with the VM network interface using the Azure Portal.
  2. Update the Windows firewall in the Denodo for Azure VM. You have to set up the appropriate Windows firewall rules. Log in the VM,  start Control Panel > System and Security > Windows Firewall (or open PowerShell or Command Prompt and enter ‘firewall.cpl’), clicking the advanced settings button, and create the Inbound Rules needed.

As a side note, take into account that by default an ephemeral external IP address is assigned to the VM instance. If you require a static external IP address, you may promote the address to static. Be sure that the VDP server is set correctly for accepting connections through that IP by changing the Host Name in the VDP server.

Start & Stop Denodo Services

Logged in with your Administrator Account user through Remote Desktop Connection and once a Denodo license is installed you can start enjoying Denodo software.

Launch the Services app to start Denodo Servers in the following order:

  1. Start Denodo Virtual DataPort Server, wait until getting status Running.
  2. Start Denodo Scheduler Server, wait until getting status Running.
  3. Start Denodo Index Engine Server, wait until getting status Running.
  4. Start Denodo Web Design Studio, wait until getting status Running.
  5. Start Denodo Scheduler Web Admin Tool, wait until getting status Running.
  6. Start Denodo Data Catalog, wait until getting status Running.

For stopping the services follow the reverse order.

Migrate Existing Metadata from Another Denodo Installation

If you wish to migrate data from an existing Denodo installation to a new VM, proceed with the steps below. Note that each existing environment should be migrated to a different instance.

Start by exporting the metadata from the existing Virtual DataPort and importing it in the new one. The steps are detailed in the Virtual DataPort metadata export and import guide.

A similar approach is to be taken to migrate Scheduler metadata. The steps are detailed in the Scheduler metadata export and import guide.

If you wish to migrate Data Catalog metadata, the equivalent steps are detailed in the Data Catalog metadata export and import guide.

Last, if you wish to migrate existing Diagnostic & Monitoring Tool metadata, follow the steps in the Diagnostic & Monitoring metadata export and import guide.

Deploying the Denodo Solution Manager

This is optional and may be needed if you are planning to use SSO configuration with Denodo webtools (Design Studio, Scheduler Admin...) using a third party IDP such as Okta.

The Denodo Solution Manager BYOL available through Azure Marketplace includes a limited Denodo Solution Manager license that allows to use SSO with  Denodo Servers PAYG.

Further Steps

Once you are all set to start building your data virtualization solutions on Azure, we recommend that you check out all the available Denodo information:

If you want to move on to professionally guided training you can always check our course offerings on our training site.

To get up and running on the Denodo Enterprise for Azure  7.0 in the quickest time, we recommend that you take advantage of Denodo Professional Services.