How to connect to Denodo from Alteryx

Applies to: Denodo 7.0
Last modified on: 26 Feb 2019
Tags: SSL Alteryx DSN ODBC driver

Download document

Goal

Alteryx Designer is a software used by data artisans to process data and perform analytics. It is both an editor and an engine. It is relied upon for its ability to process large, complex datasets very quickly while executing repeatable and highly sophisticated analytics.

This document aims to describe how a Denodo Virtual DataPort (VDP) database can be accessed from Alteryx Designer Tool and how data from VDP views can be used.

This document has been tested with Alteryx 2018.4.5.55178.

Introduction

With Alteryx Designer Data artisans drag tools from a toolbox onto a canvas, connect them together, and then edit their properties to create an Alteryx Workflow, which can be run within the Alteryx Designer. Workflows can be authored into Analytic Apps where they can be published publicly or privately and run by anyone with an internet connection.

To connect to Denodo from Alteryx, it is needed to use the ODBC driver provided by Denodo. This driver is located at the folder <DENODO_HOME>\tools\client-drivers\odbc. In order to make the connection work, you can follow the steps below.

Install the Denodo ODBC driver and set up a DSN

Install the Denodo ODBC driver that matches the Alteryx client and then create a DSN that points to a Virtual DataPort database as explained in the section Access Through ODBC of the Virtual DataPort Developer Guide.

Configure the connection to Denodo in Alteryx

  1. Open the Alteryx Designer Tool.

  1. Drag and drop the Input Data tool from them toolbox into the canvas.

  1. Click on the arrow of the selection drop down menu for Connect a File or Database and go to Other Databases > ODBC.

  1. In the Data Source Name drop down menu select the DSN you set up in the initial step, type User Name and Password then click OK.

5.  Drag and drop the Denodo views to left side, you can also use the option SQL Editor. To do that, select the required fields, edit them and then click Ok.  

Create a workflow with Alteryx Designer

Once the input data is successfully configured, you can use any tools in the toolbox to make either classic analysis or predictive analysis using some algorithms like neural network. The picture belows shows you a simple workflow. When you press Run button or use Ctrl+R, the workflow file denodo.yxmd will run and you will get the results of the workflow.

Configuring SSL

It is possible to use SSL to make secure connections between Alteryx Designer and the Denodo VDP Server.  The following steps should be followed:

  1. Obtain and install an SSL Certificate(eg: selfcert.cer).
  2. Enable SSL in Denodo VDP server by changing properties of VDBCongiguration.properties file  in the folder <DENODO_HOME>/conf/vdp.
  3. Enable SSL for Alteryx Designer by setting the Java system property javax.net.ssl.trustStore to point to the TrustStore that contains the certificate used by Denodo VDP Server.
  4. Open ODBC Data Source Administrator, go to the DSN that you already set up, click Configure, in the option SSL Mode, change it from “disable” to “require” as the following picture shows.

For the first three steps, please refer to the Enable SSL Connections in the Denodo Platform Servers section of the Denodo Platform Installation Guide. After doing all the steps,  you can use SSL for a secure connection.

     

References

Virtual DataPort Developer Guide

Denodo Platform Installation Guide

Alteryx Learning Guide

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training