Stored Procedures not supported in Alteryx for CData NetSuite ODBC connection

Question

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:

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:

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

Any leads would be appreciated.

TIA

cvalteryx · Answer

Thanks. This works but not for all scenarios.

Samantha_Jayne · Answer

@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?