SQLDW does not support client-side or server-side cursors as it is designed for dimensional table querying that retrieves the full result set.pxbridge(0),0: ODBC Info: SQLSTATE = 42000: Native Error Code = 46,706: Msg = [Microsoft][SQL Server Native Client 11.0][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint.
pxbridge(0),0: Execution failed on statement select
pxbridge(0),0: ODBC function "SQLExecute" reported: SQLSTATE = 42000: Native Error Code = 46,706: Msg = [Microsoft][SQL Server Native Client 11.0][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint. (CC_OdbcDBStatement::executeSelect, file CC_OdbcDBStatement.cpp, line 1,531)
Can you run data quality rules against Microsoft SQL DW?
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Can you run data quality rules against Microsoft SQL DW?
Does anyone know if Information Analyzer is supported for use against Microsoft Azure SQL Data Warehouse? I am getting an error when I try to run a simple DQ rule and its looks like IA is trying to use query cursors via the ODBC or JDBC connector which is not supported by the database:
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn