How to connect to Denodo from Alteryx

Applies to: Denodo 8.0 BETA , Denodo 7.0
Last modified on: 19 May 2020
Tags: Alteryx DSN SSL ODBC driver

Download document

You can translate the document:


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 2020.1.5.25447.


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 in 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 the toolbox into the canvas.

  1. Click on the arrow of the selection drop down menu for Connect a File or Database and click on Data Sources on the pop-up window.

  1. Select ODBC on Generic Connection

  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 the 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 networks. The picture belows shows you a simple workflow. When you press the 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 the Denodo VDP server by changing properties of file  in the folder <DENODO_HOME>/conf/vdp.
  3. Enable SSL for Alteryx Designer by setting the Java system property 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.



Virtual DataPort Developer Guide

Denodo Platform Installation Guide

Alteryx Learning Guide


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

Featured content


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.