Connecting to Azure

My colleague is trying to connect to Azure through Alteryx using an Input Data tool. What he'd like to do is 'connect to Azure and run some of the stored procedures (that return data sets) and then use them in workflows'

They had been able to connect to Azure using Excel by creating an ODBC DSN.

Info: Input Data (1): ODBC Driver version: 03.80

Error: Input Data (1): Error SQLExecute: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint.

End: Designer: Finished running in 5.9 seconds with 1 error

Does anyone have any experience of this error? or further information around connecting to Azure?

Thanks in advance,

Ciaran

Input

Accepted answers

CiaranA

I believe it could have been because the user was using Version 9.5 of Alteryx. Alteryx Support mentioned that It is expected that any versions following 11.7 could support ODBC 13.1.

All comments

unknown

Alteryx is expected to connect to Microsoft Azure SQL Data Warehouse using ODBC 10.0 or 11.0 (https://help.alteryx.com/current/index.htm#DataSources/SQLDW.htm).

Could you please test with one of these drivers?

CiaranA

I believe it could have been because the user was using Version 9.5 of Alteryx. Alteryx Support mentioned that It is expected that any versions following 11.7 could support ODBC 13.1.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703