You can translate the 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 2023.1

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.

In order to make the connection work, you can follow the steps below.

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 Set Up a Connection on the pop-up window.

  1. Select Quick connect on Denodo


  1. In the Connection Manager click on New and introduce the following parameters:
  • Data Source Name: this is the name of the data source that we want to create.
  • Host: the host where Virtual DataPort is located.
  • Database: The database of Virtual DataPort that we want to connect.
  • Port: The ODBC port, by default 9996.

  1. Then, in the connections tab click on Connect Credential and in the field Credential click on Create New Credential and introduce the following parameters:

  • Credential Name: name to save the credential in Asteryx.
  • Username: the username of Virtual DataPort
  • Password: the password to access Virtual DataPort.

Finally, 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 below 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.

We have to enable SSL in the Denodo VDP server. Please, refer to the “Enable SSL Connections in the Denodo Platform Servers” section of the Denodo Platform Installation Guide.

After doing all the steps, in the data source connection change in the option SSL Mode, change it from “disable” to “require” as the following picture shows.

     

References

Virtual DataPort Developer Guide

Denodo Platform Installation Guide

Alteryx Learning Guide

Disclaimer
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.

Questions

Ask a question

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