Can you run data quality rules against Microsoft SQL DW?
Posted: Sun Jul 22, 2018 10:52 pm
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:
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)