Denodo 8.0 Enterprise Plus for AWS Quick Start Guide

Last modified on: 21 Apr 2022

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 Amazon Web Services (AWS) marketplace in the form of a pay-as-you-go subscription. The VM image contains the latest version of Denodo Enterprise Plus, optimized for use with the AWS EC2.

Denodo Enterprise Plus is a new, advanced enterprise grade solution, powering data integration with AI/ML driven automatic recommendation of datasets, infrastructure management and smart query optimization

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. The Solution Manager is an optional component and can be deployed separately, depending on your needs. There is no extra charge for it.

For annual subscriptions, we highly recommend a private offer. The annual subscription includes the Denodo Solution Manager and a Denodo license for a development server. Kindly reach out to cloud.solutions@denodo.com or your account manager for more details about the private offer.

Thank you for your confidence in Denodo and choosing the Denodo for AWS 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 AWS.

Denodo Platform for AWS Hourly Listings Usage Instructions

Prerequisites

You must have an AWS account.

You are responsible for operating your own AWS account and the related infrastructure charges.

You can create and launch your Denodo Platform for AWS instance using that AWS Account.

Please note that prior to your subscription deployment, you would need to generate a key pair to be able to login to the Denodo server EC2 instance, and thus ensure a smooth installation process. Kindly check with your AWS administrator, if you need help with this step.

First Steps

Step 1 - Subscribe to Your Denodo Enterprise Plus for AWS

Log on to the AWS Marketplace, search for the Denodo Enterprise Plus listing, and launch the instance through the EC2 Console.

Note that it may take up to 15-20 minutes for the Denodo instance to be configured and started.

Remember to make sure you choose a vpc and subnet with the right permissions so you can connect without problems. Check with your IT/AWS administrator for additional help as needed.

Step 2 - Getting Started with Denodo using the design studio/admin tools

Once the Denodo instance is running, you can use the web tools readily available and optionally install the Denodo VDP Administration Tool to access VDP.

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.

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 Enterprise Plus VDP virtual machine in the deployment.

The connection details for all tools are as follow:

Username: admin
Password: the running Amazon instance ID. You can obtain it in the AWS console or by retrieving the instance metadata (see here).
Server URI (Only applies to client installer): replace "localhost" with your running Amazon instance's public internet name or IP address

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

You can find links to all the Denodo web tools, the client installer and step-by-step installation instructions from your running Denodo instance's web server. Use your Internet browser pointing to your instance's public Internet name or IP address (screenshot below). Note that the client installer is distributed from the running instance.

The VDP administration tool is a desktop client which allows administering VDP servers. You can install it in your local computer by following these instructions. The VDP administration tool is needed for configuration tasks such as configuring the server authentication, the server connectivity options or the Denodo cache (see here for details). It is also needed to use some advanced tools like the Resource Manager (see here for details) or the tools for creating summaries for query acceleration (see here for details).

Remember to follow the recommended security configuration settings below, in particular changing the default administrator password.

Optional Configuration Steps

Step 3 - Review the Security Configuration

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

Changing the Default VDP Administration Password

As the first step of the configuration of your new Denodo instance you should change the administrator password. The current password was generated automatically and matches your Amazon instance ID. 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 Platform default ports to review which ones are needed for operating your environment.

When a new virtual image is started Amazon creates by default a new security group. This group contains all TCP ports that Denodo may need to use plus the ssh (for server administration) and http (for the quickstart guide and client installers). The default values specify that all those ports can be reached from any IP addresses - our strong recommendation is to modify the groups to:

Remove the HTTP port.

Configure the rest of security 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 Amazon guide located at: http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-network-security.html.

The general documentation about running your EC2 instances in Amazon is available at: http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/launching-instance.html.

Disabling the Public Web Server

The Denodo instance that you are currently connected to is using a public httpd server to display this page, which contains instructions and installers. When you are done setting up your client installation we recommend you to disable the server. This is accomplished in two steps:

Connect to the Denodo instance using ssh. Follow the steps described in Amazon's documentation at: http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/AccessingInstances.html.

After opening a remote command line through ssh or PuTTY, type these commands to disable the httpd server:

sudo service httpd stop
sudo chkconfig httpd off

Step 4 - Subscribe to Denodo Support

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

Denodo Support is available for all subscribers. To access this service, you must first register here. 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 included as upgrades require migration between Amazon 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's 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.

Step 5 - Migrate existing metadata from another Denodo installation

If you wish to migrate data from an existing Denodo installation to this instance, 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.

Step 6 - 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.

You need to sign-up for Denodo Support and request a license key for the Denodo Solution Manager. Later, you can use the license key with the Solution Manager BYOL instance on the Marketplace. Follow the instructions in the BYOL Quick Start Guide for more details.

Further Steps

Once you are all set to start building your data virtualization solutions on AWS, we recommend that you check out all the available 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 Denodo in the quickest time, we recommend that you take advantage of Denodo Professional Services.

USER MANUALS