Alteryx IO Discussions

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.

Stored Procedures not supported in Alteryx for CData NetSuite ODBC connection

cvalteryx
7 - Meteor

I’m using NetSuite ODBC driver and I want to execute stored procedure. But, for CData NetSuite OBDC Driver I’m not able to view the stored procedure and getting error message as ’not supported for this type of connection’. Please find below for the screenshot:

 

cvalteryx_0-1658121536006.png

 

 

 

Driver website: NetSuite ODBC Driver: ODBC Driver for NetSuite - CData Software

 

But, it’s working for SQL server connection. Please find below for the screenshot:

 

cvalteryx_1-1658121536076.png

 

 

 

Need a solution to access and execute stored procedure in Alteryx using CData NetSuite ODBC connection.

 

Any leads would be appreciated.

TIA

 

2 REPLIES 2
Samantha_Jayne
Alteryx
Alteryx

@cvalteryx are you able to enter in the EXEC testSp command into the SQL Editor and it runs on the connection without access to the Stored Procedure Tab?

Samantha Clifton
Alteryx
#alteryxrocks
cvalteryx
7 - Meteor

Thanks. This works but not for all scenarios.