Q&A BY TAG 'ODBC Alteryx'

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

issue in accessing derived views in Alteryx
answered 19-10-2018 16:17:06 -0400

Hi, I have provided access for a derived view from denodo to Alteryx. The user is able to access the derived view from SQL editor in Alteryx. My question here is Can I view the list of derived views in the rightside navigation panel in the Visual Que...

Answers: 2

access ODBC Alteryx derived view alteryx

Connecting to multiple databases with ODBC Connection
answered 03-05-2018 12:31:28 -0400

My goal is to be able to query multiple databases in a workflow, but I am not able to determine how to set up one ODBC connection that allows you to query more than one, or how to set up multiple ODBC connections that are each mapped to one database. I...

Answers: 1

ODBC ODBC Alteryx

Is it possible to query only the data in the Cache of a derived view?
answered 06-04-2018 08:15:25 -0400

Hello - very new to Denodo and running into a questions I am looking for help with. Esentially, I have created an ODBC connection between our denodo databases and Alteryx. I am querying data from a denodo table, but I am only interested in returning da...

Answers: 1

Driver ODBC Alteryx Cache

Error opening "SELECT oid from pg_type where typname = 'geometry'"
answered 03-08-2017 05:26:36 -0400

I have made ODBC connection to Denodo from Alteryx. Connection is successful. But, when I ran the workflow to query a Denodo table/view in Alteryx, it throws below error. Start: Designer x64: Started running D:\Alteryx\New Workflow1.yxmd at 6/23/2017...

Answers: 4

ODBC Alteryx oid alteryx

Derived view access issue from Alteryx
answered 13-07-2017 09:06:23 -0400

Hi, User wanted to connect to a derived view from Alteryx, So I have provided connect privilege for the respective database and read privilege to the derived view. Now the user is able to access the derived view from SQL editor in Alteryx but not able...

Answers: 1

access ODBC Alteryx derived view