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
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.
It is possible to use SSL to make secure connections between Alteryx Designer and the Denodo VDP Server. The following steps should be followed:
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.